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)
96902 49855 7 135 600@ WOODSIDE Portola Dr 4 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
100199 36676 7 135 99X ALBION ST 4 Sidewalk: Curb side : Cutout Tree 2   05/22/1998 12:00:00 AM 14 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
140924 35772 7 135 3692 18th St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 12/05/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
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
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
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
5959 36677 7 135 99X ALBION ST 5 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
17405 42004 7 135 240 Manor Dr 5 Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42337 5993892.40263021 2094032.39552185 37.7294635953142 -122.463411763134 (37.7294635953142, -122.463411763134) 9 8 4 59 40
61682 31428 7 135 4220 21st St 5 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
77833 41806 7 135 100 Anzavista Ave 5 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
85783 42930 7 135 500 Florida St 5 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42831 6009210.68116468 2105903.38929548 37.7629293730529 -122.411293045793 (37.7629293730529, -122.411293045793) 8 4 7 28859 19
90866 49848 7 135 600@ WOODSIDE Portola Dr 5 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
105286 108275 6 135 1800x ALAMEDA ST 5 Front Yard : Cutout Tree 2     15     6011533 2107928 37.7686184708296 -122.403403344125 (37.7686184708296, -122.403403344125) 8 2 8 28853 20
122099 35725 7 135 190 Dartmouth St 5 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
138165 120510 4 135 888 Brannan St 5 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
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
64072 120511 4 135 888 Brannan St 6 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
104344 49850 7 135 600@ WOODSIDE Portola Dr 6 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
106159 42006 7 135 240 Manor Dr 6 Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42337 5993892.40263021 2094032.39552185 37.7294635953142 -122.463411763134 (37.7294635953142, -122.463411763134) 9 8 4 59 40
135724 41805 7 135 100 Anzavista Ave 6 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
140793 39791 7 135 50 San Jose Ave 6 Sidewalk: Curb side : Cutout Tree 2 FUF 01/19/1999 12:00:00 AM     Permit Number 41142 6006177.81610853 2102875.29261487 37.7544443606741 -122.421567620452 (37.7544443606741, -122.421567620452) 2 4 5 28859 19
4414 49854 7 135 600@ WOODSIDE Portola Dr 7 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
35666 42007 7 135 240 Manor Dr 7 Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42337 5993892.40263021 2094032.39552185 37.7294635953142 -122.463411763134 (37.7294635953142, -122.463411763134) 9 8 4 59 40
80558 41813 7 135 100 Anzavista Ave 7 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
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
65076 49849 7 135 600@ WOODSIDE Portola Dr 8 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
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
57836 41810 7 135 100 Anzavista Ave 9 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
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