trees

Custom SQL query returning 19 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1781 259401 1 205 1851 Newhall St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 10/13/2018 12:00:00 AM 3 3x4   6013660.95601 2094668.87428 37.7323303677695 -122.395114009854 (37.7323303677695, -122.395114009854) 10 3 8 58 1
12062 259364 1 205 1553 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF         6015326.61891 2094194.43937 37.7311201525136 -122.389322261551 (37.7311201525136, -122.389322261551) 10 3 8 58 1
12955 193527 1 205 2525 Phelps St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6012134.12036 2093726.86436 37.7296587777324 -122.400326524868 (37.7296587777324, -122.400326524868) 10 3 8 58 1
18839 259359 1 205 1470 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 05/25/2019 12:00:00 AM 3     6015792.03244 2093898.47534 37.7303332862111 -122.387692589701 (37.7303332862111, -122.387692589701) 10 3 8 58 1
19099 113032 1 205 251 06th Ave 3 Sidewalk: Curb side : Cutout Tree 4     3 3x3   5993973.41927 2113841.38508 37.7838586397785 -122.464569471656 (37.7838586397785, -122.464569471656) 11 6 2 54 11
35554 3584 1 205 100X Cargo Way 19 Sidewalk: Curb side : Cutout Tree 6   12/11/1998 12:00:00 AM 3 3X3   6018506.82441 2097843.80813 37.7413163998229 -122.378580911506 (37.7413163998229, -122.378580911506) 10 3 8 58 1
49190 3634 1 205 100X Cargo Way 70 Sidewalk: Curb side : Cutout Tree 6     6 3X3   6017632.60306 2098495.95511 37.7430588336066 -122.381649036799 (37.7430588336066, -122.381649036799) 10 3 8 58 1
76384 3647 1 205 100X Cargo Way 83 Sidewalk: Curb side : Cutout Tree 6   05/31/1996 12:00:00 AM 3 3X3   6017425.17191 2098677.66921 37.7435463281955 -122.382378924746 (37.7435463281955, -122.382378924746) 10 3 8 58 1
79530 3657 1 205 100X Cargo Way 93 Sidewalk: Curb side : Cutout Tree 6     12 3X3   6017283.49959 2098800.90892 37.7438768929081 -122.382877372202 (37.7438768929081, -122.382877372202) 10 3 8 58 1
86496 28490 1 205 1499X Dolores St 2 Sidewalk: Curb side : Cutout Tree 1   12/08/2003 12:00:00 AM 12 3X3   6005277.9300739 2099610.0882818 37.7454280803333 -122.42444742702 (37.7454280803333, -122.42444742702) 2 7 5 28859 22
95018 3626 1 205 100X Cargo Way 62 Sidewalk: Curb side : Cutout Tree 6     12 3X3   6017765.80037 2098395.89545 37.7427914435713 -122.381181516112 (37.7427914435713, -122.381181516112) 10 3 8 58 1
125045 3659 1 205 100X Cargo Way 95 Sidewalk: Curb side : Cutout Tree 6     12 3X3   6017251.66004 2098826.19142 37.7439445542915 -122.382989226284 (37.7439445542915, -122.382989226284) 10 3 8 58 1
185262 3648 1 205 100X Cargo Way 84 Sidewalk: Curb side : Cutout Tree 6   05/31/1996 12:00:00 AM 3 3X3   6017409.48154 2098690.6025 37.7435809736936 -122.382434078367 (37.7435809736936, -122.382434078367) 10 3 8 58 1
43754 43977 7 205 39 Homestead St 1 Sidewalk: Curb side : Cutout Tree 2   06/07/2016 12:00:00 AM 3   Permit Number 778501 6000993.81514185 2101486.77683791 37.7503381602792 -122.439395674198 (37.7503381602792, -122.439395674198) 2 4 5 28862 22
103819 43976 7 205 39 Homestead St 2 Sidewalk: Curb side : Cutout Tree 2   08/24/2000 12:00:00 AM 3   Permit Number 778501 6000993.81514185 2101486.77683791 37.7503381602792 -122.439395674198 (37.7503381602792, -122.439395674198) 2 4 5 28862 22
142877 57275 7 205 43 Homestead St 1 Sidewalk: Curb side : Cutout Tree 2   01/10/1975 12:00:00 AM 3   Permit Number 778501 6000995.09395251 2101464.42922438 37.7502768718683 -122.439389650282 (37.7502768718683, -122.439389650282) 2 4 5 28862 22
154705 116791 7 205 700x ANDERSON ST 1 Sidewalk: Curb side : Cutout Tree 2     2 3x3   6007719 2095661 37.7347223035732 -122.415727003996 (37.7347223035732, -122.415727003996) 2 7 7 28859 2
176094 117323 7 205 43 Homestead St 1 Sidewalk: Curb side : Cutout Tree 2     3   Permit Number 778501 6001062.3 2101454.3 37.7502528838659 -122.439156522004 (37.7502528838659, -122.439156522004) 2 4 5 28862 22
103402 3610 9 205 100X Cargo Way 46 Sidewalk: Curb side : Cutout Tree 6     6 3X3   6018056.23038 2098180.90993 37.7422171644003 -122.380162344118 (37.7422171644003, -122.380162344118) 10 3 8 58 1