trees

Custom SQL query returning 60 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
8728 96402 5 14 2160 36th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/12/2011 12:00:00 AM 1 2x3   5985141.5215 2100472.7854 37.7466391224256 -122.494138462065 (37.7466391224256, -122.494138462065) 1 8 3 29491 35
3241 31650 5 14 3632 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2   08/07/2015 12:00:00 AM 3   Permit Number 35160 5981711.46236471 2097421.70961548 37.7380604052223 -122.505772893936 (37.7380604052223, -122.505772893936) 1 8 3 29491 35
194448 265090 5 1 215 Montana St 1 Sidewalk: Curb side : Cutout Tree 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 784731 5994883.78198 2089306.03852 37.7165432206381 -122.459642300713 (37.7165432206381, -122.459642300713) 9 8 6 28861 24
194351 265046 5 13 1250 Eucalyptus Dr 4 Sidewalk: Property side : Yard Tree 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194349 265045 5 17 1250 Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194343 265044 5 22 1250 Eucalyptus Dr 3 Sidewalk: Property side : Yard Tree 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194346 265043 5 22 1250 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
6557 264929 5 6 4725 Irving St 1 Sidewalk: Curb side : Cutout Tree 2   11/12/2020 12:00:00 AM 3 3x3 Permit Number 784398 5981118.81181 2106198.14775 37.7621231273763 -122.508473270866 (37.7621231273763, -122.508473270866) 1 8 3 56 35
15881 264923 5 13 250 Urbano Dr 2 Sidewalk: Property side : Yard Tree 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
6755 264922 5 13 250 Urbano Dr 1 Sidewalk: Property side : Yard Tree 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
3554 264866 5 186 10X Selma Way 8 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5474 264865 5 186 10X Selma Way 7 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5206 264864 5 186 10X Selma Way 6 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
8122 264863 5 186 10X Selma Way 5 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
12645 264862 5 186 10X Selma Way 4 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
6005 264861 5 186 10X Selma Way 3 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5321 264860 5 186 10X Selma Way 2 Unaccepted Street : Yard Tree 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
591 264763 5 3 274 Victoria St 1 Sidewalk: Property side : Cutout Tree 2   10/05/2020 12:00:00 AM 3 3x3 Permit Number 781692 5993256.27541 2089011.86791 37.7156417766237 -122.465246370223 (37.7156417766237, -122.465246370223) 9 8 6 64 24
194494 264749 5 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12
16964 264738 5 7 2722 42nd Ave 1 Sidewalk: Property side : Cutout Tree 2   09/29/2020 12:00:00 AM 3 3x6 Permit Number 781841 5983409.1923 2096639.50516 37.7360124610612 -122.499845290879 (37.7360124610612, -122.499845290879) 1 8 3 29491 35
4564 264686 5 13 2455 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/15/2020 12:00:00 AM 3 3x3 Permit Number 782284 5990129.23032 2098669.31502 37.7419778589065 -122.476759924113 (37.7419778589065, -122.476759924113) 1 8 3 29491 35
8745 262534 5 11 2401 17th Ave 5 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991046.77559 2098937.57906 37.7427676232348 -122.473606942703 (37.7427676232348, -122.473606942703) 1 8 4 29491 40
5386 262533 5 11 2401 17th Ave 4 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991046.77559 2098937.57906 37.7427676232348 -122.473606942703 (37.7427676232348, -122.473606942703) 1 8 4 29491 40
9833 262515 5 149 1951 34th Ave 1 Sidewalk: Property side : Cutout Tree 2   08/07/2020 12:00:00 AM 3 3x3 Permit Number 779100 5985670.12137 2101944.25665 37.7507102998335 -122.49241898675 (37.7507102998335, -122.49241898675) 1 8 3 29491 35
4810 262420 5 19 101 Brighton Ave 4 Sidewalk: Curb side : Cutout Tree 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
7952 262419 5 19 101 Brighton Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
3414 262418 5 19 101 Brighton Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
11539 262395 5 14 2755 40th Ave 1 Sidewalk: Property side : Cutout Tree 2   07/21/2020 12:00:00 AM 3 3x3 Permit Number 784406 5983997.14788 2096421.7593 37.7354490751144 -122.497796450434 (37.7354490751144, -122.497796450434) 1 8 3 29491 35
7739 262320 5 18 2567 31st Ave 1 Sidewalk: Property side : Cutout Tree 2   07/07/2020 12:00:00 AM 3 6x10 Permit Number 785009 5986744.29234 2097795.22153 37.7393809030196 -122.48839957369 (37.7393809030196, -122.48839957369) 1 8 3 29491 35
11800 262282 5 13 10 Niantic Ave 3 Sidewalk: Curb side : Cutout Tree 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
3880 262281 5 13 10 Niantic Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
1059 262280 5 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
9135 262279 5 1 15 Corona St 2 Sidewalk: Property side : Cutout Tree 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
7830 262278 5 1 15 Corona St 1 Sidewalk: Property side : Cutout Tree 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
11626 262262 5 1 1324 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/19/2020 12:00:00 AM 3 4x4 Permit Number 784290 5993653.14185 2106470.72632 37.763602309694 -122.465141974097 (37.763602309694, -122.465141974097) 1 8 11 56 12
16663 262231 5 11 42 Dorantes Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/10/2020 12:00:00 AM 3 3x3 Permit Number 782723 5994180.46761 2100058.80006 37.7460271985036 -122.462852932256 (37.7460271985036, -122.462852932256) 1 8 4 29491 40
13211 262230 5 11 42 Dorantes Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/10/2020 12:00:00 AM 3 3x3 Permit Number 782723 5994180.46761 2100058.80006 37.7460271985036 -122.462852932256 (37.7460271985036, -122.462852932256) 1 8 4 29491 40
18205 262139 5 51 1582 46th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/08/2020 12:00:00 AM 3 3x3 Permit Number 782766 5981929 2104333 37.7570496794991 -122.505532928251 (37.7570496794991, -122.505532928251) 1 8 3 56 35
14595 262138 5 1 1118 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/07/2020 12:00:00 AM 3 3x3 Permit Number 783072 5995073.28586 2091364.23184 37.7222054253906 -122.459136235782 (37.7222054253906, -122.459136235782) 9 8 4 28861 24
8961 260880 5 11 2395 29th Ave 3 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
18095 260879 5 11 2395 29th Ave 2 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
14443 260878 5 11 2395 29th Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
19533 259217 5 19 200 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996177 2090586 37.7201319742324 -122.455264770625 (37.7201319742324, -122.455264770625) 9 8 6 28861 24
18566 256863 5 3 274 Victoria St 1 Sidewalk: Property side : Cutout Landscaping 2   12/19/2018 12:00:00 AM 3 3x8 Permit Number 781692 5993256.27541 2089011.86791 37.7156417766237 -122.465246370223 (37.7156417766237, -122.465246370223) 9 8 6 64 24
7163 255651 5 186 10X Selma Way 1 Unaccepted Street : Yard Tree 2       10x100 Permit Number 783039 5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
18260 164230 5 11 2401 17th Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991046.77559 2098937.57906 37.7427676232348 -122.473606942703 (37.7427676232348, -122.473606942703) 1 8 4 29491 40
15653 164229 5 11 2401 17th Ave 2 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991045.42225 2098958.21862 37.7428242157788 -122.47361312736 (37.7428242157788, -122.47361312736) 1 8 4 29491 40
15035 164228 5 11 2401 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991043.64805 2099007.36638 37.7429590601275 -122.473622846338 (37.7429590601275, -122.473622846338) 1 8 4 29491 40
9475 163463 5 32 109 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/24/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995872.36784 2087580.2575 37.7118614273349 -122.456100577893 (37.7118614273349, -122.456100577893) 9 8 6 28861 24
10091 163462 5 32 115 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995871.2375 2087597.30845 37.7119081803938 -122.45610571662 (37.7119081803938, -122.45610571662) 9 8 6 28861 24
19607 163461 5 32 115 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.30801 2087623.97935 37.7119813591246 -122.456110856234 (37.7119813591246, -122.456110856234) 9 8 6 28861 24
17374 163460 5 32 115 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.33981 2087649.24929 37.7120507463226 -122.45611257216 (37.7120507463226, -122.45611257216) 9 8 6 28861 24
4243 162646 5 19 101 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
7146 112795 5 13 1235 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.7637354441658 -122.499848016409 (37.7637354441658, -122.499848016409) 1 8 3 56 35
7524 111636 5 22 2625 35TH AVE 1 Sidewalk: Curb side : Cutout Tree 2   06/16/2015 12:00:00 AM 3 3x3   5985486 2097347 37.7380767082098 -122.492717127165 (37.7380767082098, -122.492717127165) 1 8 3 29491 35
12144 111632 5 17 1758 36th Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3 Permit Number 774682 5985071 2103231.6 37.7542099449347 -122.49458566251 (37.7542099449347, -122.49458566251) 1 8 3 56 35
9406 111316 5 17 3400x Wawona St 4 Sidewalk: Property side : Cutout Tree 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35
2057 111315 5 17 3400x Wawona St 3 Sidewalk: Property side : Cutout Tree 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35
16827 111314 5 17 3400x Wawona St 2 Sidewalk: Property side : Cutout Tree 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35
17482 111313 5 17 3400x Wawona St 1 Sidewalk: Property side : Cutout Tree 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35