trees

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
141302 42940 7 135 90 14TH ST 3 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42835 6008035 2107992 37.768598204142 -122.415507210488 (37.768598204142, -122.415507210488) 8 4 7 28853 19
141366 37974 7 135 1199 Tennessee St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
145313 108139 4 135 3390x 18TH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006957.7 2105612.4 37.7620037686995 -122.419064704614 (37.7620037686995, -122.419064704614) 8 4 7 28859 19
147883 49851 7 135 600@ WOODSIDE Portola Dr 1 Sidewalk: Curb side : Cutout Tree 2   06/18/2003 12:00:00 AM     Permit Number 46628 5997402.05166497 2099836.0241137 37.7456005399249 -122.451697110084 (37.7456005399249, -122.451697110084) 1 7 4 59 40
148604 120514 4 135 888 Brannan St 9 Sidewalk: Curb side : Cutout Tree 2   01/05/2017 12:00:00 AM 3 3x3 Permit Number 778696 6011018 2109170 37.7719999408521 -122.405272169822 (37.7719999408521, -122.405272169822) 14 2 9 28853 34
148886 31424 7 135 4220 21st St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/01/1995 12:00:00 AM     Permit Number 35007 6001430.13223279 2103389.64483278 37.7555877996488 -122.438023150412 (37.7555877996488, -122.438023150412) 2 4 5 28862 3
154574 49853 7 135 600@ WOODSIDE Portola Dr 2 Sidewalk: Curb side : Cutout Tree 2   06/18/2003 12:00:00 AM     Permit Number 46628 5997402.05166497 2099836.0241137 37.7456005399249 -122.451697110084 (37.7456005399249, -122.451697110084) 1 7 4 59 40
154906 120513 4 135 888 Brannan St 8 Sidewalk: Curb side : Cutout Tree 2   01/05/2017 12:00:00 AM 3 3x3 Permit Number 778696 6011018 2109170 37.7719999408521 -122.405272169822 (37.7719999408521, -122.405272169822) 14 2 9 28853 34
157931 34535 7 135 65 Bradford St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/25/1997 12:00:00 AM     Permit Number 38244 6009619.36143098 2098302.27912824 37.7420813311149 -122.409343112846 (37.7420813311149, -122.409343112846) 10 7 7 28859 2
158357 41804 7 135 100 Anzavista Ave 8 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42201 6000031.62407676 2112183.77888854 37.7796546591332 -122.443491289074 (37.7796546591332, -122.443491289074) 15 5 1 29490 16
160870 37512 7 135 835 Geary St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/22/1998 12:00:00 AM 12 3x3 Permit Number 39970 6007729.27336023 2114396.12651658 37.786165215164 -122.417018514766 (37.786165215164, -122.417018514766) 13 1 9 28858 36
161093 49852 7 135 600@ WOODSIDE Portola Dr 3 Sidewalk: Curb side : Cutout Tree 2   06/18/2003 12:00:00 AM     Permit Number 46628 5997402.05166497 2099836.0241137 37.7456005399249 -122.451697110084 (37.7456005399249, -122.451697110084) 1 7 4 59 40
163105 35773 7 135 3692 18th St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/21/1998 12:00:00 AM     Permit Number 39030 6004971.89537308 2105472.67366607 37.7615080868858 -122.425922888595 (37.7615080868858, -122.425922888595) 8 4 5 28859 19
163641 108141 4 135 3390x 18TH ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006957.7 2105612.4 37.7620037686995 -122.419064704614 (37.7620037686995, -122.419064704614) 8 4 7 28859 19
165649 48501 7 135 1005(REVISED) Noe St 1 Sidewalk: Curb side : Cutout Tree 2   08/22/2002 12:00:00 AM     Permit Number 45840 6003172.67516889 2102390.65351866 37.7529437493543 -122.43192556655 (37.7529437493543, -122.43192556655) 2 4 5 28862 22
166213 110334 1 135 53x DEARBORN ST 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6005854 2105793 37.7624374394694 -122.422894814814 (37.7624374394694, -122.422894814814) 8 4 5 28859 19
166407 49936 7 135 2526 26th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/02/2003 12:00:00 AM     Permit Number 46695 5988331.02491105 2098109.84036386 37.7403372178988 -122.482936471841 (37.7403372178988, -122.482936471841) 1 8 3 29491 35
166864 63865 7 135 1000 Steiner St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24568 6002960.35246681 2111688.65043181 37.7784617483317 -122.433324169044 (37.7784617483317, -122.433324169044) 15 9 11 29490 41
167468 115993 4 135 4179 20TH ST 1 Sidewalk: Curb side : Cutout Tree 2     17 3x3   6002572 2104053 37.7574740849474 -122.434121637983 (37.7574740849474, -122.434121637983) 2 4 5 28862 3
171263 42049 7 135 405 Duncan St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/2000 12:00:00 AM     Permit Number 779344 6003892.7703069 2099803.34109747 37.7458803892155 -122.42925086473 (37.7458803892155, -122.42925086473) 2 7 5 63 22
174066 36680 7 135 99X ALBION ST 3 Sidewalk: Curb side : Cutout Tree 2   05/22/1998 12:00:00 AM 16 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
174608 120512 4 135 888 Brannan St 7 Sidewalk: Curb side : Cutout Tree 2   01/05/2017 12:00:00 AM 3 3x3 Permit Number 778696 6011018 2109170 37.7719999408521 -122.405272169822 (37.7719999408521, -122.405272169822) 14 2 9 28853 34
174894 120647 4 135 69x Dearborn St 1 Sidewalk: Property side : Cutout Tree 2   09/22/2016 12:00:00 AM 3 3x3   6005880 2105692 37.7621615842697 -122.422797712098 (37.7621615842697, -122.422797712098) 8 4 5 28859 19
176985 31427 7 135 4220 21st St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 05/01/1995 12:00:00 AM     Permit Number 35007 6001430.13223279 2103389.64483278 37.7555877996488 -122.438023150412 (37.7555877996488, -122.438023150412) 2 4 5 28862 3
179746 42938 7 135 90 14TH ST 5 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42835 6008035 2107992 37.768598204142 -122.415507210488 (37.768598204142, -122.415507210488) 8 4 7 28853 19
180921 82202 7 135 3170-3172 25th St 1 Sidewalk: Curb side : Cutout Tree 2   01/08/2008 12:00:00 AM 10 3x3 Permit Number 50066 6008538.87748807 2101576.58279524 37.751011244921 -122.413310594546 (37.751011244921, -122.413310594546) 2 4 7 28859 19
182141 41803 7 135 100 Anzavista Ave 10 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42201 6000031.62407676 2112183.77888854 37.7796546591332 -122.443491289074 (37.7796546591332, -122.443491289074) 15 5 1 29490 16
183474 96697 1 135 1599X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6015060.5348 2095438.80494 37.7345221731935 -122.390329076986 (37.7345221731935, -122.390329076986) 10 3 8 58 1
186027 42505 7 135 38 Staples Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42619 5999722.01782737 2093803.77353128 37.7291699982135 -122.443241867584 (37.7291699982135, -122.443241867584) 9 7 4 63 40
189513 35724 7 135 190 Dartmouth St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 04/14/1998 12:00:00 AM     Permit Number 39007 6008565.46175199 2093223.89460892 37.7280780839519 -122.412628258541 (37.7280780839519, -122.412628258541) 9 3 7 309 28