trees
1,650 rows where qSpecies_id = 64 sorted by Longitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1646 | 19899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
3410 | 47847 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
3460 | 20048 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
4272 | 47849 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
8350 | 47846 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
8653 | 254419 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3400X Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781063 | ||||||||||
9818 | 47845 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
15628 | 47848 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
15929 | 20047 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
16797 | 47844 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
171373 | 201489 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 404 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6018812.86035 | 2095041.80461 | 37.7336395152478 | -122.37732835733 | (37.7336395152478, -122.37732835733) | 10 | 3 | 8 | 58 | 1 | ||||
185395 | 201490 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 404 Hawes St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6018801.89872 | 2095027.62617 | 37.7335999801502 | -122.377365271813 | (37.7335999801502, -122.377365271813) | 10 | 3 | 8 | 58 | 1 | ||||
105972 | 201491 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018753.58694 | 2094959.04146 | 37.7334089983181 | -122.377527543687 | (37.7334089983181, -122.377527543687) | 10 | 3 | 8 | 58 | 1 | ||||
87273 | 201492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018741.78505 | 2094936.24141 | 37.7333457436025 | -122.377566764894 | (37.7333457436025, -122.377566764894) | 10 | 3 | 8 | 58 | 1 | ||||
46234 | 201493 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6018736.96879 | 2094929.02833 | 37.7333256725358 | -122.377582915835 | (37.7333256725358, -122.377582915835) | 10 | 3 | 8 | 58 | 1 | ||||
155001 | 201494 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6018722.25822 | 2094905.40037 | 37.7332599842609 | -122.377632135729 | (37.7332599842609, -122.377632135729) | 10 | 3 | 8 | 58 | 1 | ||||
124507 | 189374 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017842.42691 | 2096472.87377 | 37.7375154403828 | -122.380782910515 | (37.7375154403828, -122.380782910515) | 10 | 3 | 8 | 58 | 1 | |||
86948 | 189373 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017841.36769 | 2096447.46788 | 37.7374456224015 | -122.380784807191 | (37.7374456224015, -122.380784807191) | 10 | 3 | 8 | 58 | 1 | |||
179891 | 189375 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017840.00731 | 2096483.57159 | 37.7375446809316 | -122.380792019749 | (37.7375446809316, -122.380792019749) | 10 | 3 | 8 | 58 | 1 | |||
12123 | 189376 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017838.12886 | 2096499.84024 | 37.7375892477372 | -122.380799645108 | (37.7375892477372, -122.380799645108) | 10 | 3 | 8 | 58 | 1 | |||
10994 | 189372 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017835.15635 | 2096405.7352 | 37.7373306899522 | -122.380803382685 | (37.7373306899522, -122.380803382685) | 10 | 3 | 8 | 58 | 1 | |||
68323 | 189358 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017825.61264 | 2096067.48761 | 37.736401402503 | -122.380812873212 | (37.736401402503, -122.380812873212) | 10 | 3 | 8 | 58 | 1 | |||
155269 | 189377 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017833.99487 | 2096515.69962 | 37.7376325662831 | -122.380815040593 | (37.7376325662831, -122.380815040593) | 10 | 3 | 8 | 58 | 1 | |||
70402 | 189371 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017827.39616 | 2096381.99519 | 37.7372650763112 | -122.380828563686 | (37.7372650763112, -122.380828563686) | 10 | 3 | 8 | 58 | 1 | |||
185936 | 189359 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017821.04017 | 2096083.03057 | 37.7364438280288 | -122.380829762495 | (37.7364438280288, -122.380829762495) | 10 | 3 | 8 | 58 | 1 | |||
128421 | 189360 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017818.67365 | 2096093.95102 | 37.7364736828066 | -122.380838703567 | (37.7364736828066, -122.380838703567) | 10 | 3 | 8 | 58 | 1 | |||
186951 | 189378 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017826.96829 | 2096535.22386 | 37.7376857881569 | -122.380840691967 | (37.7376857881569, -122.380840691967) | 10 | 3 | 8 | 58 | 1 | |||
84448 | 189370 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017823.73172 | 2096374.95367 | 37.737245539451 | -122.380840744109 | (37.737245539451, -122.380840744109) | 10 | 3 | 8 | 58 | 1 | |||
139074 | 189361 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017812.68284 | 2096124.68728 | 37.7365577478341 | -122.380861552625 | (37.7365577478341, -122.380861552625) | 10 | 3 | 8 | 58 | 1 | |||
90586 | 189362 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017812.44528 | 2096136.32972 | 37.7365897025526 | -122.380863183095 | (37.7365897025526, -122.380863183095) | 10 | 3 | 8 | 58 | 1 | |||
80688 | 189369 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017814.97814 | 2096356.1819 | 37.7371935127733 | -122.380869704969 | (37.7371935127733, -122.380869704969) | 10 | 3 | 8 | 58 | 1 | |||
59726 | 189379 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017817.80282 | 2096554.03386 | 37.7377369308132 | -122.38087368899 | (37.7377369308132, -122.38087368899) | 10 | 3 | 8 | 58 | 1 | |||
133400 | 189363 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017807.80075 | 2096153.39811 | 37.7366363126207 | -122.380880427608 | (37.7366363126207, -122.380880427608) | 10 | 3 | 8 | 58 | 1 | |||
137651 | 189380 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017813.34162 | 2096563.52583 | 37.7377627476478 | -122.380889773354 | (37.7377627476478, -122.380889773354) | 10 | 3 | 8 | 58 | 1 | |||
159687 | 189364 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017803.09649 | 2096176.66908 | 37.7366999504426 | -122.380898309728 | (37.7366999504426, -122.380898309728) | 10 | 3 | 8 | 58 | 1 | |||
153114 | 189368 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017798.12742 | 2096332.7671 | 37.737128290339 | -122.380926338881 | (37.737128290339, -122.380926338881) | 10 | 3 | 8 | 58 | 1 | |||
41722 | 189381 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017800.88124 | 2096579.49396 | 37.7378059052205 | -122.380933965155 | (37.7378059052205, -122.380933965155) | 10 | 3 | 8 | 58 | 1 | |||
178880 | 189349 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017793.56519 | 2096439.47156 | 37.737421027763 | -122.380949528792 | (37.737421027763, -122.380949528792) | 10 | 3 | 8 | 58 | 1 | |||
1739 | 189348 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017793.1763 | 2096477.15047 | 37.7375244650907 | -122.380953492111 | (37.7375244650907, -122.380953492111) | 10 | 3 | 8 | 58 | 1 | |||
107771 | 189347 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017789.20409 | 2096498.15859 | 37.7375819299621 | -122.380968686163 | (37.7375819299621, -122.380968686163) | 10 | 3 | 8 | 58 | 1 | |||
57494 | 189367 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017784.81791 | 2096314.09412 | 37.7370762834315 | -122.380971058572 | (37.7370762834315, -122.380971058572) | 10 | 3 | 8 | 58 | 1 | |||
52466 | 189366 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017781.98855 | 2096299.50337 | 37.7370360639635 | -122.380979826963 | (37.7370360639635, -122.380979826963) | 10 | 3 | 8 | 58 | 1 | |||
107443 | 189365 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017781.37982 | 2096281.83738 | 37.7369875230661 | -122.380980703818 | (37.7369875230661, -122.380980703818) | 10 | 3 | 8 | 58 | 1 | |||
155638 | 189382 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017785.19971 | 2096595.68111 | 37.7378494863677 | -122.38098930943 | (37.7378494863677, -122.38098930943) | 10 | 3 | 8 | 58 | 1 | |||
179539 | 189346 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017783.39859 | 2096513.49577 | 37.7376237223681 | -122.380989824718 | (37.7376237223681, -122.380989824718) | 10 | 3 | 8 | 58 | 1 | |||
133239 | 189350 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017779.96629 | 2096390.27797 | 37.7372852013503 | -122.380993127945 | (37.7372852013503, -122.380993127945) | 10 | 3 | 8 | 58 | 1 | |||
97762 | 189357 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1101 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017772.7039 | 2096095.52292 | 37.736475461683 | -122.380997751349 | (37.736475461683, -122.380997751349) | 10 | 3 | 8 | 58 | 1 | |||
52666 | 189345 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017780.12141 | 2096521.5523 | 37.7376456631085 | -122.381001715564 | (37.7376456631085, -122.381001715564) | 10 | 3 | 8 | 58 | 1 | |||
173630 | 189351 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017770.46268 | 2096373.7262 | 37.7372392289147 | -122.381024836236 | (37.7372392289147, -122.381024836236) | 10 | 3 | 8 | 58 | 1 | |||
140767 | 189383 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017772.50724 | 2096612.75637 | 37.7378956710501 | -122.381034380748 | (37.7378956710501, -122.381034380748) | 10 | 3 | 8 | 58 | 1 | |||
156445 | 189352 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017765.14956 | 2096366.03264 | 37.737217810659 | -122.381042671585 | (37.737217810659, -122.381042671585) | 10 | 3 | 8 | 58 | 1 | |||
156643 | 189356 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1101 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017759.84032 | 2096158.94756 | 37.7366489031225 | -122.381046634905 | (37.7366489031225, -122.381046634905) | 10 | 3 | 8 | 58 | 1 | |||
15027 | 189344 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017767.18086 | 2096543.26443 | 37.7377045660164 | -122.381047966792 | (37.7377045660164, -122.381047966792) | 10 | 3 | 8 | 58 | 1 | |||
28673 | 189353 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017759.87057 | 2096360.05037 | 37.7372010931465 | -122.381060507862 | (37.7372010931465, -122.381060507862) | 10 | 3 | 8 | 58 | 1 | |||
49936 | 189354 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017754.93557 | 2096352.15892 | 37.7371791523904 | -122.381077022089 | (37.7371791523904, -122.381077022089) | 10 | 3 | 8 | 58 | 1 | |||
5453 | 189384 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017757.64488 | 2096623.78425 | 37.737925131039 | -122.381086534243 | (37.737925131039, -122.381086534243) | 10 | 3 | 8 | 58 | 1 | |||
175992 | 189343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017750.34235 | 2096562.27095 | 37.7377558246748 | -122.381107507305 | (37.7377558246748, -122.381107507305) | 10 | 3 | 8 | 58 | 1 | |||
139054 | 189355 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017745.1188 | 2096339.03807 | 37.7371425832692 | -122.381110051504 | (37.7371425832692, -122.381110051504) | 10 | 3 | 8 | 58 | 1 | |||
93177 | 189385 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017746.74315 | 2096627.19057 | 37.7379338823466 | -122.381124464031 | (37.7379338823466, -122.381124464031) | 10 | 3 | 8 | 58 | 1 | |||
73136 | 189342 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017737.91821 | 2096573.15681 | 37.7377850292651 | -122.381151220665 | (37.7377850292651, -122.381151220665) | 10 | 3 | 8 | 58 | 1 | |||
48440 | 189386 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017728.94519 | 2096639.35373 | 37.7379662974982 | -122.381186846422 | (37.7379662974982, -122.381186846422) | 10 | 3 | 8 | 58 | 1 | |||
90613 | 189341 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017727.65109 | 2096582.91421 | 37.7378112543843 | -122.381187397677 | (37.7378112543843, -122.381187397677) | 10 | 3 | 8 | 58 | 1 | |||
115824 | 189387 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 36 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017709.84624 | 2096650.65154 | 37.7379962647187 | -122.381253666927 | (37.7379962647187, -122.381253666927) | 10 | 3 | 8 | 58 | 1 | |||
131322 | 189340 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017708.86017 | 2096602.39431 | 37.7378637055476 | -122.381253721795 | (37.7378637055476, -122.381253721795) | 10 | 3 | 8 | 58 | 1 | |||
92152 | 189388 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017704.60452 | 2096656.13327 | 37.7380110270928 | -122.381272171384 | (37.7380110270928, -122.381272171384) | 10 | 3 | 8 | 58 | 1 | |||
177600 | 189339 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017687.84248 | 2096619.53087 | 37.7379095988488 | -122.381327582209 | (37.7379095988488, -122.381327582209) | 10 | 3 | 8 | 58 | 1 | |||
44276 | 189389 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017682.88595 | 2096671.88866 | 37.7380530892708 | -122.381348359258 | (37.7380530892708, -122.381348359258) | 10 | 3 | 8 | 58 | 1 | |||
110514 | 189338 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017678.6127 | 2096626.66262 | 37.7379286716701 | -122.381359990186 | (37.7379286716701, -122.381359990186) | 10 | 3 | 8 | 58 | 1 | |||
19801 | 189390 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017676.30083 | 2096675.94876 | 37.7380638739522 | -122.38137140977 | (37.7380638739522, -122.38137140977) | 10 | 3 | 8 | 58 | 1 | |||
181790 | 189337 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017665.54346 | 2096637.99611 | 37.7379590696539 | -122.381405965317 | (37.7379590696539, -122.381405965317) | 10 | 3 | 8 | 58 | 1 | |||
91754 | 189336 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017658.40577 | 2096642.73711 | 37.737971693433 | -122.381430973671 | (37.737971693433, -122.381430973671) | 10 | 3 | 8 | 58 | 1 | |||
76937 | 189321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 30 | Median : Yard | Tree | DPW 1 | 7 | 6016453.45941 | 2096140.51631 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | 10 | 3 | 8 | 58 | 1 | ||||
120200 | 189320 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 122 Whitney Young Cir | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6016428.13568 | 2095859.36689 | 37.7357527179215 | -122.385630082783 | (37.7357527179215, -122.385630082783) | 10 | 3 | 8 | 58 | 1 | |||
48702 | 189322 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 31 | Median : Yard | Tree | DPW 1 | 2 | 6016409.15229 | 2096168.44158 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | 10 | 3 | 8 | 58 | 1 | ||||
47870 | 189323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301x Cashmere St | 1 | Median : Yard | Tree | DPW 1 | 6 | 6016365.09613 | 2096197.70243 | 37.7366782309168 | -122.385871612795 | (37.7366782309168, -122.385871612795) | 10 | 3 | 8 | 58 | 1 | ||||
92831 | 29656 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016261.8205744 | 2096260.7089353 | 37.7368455183428 | -122.386233075665 | (37.7368455183428, -122.386233075665) | 10 | 3 | 8 | 58 | 1 | ||
72134 | 189324 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 13 | Median : Yard | Tree | DPW 1 | 4 | 6016254.7178 | 2096666.03631 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | 10 | 3 | 8 | 58 | 1 | ||||
157061 | 189325 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 17 | Median : Yard | Tree | DPW 1 | 6 | 6016204.94299 | 2096703.88094 | 37.7380592307576 | -122.386460619275 | (37.7380592307576, -122.386460619275) | 10 | 3 | 8 | 58 | 1 | ||||
13936 | 189326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 19 | Median : Yard | Tree | DPW 1 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | 10 | 3 | 8 | 58 | 1 | ||||
95266 | 189327 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 20 | Median : Yard | Tree | DPW 1 | 24 | 6016185.54998 | 2096725.46158 | 37.7381174132775 | -122.386529175505 | (37.7381174132775, -122.386529175505) | 10 | 3 | 8 | 58 | 1 | ||||
156086 | 189328 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 21 | Median : Yard | Tree | DPW 1 | 13 | 6016180.04891 | 2096728.46226 | 37.7381253480046 | -122.386548404801 | (37.7381253480046, -122.386548404801) | 10 | 3 | 8 | 58 | 1 | ||||
67804 | 189329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 22 | Median : Yard | Tree | DPW 1 | 22 | 6016170.50674 | 2096734.91499 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | 10 | 3 | 8 | 58 | 1 | ||||
46426 | 29661 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
83966 | 29660 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 3 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
92797 | 29662 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
182904 | 29658 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
192344 | 29659 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 2 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
137 | 189330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 23 | Median : Yard | Tree | DPW 1 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | 10 | 3 | 8 | 58 | 1 | ||||
132408 | 189331 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 24 | Median : Yard | Tree | DPW 1 | 25 | 6016158.58159 | 2096743.10155 | 37.7381643560956 | -122.386623649267 | (37.7381643560956, -122.386623649267) | 10 | 3 | 8 | 58 | 1 | ||||
88804 | 189332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 25 | Median : Yard | Tree | DPW 1 | 5 | 6016155.51714 | 2096746.87389 | 37.7381745445247 | -122.386634507683 | (37.7381745445247, -122.386634507683) | 10 | 3 | 8 | 58 | 1 | ||||
38452 | 189333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016146.37557 | 2096749.3676 | 37.7381808856511 | -122.386666288817 | (37.7381808856511, -122.386666288817) | 10 | 3 | 8 | 58 | 1 | ||||
176370 | 189334 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 27 | Median : Yard | Tree | DPW 1 | 17 | 6016143.04506 | 2096752.08346 | 37.7381881584664 | -122.386677993501 | (37.7381881584664, -122.386677993501) | 10 | 3 | 8 | 58 | 1 | ||||
40739 | 189335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 29 | Median : Yard | Tree | DPW 1 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.386698894633 | (37.7381987371688, -122.386698894633) | 10 | 3 | 8 | 58 | 1 | ||||
141647 | 189284 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 20 | Front Yard : Yard | Tree | Private 2 | 3 | 6015381.32425 | 2102392.44867 | 37.7536332285927 | -122.389705508116 | (37.7536332285927, -122.389705508116) | 10 | 3 | 8 | 28856 | 29 | ||||
13800 | 189286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 70 | Front Yard : Yard | Tree | Private 2 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | 10 | 3 | 8 | 28856 | 29 | ||||
76547 | 189285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 64 | Front Yard : Yard | Tree | Private 2 | 3 | 6015362.87396 | 2102344.01113 | 37.7534992062408 | -122.389765930873 | (37.7534992062408, -122.389765930873) | 10 | 3 | 8 | 28856 | 29 | ||||
13735 | 189282 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 17 | : Yard | Tree | Private 2 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | 10 | 3 | 8 | 28856 | 29 | ||||
94508 | 189283 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 16 | : Yard | Tree | Private 2 | 4 | 6015000.28938 | 2102358.87265 | 37.7535198996319 | -122.391020875425 | (37.7535198996319, -122.391020875425) | 10 | 3 | 8 | 28856 | 29 | ||||
156100 | 189287 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1098 Pennsylvania Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014480.56766 | 2102060.80293 | 37.7526726105751 | -122.392797348536 | (37.7526726105751, -122.392797348536) | 10 | 3 | 8 | 28856 | 29 | |||
150718 | 189311 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1763 Revere Ave | 2 | : | Tree | Private 2 | 19 | Width 3ft | 6014243.98109 | 2094996.62918 | 37.7332627209035 | -122.393121267238 | (37.7332627209035, -122.393121267238) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );