trees

Custom SQL query returning 29 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
16984 203543 1 65 518 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5997969.26989 2094410.6553 37.7307362500808 -122.449344943519 (37.7307362500808, -122.449344943519) 9 7 4 59 40
20543 203531 1 65 355 Granada Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 Width 2ft   5995610.31086 2092357.07195 37.7249623857941 -122.457351672459 (37.7249623857941, -122.457351672459) 9 7 4 28861 40
23012 97550 7 65 199x FLOOD AVE 2 Sidewalk: Curb side : Cutout Tree 2     1 3x3 Permit Number 42524 5999753 2094070 37.7299027608053 -122.443153872698 (37.7299027608053, -122.443153872698) 9 7 4 63 40
40890 203565 1 65 33 Pinehurst Way 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5993248.53272 2093275.53129 37.7273483150682 -122.465582702207 (37.7273483150682, -122.465582702207) 9 8 4 59 40
45238 175213 1 65 87x Valmar Ter 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6005270.21686 2092560.99775 37.7260724207817 -122.423972920124 (37.7260724207817, -122.423972920124) 9 7 7 309 5
46307 203579 1 65 312 Joost Ave 2 Sidewalk: Property side : Yard Tree 2     14 Width 6ft   5999939.25303 2094981.39881 37.7324158679899 -122.44257538767 (37.7324158679899, -122.44257538767) 9 7 4 63 40
52355 175197 1 65 701 Peru Ave 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 5ft   6005286.47432 2092498.92071 37.7259028886841 -122.423912306729 (37.7259028886841, -122.423912306729) 9 7 7 309 5
55860 175179 1 65 450 Italy Ave 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 2ft   6001771.83891 2089201.36797 37.7166495024579 -122.43582630935 (37.7166495024579, -122.43582630935) 9 7 6 28861 5
67282 203548 1 65 181 Flood Ave 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5999484.36005 2094058.99303 37.7298572167403 -122.444081798854 (37.7298572167403, -122.444081798854) 9 7 4 63 40
102836 203534 1 65 149 Casitas Ave 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 2ft   5995350.02472 2096965.99603 37.7376024192215 -122.45858493525 (37.7376024192215, -122.45858493525) 9 7 4 59 40
107710 175194 1 65 522 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 Width 3ft   6004004.48398 2092477.2158 37.7257708331541 -122.428342513702 (37.7257708331541, -122.428342513702) 9 7 6 28861 5
118838 203560 1 65 145 Lakeview Ave 2 : Tree 2     1 Width 3ft   5997153.12879 2089368.29033 37.7168443846497 -122.451802840126 (37.7168443846497, -122.451802840126) 9 8 6 28861 24
123884 203541 1 65 510 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5998007.81838 2094409.85226 37.7307362500822 -122.449211618134 (37.7307362500822, -122.449211618134) 9 7 4 59 40
126749 175180 1 65 690 Athens St 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 4ft   6002933.07108 2089399.59548 37.7172596870602 -122.43182665728 (37.7172596870602, -122.43182665728) 9 7 6 28861 5
127453 203538 1 65 313 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 2ft   5999326.9827 2094355.31618 37.7306618716326 -122.444647158563 (37.7306618716326, -122.444647158563) 9 7 4 28861 40
130503 175177 1 65 763 Morse St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5998527.33807 2087102.13623 37.7107006525794 -122.44688991486 (37.7107006525794, -122.44688991486) 9 7 6 28861 5
146877 203582 1 65 24 Gennessee St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5997457.41638 2093726.64675 37.7288288329774 -122.451065185614 (37.7288288329774, -122.451065185614) 9 7 4 28861 40
156296 87374 7 65 149 Staples Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 50353 5999085.2 2093741.7 37.7289632252792 -122.445438930282 (37.7289632252792, -122.445438930282) 9 7 4 28861 40
159587 203566 1 65 209 Colon Ave 2 Sidewalk: Curb side : Yard Tree 2     17 Width 3ft   5996063.41122 2094232.89601 37.7301389635391 -122.455920909543 (37.7301389635391, -122.455920909543) 9 7 4 28861 40
159787 203555 1 65 209 Farallones St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 2ft   5994968.99544 2088379.28856 37.7140034838548 -122.459280689461 (37.7140034838548, -122.459280689461) 9 8 6 28861 24
188048 175198 1 65 648 Peru Ave 2 Side Yard : Yard Tree 2     12     6005048.079 2092617.03467 37.7262137420546 -122.424744822616 (37.7262137420546, -122.424744822616) 9 7 6 28861 5
73282 108847 1 65 970 Prague St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772762 6001586.13513 2086816.33243 37.7100901720951 -122.436297601751 (37.7100901720951, -122.436297601751) 9 7 6 28861 5
171813 35138 1 65 832 Naples St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 01/28/1998 12:00:00 AM 9   Permit Number 38668 6001976.8462 2088896.96126 37.7158253124776 -122.435095942923 (37.7158253124776, -122.435095942923) 9 7 6 28861 5
4556 35737 1 65 351 Hale St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/14/1998 12:00:00 AM 11   Permit Number 39011 6008822.29863 2094308.62612 37.7310709363673 -122.411816979173 (37.7310709363673, -122.411816979173) 9 3 7 309 28
91379 47054 7 65 149 Casitas Ave 2 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45042 5994940.24503133 2097052.6739603 37.7378168558175 -122.460008006142 (37.7378168558175, -122.460008006142) 9 7 4 59 40
111705 74111 4 65 500X Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/25/1994 12:00:00 AM 15 3x3   6003976.59234436 2092494.78352221 37.7258174919201 -122.428440184616 (37.7258174919201, -122.428440184616) 9 7 6 28861 5
13377 160452 1 65 99 France Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001241.76743 2090358.86031 37.719797591855 -122.437741350891 (37.719797591855, -122.437741350891) 9 7 6 28861 5
6932 112764 7 65 145 Lakeview Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 08/19/2015 12:00:00 AM     Permit Number 774164 5997123.4 2089342.1 37.7167707693614 -122.45190370908 (37.7167707693614, -122.45190370908) 9 8 6 28861 24
19536 160455 1 65 11 France Ave 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001161.40103 2090408.94535 37.719930544037 -122.438022734371 (37.719930544037, -122.438022734371) 9 7 6 28861 5