API tools faq
paste
Advertisement
RPaulW

tinyows.log

RPaulW
May 30th, 2022
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.73 KB | None | 0 0
raw download clone embed print report
  1. [Mon May 30 14:11:21 2022] [EVENT] == TINYOWS STARTUP ==
  2. [Mon May 30 14:11:21 2022] [SQL] SELECT substr(postgis_full_version(), 10, 5)
  3. [Mon May 30 14:11:21 2022] [EVENT] == Connection PostGIS ==
  4. [Mon May 30 14:11:21 2022] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
  5. [Mon May 30 14:11:22 2022] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
  6. [Mon May 30 14:11:22 2022] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='citylkpt21';
  7. [Mon May 30 14:11:22 2022] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=26917 AND proj4text like '%%units=m%%'
  8. [Mon May 30 14:11:22 2022] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE c.table_schema=n.nspname AND n.nspname = 'public' AND c.table_name = 'citylkpt21' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'citylkpt21' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
  9. [Mon May 30 14:11:22 2022] [SQL] SELECT pg_get_serial_sequence('public."citylkpt21"', 'saopyr_id');
  10. [Mon May 30 14:11:22 2022] [SQL] SELECT column_default FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'citylkpt21' AND column_name = 'saopyr_id' AND table_catalog = current_database();
  11. [Mon May 30 14:11:22 2022] [SQL] SELECT a.attname AS field, t.typname AS type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public' AND c.relname = 'citylkpt21' AND c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND a.attnum > 0;
  12. [Mon May 30 14:11:22 2022] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='citylkpt21' and f_geometry_column='geom';
  13. [Mon May 30 14:11:22 2022] [SQL] SELECT a.attname AS field FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public' AND c.relname = 'citylkpt21' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND a.attnotnull = 't'
  14. [Mon May 30 14:11:22 2022] [EVENT] == Filling Storage ==
  15. [Mon May 30 14:11:22 2022] [EVENT] == FCGI START ==
  16. [Mon May 30 14:11:22 2022] [QUERY] <GetFeature xmlns=http://www.opengis.net/wfs service="WFS" version="1.1.0" outputFormat="text/xml; subtype=gml/2.1.2" xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xsi:schemaLocation=http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd><Query typeName="Geomoose:citylkpt21" srsName="EPSG:3857"><Filter xmlns=http://www.opengis.net/ogc><Intersects><PropertyName>geom</PropertyName><Polygon xmlns=http://www.opengis.net/gml><exterior><LinearRing><posList srsDimension="2">-8760292.840285044 5336974.8151254915 -8760292.840285044 5336997.240744488 -8760270.41466605 5336997.240744488 -8760270.41466605 5336974.8151254915 -8760292.840285044 5336974.8151254915</posList></LinearRing></exterior></Polygon></Intersects></Filter></Query></GetFeature>
  17. [Mon May 30 14:11:22 2022] [SQL] SELECT auth_name, auth_srid, proj4text, srtext FROM spatial_ref_sys WHERE srid = '3857'
  18. [Mon May 30 14:11:22 2022] [SQL] SELECT ST_GeomFromGML('<Polygon xmlns=http://www.opengis.net/gml xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance><exterior><LinearRing><posList srsDimension="2">-8760292.840285044 5336974.8151254915 -8760292.840285044 5336997.240744488 -8760270.41466605 5336997.240744488 -8760270.41466605 5336974.8151254915 -8760292.840285044 5336974.8151254915</posList></LinearRing></exterior></Polygon>',3857)
  19. [Mon May 30 14:11:22 2022] [SQL] SELECT ST_IsValid('0103000020110F00000100000005000000769DE39A7CB560C11C042BB4E35B5441769DE39A7CB560C1925B684FE95B5441BCF144CD79B560C1925B684FE95B5441BCF144CD79B560C11C042BB4E35B5441769DE39A7CB560C11C042BB4E35B5441')
  20. [Mon May 30 14:11:22 2022] [SQL] SELECT ST_SRID('0103000020110F00000100000005000000769DE39A7CB560C11C042BB4E35B5441769DE39A7CB560C1925B684FE95B5441BCF144CD79B560C1925B684FE95B5441BCF144CD79B560C11C042BB4E35B5441769DE39A7CB560C11C042BB4E35B5441'::geometry)
  21. [Mon May 30 14:11:22 2022] [SQL] SELECT ST_xmin(g.extent), ST_ymin(g.extent), ST_xmax(g.extent), ST_ymax(g.extent) FROM (SELECT ST_Extent(foo.the_geom) as extent FROM ( (SELECT ST_Transform("geom"::geometry, 3857) AS "the_geom" FROM "public"."citylkpt21" WHERE ST_Intersects("geom",ST_Transform(ST_SetSRID('0103000020110F00000100000005000000769DE39A7CB560C11C042BB4E35B5441769DE39A7CB560C1925B684FE95B5441BCF144CD79B560C1925B684FE95B5441BCF144CD79B560C11C042BB4E35B5441769DE39A7CB560C11C042BB4E35B5441'::geometry,3857),26917))) ) AS foo) AS g
  22. [Mon May 30 14:11:22 2022] [SQL] SELECT "saopyr_id",ST_AsGML(ST_Transform("geom"::geometry,3857),0,0) AS "geom" ,"print_key","roll_yr","parcel_id","owner","street_nbr","street","full_parcel_adress","type_of_property","building_style","sbl","usd_land_assesed_value","usd_total_assesed_value","usd_county_taxable_value","usd_town_taxable_value","usd_school_taxable_value","usd_village_taxable_value","usd_star_town_taxable_value","usd_star_school_taxable_value","usd_total_assesed_value_sqft","deed_book","deed_page","usd_full_market_value","yr_built","usd_sales_price","usd_sales_price_sqft","sales_date","usd_exeption_amount","surface_building_square_footage","surface_lot_size","bathroom_nbr","bedroom_nbr","fireplace_nbr","basement_type","nbhd_code","admin_nbhd_code","image_path" FROM "public"."citylkpt21" WHERE ST_Intersects("geom",ST_Transform(ST_SetSRID('0103000020110F00000100000005000000769DE39A7CB560C11C042BB4E35B5441769DE39A7CB560C1925B684FE95B5441BCF144CD79B560C1925B684FE95B5441BCF144CD79B560C11C042BB4E35B5441769DE39A7CB560C11C042BB4E35B5441'::geometry,3857),26917))
  23. [Mon May 30 14:11:22 2022] [EVENT] == FCGI SHUTDOWN ==
  24. [Mon May 30 14:11:22 2022] [EVENT] == TINYOWS SHUTDOWN ==
  25.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!