trees

Custom SQL query returning 37 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1588 260075 4 63 171X Gellert Dr 1 Median : Yard Tree 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1901 262254 6 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
4567 261551 6 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
5675 261201 1 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
6140 243478 1 63 1499X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree 2     0 3x3   6008755.36846 2097659.39973 37.7402676797185 -122.412285110476 (37.7402676797185, -122.412285110476) 10 7 7 28859 2
7702 262097 1 63 10x Cuesta Ct 1 Unaccepted Street : Yard Tree 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
8023 121696 4 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
9305 251160 1 63 1100X Portola Dr 1 Median : Cutout Tree 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
10043 264733 1 63 1367 De Haro St   Median : Cutout Tree 1       3x3   6012260 2102130 37.7527390251575 -122.400481372119 (37.7527390251575, -122.400481372119) 10 3 8 28856 29
10229 264894 6 63 56 Keystone Way 1 Back Yard : Yard Tree 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
12407 115154 1 63 245x ARLINGTON ST 3 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
12450 261565 1 63 1801 26th St 2 Sidewalk: Property side : Yard Tree 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
15519 262098 1 63 10x Cuesta Ct 2 Unaccepted Street : Yard Tree 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
16552 261549 1 63 3101 Sunset Blvd 1 Median : Cutout Tree 2       3x3   5984952 2094961 37.7314941488449 -122.494387573147 (37.7314941488449, -122.494387573147) 1 8 4 64 35
17261 261487 1 63 1100X Portola Dr 2 Median : Cutout Tree 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
29057 116956 6 63 380 SAN JOSE AVE 1 Front Yard : Cutout Tree 2     28 3x3   6006172 2100967 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126) 2 4 5 28859 19
36915 117645 6 63 2901 21ST AVE 1 Back Yard : Yard Tree 2       3x3   5989904 2095901 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
66441 109838 6 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
85334 256616 4 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
87762 117289 4 63 26X GLADEVIEW WAY 1 Sidewalk: Curb side : Yard Tree 2       3x3   5997876 2101605 37.7504848455829 -122.450185761312 (37.7504848455829, -122.450185761312) 1 5 4 63 38
93601 115152 1 63 245x ARLINGTON ST 1 Median : Yard Tree 1     30 3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
97461 115155 1 63 245x ARLINGTON ST 4 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
105080 173727 1 63 958 Carolina St 1 Sidewalk: Curb side : Cutout Tree 1     9 3x3   6012430 2103470 37.7564278519739 -122.399987571177 (37.7564278519739, -122.399987571177) 10 3 8 28856 29
105484 115153 1 63 245x ARLINGTON ST 2 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
106034 255453 4 63 90 Kiska Rd 1 Front Yard : Yard Tree 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
106870 117252 6 63 2500x 34TH AVE 2 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
120346 98601 4 63 301 Twin Peaks Blvd 1 Sidewalk: Property side : Cutout Tree 2     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479) 15 5 5 63 3
126197 115156 1 63 245x ARLINGTON ST 5 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
133744 117251 6 63 2500x 34TH AVE 1 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
139657 256152 4 63 80X Peralta Ave 1 Median : Cutout Tree 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
140522 121695 4 63 1300x De Haro St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
142225 23579 1 63 3100X Van Ness Ave 2 Median : Cutout Tree 1     42 3x3   6005511.92719 2121098.11811 37.8044422083102 -122.425167011149 (37.8044422083102, -122.425167011149) 5 1 1 28858 32
148910 110143 1 63 1130X PORTOLA DR 3 Sidewalk: Curb side : Yard Tree 1       3x3   5994964 2098019 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
156992 253621 6 63 200x Montcalm St 1 Back Yard : Yard Tree 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
163885 115556 4 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
176886 117253 6 63 2500x 34TH AVE 3 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
179258 121697 4 63 1300x De Haro St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29