sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2164 10688 3 42 1221 Hayes St 1 1 1 2   11/18/1991 12:00:00 AM 6 3X3   6002001.6656 2110480.73 37.7750906677438 -122.43655414222 (37.7750906677438, -122.43655414222)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5792 10690 1 42 1233 Hayes St 1 1 1 1     6 3X3   6001959.267000001 2110474.8139 37.7750720141838 -122.43670038449801 (37.7750720141838, -122.436700384498)
8578 10632 1 42 830 Hayes St 1 1 1 1   08/02/1990 12:00:00 AM 12 3X3   6003878.786 2110787.057 37.7760382564385 -122.43008262774599 (37.7760382564385, -122.430082627746)
8838 10631 1 42 829 Hayes St 1 1 1 1   08/02/1990 12:00:00 AM 18 3X3   6003873.4823 2110738.4269 37.7759044297862 -122.430097504694 (37.7759044297862, -122.430097504694)
8970 10634 3 42 830 Hayes St 3 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003840.507 2110782.2115 37.7760227838468 -122.43021469913201 (37.7760227838468, -122.430214699132)
9300 1913 1 42 8 Bell Ct 2 1 1 1   12/16/1992 12:00:00 AM 3 3X3   6016615.0158522995 2095214.1533182 37.7339914292631 -122.384939021898 (37.7339914292631, -122.384939021898)
12141 17224 3 42 1880X Alemany Blvd 1 1 1 2     15 3X3   6001029.5778 2091188.70927 37.72206410195621 -122.43853424087601 (37.7220641019562, -122.438534240876)
12807 17229 3 42 1880X Alemany Blvd 6 1 1 2     14 3X3   6000980.939130001 2091103.3398799999 37.7218269300432 -122.438696258244 (37.7218269300432, -122.438696258244)
19047 23032 1 42 937 Valencia St 1 1 1 1   04/25/2003 12:00:00 AM 8 3X3   6006338.92475 2104110.62405 37.757845377874204 -122.42109817336599 (37.7578453778742, -122.421098173366)
65727 19285 3 42 1770 Scott St 5 1 1 2   06/01/1998 12:00:00 AM 11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
81411 24833 1 42 200X Alemany Blvd 11 1 1 5   01/12/1996 12:00:00 AM 25 3X3   6009416.6826304 2095906.0445619 37.735490432624104 -122.409874802768 (37.7354904326241, -122.409874802768)
82962 29220 3 42 1902X 41st Ave 3 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
86900 19282 3 42 1770 Scott St 2 1 1 2     11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
92157 29223 3 42 1902X 41st Ave 6 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
99251 19283 3 42 1770 Scott St 3 1 1 2     8 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
100029 19281 3 42 1770 Scott St 1 1 1 2     10 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
110361 29224 3 42 1902X 41st Ave 7 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
110460 25177 3 42 3076 Market St 1 1 1 2   04/19/1996 12:00:00 AM 30 3X3   6000054.6842234 2105404.3700399 37.7610414235505 -122.442924538729 (37.7610414235505, -122.442924538729)
121915 19284 3 42 1770 Scott St 4 1 1 2   06/01/1998 12:00:00 AM 9 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
Powered by Datasette · Query took 4.863ms · Data source: data.sfgov.org