trees
1,650 rows where qSpecies_id = 64 sorted by Zip Codes
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 | |||||||||||||
183225 | 189281 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 975 Minna St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008056.3994 | 2110189.2113 | 37.7746324316857 | -122.415588777222 | (37.7746324316857, -122.415588777222) | 8 | 2 | 9 | 28853 | 34 | |||
1960 | 189303 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013928.16034 | 2104751.39428 | 37.7600296962246 | -122.394896108974 | (37.7600296962246, -122.394896108974) | 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 | ||||
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 | ||||
15183 | 189306 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | 10 | 3 | 8 | 28856 | 29 | |||
17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
18677 | 189308 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1500 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013530.98263 | 2103856.35073 | 37.7575500090417 | -122.396207035432 | (37.7575500090417, -122.396207035432) | 10 | 3 | 8 | 28856 | 29 | |||
23277 | 189302 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013921.81731 | 2104751.14346 | 37.760028654829 | -122.394918029061 | (37.760028654829, -122.394918029061) | 10 | 3 | 8 | 28856 | 29 | |||
42791 | 189300 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013904.84874 | 2104750.47011 | 37.7600258624144 | -122.394976668459 | (37.7600258624144, -122.394976668459) | 10 | 3 | 8 | 28856 | 29 | |||
44940 | 49418 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 413@ 19th ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014094.43855 | 2105154.43805 | 37.7611456110148 | -122.394349248338 | (37.7611456110148, -122.394349248338) | 10 | 3 | 8 | 28856 | 29 | ||
46882 | 189307 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1510x 22nd St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6013533.7803 | 2103828.56548 | 37.7574738724493 | -122.396195412608 | (37.7574738724493, -122.396195412608) | 10 | 3 | 8 | 28856 | 29 | |||
50934 | 189291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 31 | : Yard | Tree | Private 2 | 5 | 6014386.77773 | 2105894.38958 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | 14 | 3 | 8 | 28856 | 29 | ||||
64737 | 101784 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1017 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012216.2726 | 2103633.66044 | 37.7568653093127 | -122.400738217399 | (37.7568653093127, -122.400738217399) | 10 | 3 | 8 | 28856 | 29 | |||
73154 | 189297 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1458 Rhode Island St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6011987.51457 | 2101577.28204 | 37.7512061823217 | -122.401384841636 | (37.7512061823217, -122.401384841636) | 10 | 3 | 8 | 28856 | 29 | |||
76388 | 189289 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 20 | : Yard | Tree | Private 2 | 10 | 6014461.84726 | 2105889.9963 | 37.7631857104708 | -122.393129998769 | (37.7631857104708, -122.393129998769) | 14 | 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 | ||||
79813 | 189290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 23 | : Yard | Tree | Private 2 | 5 | 6014424.75736 | 2105899.25329 | 37.7632090676603 | -122.393258929155 | (37.7632090676603, -122.393258929155) | 14 | 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 | ||||
99635 | 189294 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1940 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6012210.95839 | 2104716.11171 | 37.7598371855631 | -122.400832642618 | (37.7598371855631, -122.400832642618) | 10 | 3 | 8 | 28856 | 29 | |||
106035 | 189295 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6012074.25534 | 2105313.32081 | 37.7614693633429 | -122.401347403775 | (37.7614693633429, -122.401347403775) | 10 | 3 | 8 | 28856 | 29 | |||
110505 | 189305 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 501 Texas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6013843.52839 | 2104740.21019 | 37.7599942809301 | -122.395188028931 | (37.7599942809301, -122.395188028931) | 10 | 3 | 8 | 28856 | 29 | |||
118735 | 189293 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 35 | : Yard | Tree | Private 2 | 8 | 6014389.36638 | 2105866.30731 | 37.7631166389548 | -122.393379030018 | (37.7631166389548, -122.393379030018) | 14 | 3 | 8 | 28856 | 29 | ||||
124983 | 189301 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013913.31542 | 2104750.9131 | 37.7600275495642 | -122.394947417095 | (37.7600275495642, -122.394947417095) | 10 | 3 | 8 | 28856 | 29 | |||
131939 | 49419 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 413@ 19th ST Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014093.42123 | 2105165.00342 | 37.7611745646684 | -122.394353506611 | (37.7611745646684, -122.394353506611) | 10 | 3 | 8 | 28856 | 29 | ||
137028 | 189299 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1750 22nd St | 11 | Side Yard : Yard | Tree | Private 2 | 2 | 6012797.06573 | 2103802.01858 | 37.7573599607159 | -122.398741420304 | (37.7573599607159, -122.398741420304) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
142033 | 189304 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013935.92208 | 2104751.61933 | 37.7600307457419 | -122.394869280409 | (37.7600307457419, -122.394869280409) | 10 | 3 | 8 | 28856 | 29 | |||
142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 | |
149427 | 189288 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 9ft | 6014362.47484 | 2105695.49832 | 37.7626461406213 | -122.393460085018 | (37.7626461406213, -122.393460085018) | 10 | 3 | 8 | 28856 | 29 | |||
150174 | 51296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 400 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2004 12:00:00 AM | 6 | Permit Number 47669 | 6011440.29122 | 2106415.58211 | 37.764460534556 | -122.403617592093 | (37.764460534556, -122.403617592093) | 8 | 3 | 8 | 28856 | 29 | ||
151849 | 51297 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 400 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2004 12:00:00 AM | 10 | Permit Number 47669 | 6011440.20199 | 2106438.76449 | 37.7645241831718 | -122.403619531927 | (37.7645241831718, -122.403619531927) | 8 | 3 | 8 | 28856 | 29 | ||
153969 | 189298 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1470 Rhode Island St | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6011992.06191 | 2101527.33948 | 37.7510693046196 | -122.401365606962 | (37.7510693046196, -122.401365606962) | 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 | |||
163412 | 189292 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 33 | : Yard | Tree | Private 2 | 5 | 6014376.22928 | 2105886.6133 | 37.7631716648753 | -122.393425888311 | (37.7631716648753, -122.393425888311) | 14 | 3 | 8 | 28856 | 29 | ||||
192553 | 189296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 621 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6011838.19125 | 2105389.54808 | 37.7616654928887 | -122.402169215947 | (37.7616654928887, -122.402169215947) | 10 | 3 | 8 | 28856 | 29 | |||
512 | 126120 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6006458.53093 | 2121044.25925 | 37.8043477551992 | -122.421887372509 | (37.8043477551992, -122.421887372509) | 5 | 9 | 1 | 28858 | 32 | |||
1650 | 126124 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | 5 | 1 | 1 | 28858 | 32 | |||
41150 | 126123 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2836 Larkin St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341 | (37.8041539827815, -122.42172367341) | 5 | 9 | 1 | 28858 | 32 | ||||
41814 | 126121 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6006456.29777 | 2121037.52584 | 37.8043291410369 | -122.421894621962 | (37.8043291410369, -122.421894621962) | 5 | 9 | 1 | 28858 | 32 | |||
57642 | 126117 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6006450.97275 | 2121075.70242 | 37.8044336638558 | -122.421915763199 | (37.8044336638558, -122.421915763199) | 5 | 9 | 1 | 28858 | 32 | |||
59658 | 126122 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2833 Larkin St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.421829107228 | (37.804070054442, -122.421829107228) | 5 | 9 | 1 | 28858 | 32 | ||||
61444 | 249419 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 730 Eddy St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006909.7842 | 2113298.36761 | 37.7831049051094 | -122.419775815624 | (37.7831049051094, -122.419775815624) | 7 | 9 | 9 | 28858 | 36 | |||
108639 | 126114 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 20 Reed St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6008207.05335 | 2117051.51427 | 37.7934831255889 | -122.415553587621 | (37.7934831255889, -122.415553587621) | 5 | 1 | 10 | 28858 | 21 | ||||
112752 | 126126 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 39 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6007489.31877 | 2119355.11229 | 37.7997678614442 | -122.418200406634 | (37.7997678614442, -122.418200406634) | 5 | 1 | 1 | 28858 | 32 | |||
117644 | 126125 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1055 Lombard St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 5ft | 6007295.75973 | 2120178.53611 | 37.8020178788931 | -122.418928627254 | (37.8020178788931, -122.418928627254) | 5 | 1 | 1 | 28858 | 32 | |||
118002 | 126101 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4 Kimball Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008010.07653 | 2116418.05756 | 37.7917327355326 | -122.416190259997 | (37.7917327355326, -122.416190259997) | 5 | 1 | 10 | 28858 | 21 | |||
149186 | 126119 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006456.64037 | 2121054.20596 | 37.804374959703 | -122.421894621951 | (37.804374959703, -122.421894621951) | 5 | 9 | 1 | 28858 | 32 | |||
164737 | 126118 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006454.20196 | 2121071.4643 | 37.8044222091763 | -122.42190428698 | (37.8044222091763, -122.42190428698) | 5 | 9 | 1 | 28858 | 32 | |||
164903 | 126100 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4 Kimball Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008010.60275 | 2116411.87051 | 37.7917157770027 | -122.416188000891 | (37.7917157770027, -122.416188000891) | 5 | 1 | 10 | 28858 | 21 | |||
172280 | 52223 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1331 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | 6 | Permit Number 48403 | 6006656.01014 | 2118694.90131 | 37.7979081488955 | -122.421037065315 | (37.7979081488955, -122.421037065315) | 13 | 9 | 10 | 28858 | 32 | ||
174766 | 126129 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2800x Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | 5 | 9 | 1 | 28858 | 32 | |||
188611 | 126116 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 5ft | 6006453.14496 | 2121079.48175 | 37.8044441634334 | -122.421908514693 | (37.8044441634334, -122.421908514693) | 5 | 9 | 1 | 28858 | 32 | |||
194445 | 24428 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005809.51077 | 2115255.80256 | 37.7884174936216 | -122.42372154163 | (37.7884174936216, -122.42372154163) | 13 | 9 | 1 | 28858 | 41 | ||
150 | 247856 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 80 Bradford St | 5 | Side Yard : Yard | Tree | Private 2 | 32 | 6009566.84713 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | 10 | 7 | 7 | 28859 | 2 | ||||
603 | 245637 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 111 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008273.00792 | 2099308.43984 | 37.7447685005688 | -122.414069557873 | (37.7447685005688, -122.414069557873) | 2 | 7 | 7 | 28859 | 2 | |||
683 | 38304 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
990 | 245607 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 263 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007571 | 2097463 | 37.7396618784985 | -122.416366286166 | (37.7396618784985, -122.416366286166) | 2 | 7 | 7 | 28859 | 2 | |||
3002 | 43637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43287 | 6006770.36235207 | 2101076.15554315 | 37.7495377351989 | -122.419390811234 | (37.7495377351989, -122.419390811234) | 2 | 4 | 7 | 28859 | 19 | ||
3163 | 245541 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499X Ogden Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008320.69019 | 2096092.37783 | 37.7359405790823 | -122.413677250212 | (37.7359405790823, -122.413677250212) | 2 | 7 | 7 | 28859 | 2 | |||
6119 | 245606 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 269 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007569 | 2097440 | 37.7395986131129 | -122.416371572654 | (37.7395986131129, -122.416371572654) | 2 | 7 | 7 | 28859 | 2 | |||
9042 | 122353 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 155 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
9061 | 245544 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2020 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008037.51998 | 2106722.39009 | 37.7651122930328 | -122.415408600746 | (37.7651122930328, -122.415408600746) | 8 | 4 | 7 | 28859 | 19 | |||
9111 | 29980 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1622X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.53507 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | 2 | 7 | 5 | 28859 | 2 | ||
9532 | 261191 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 599x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
11609 | 245630 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 53 Appleton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005628.85756 | 2097048.73767 | 37.7384150016563 | -122.42305195408 | (37.7384150016563, -122.42305195408) | 2 | 7 | 7 | 28859 | 2 | |||
14890 | 261368 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 48 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
17008 | 29712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.50359 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | 2 | 7 | 5 | 28859 | 22 | |||
18720 | 245646 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 491 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006820.96537 | 2100970.13931 | 37.7492494886697 | -122.419208304739 | (37.7492494886697, -122.419208304739) | 2 | 4 | 7 | 28859 | 19 | |||
20085 | 30016 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.52892 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | 2 | 7 | 7 | 28859 | 2 | ||
22362 | 104523 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 51X BONVIEW ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | |||||
23326 | 245667 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 33 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005668.95498 | 2099318.86171 | 37.7446505122149 | -122.423074627805 | (37.7446505122149, -122.423074627805) | 2 | 7 | 5 | 28859 | 22 | |||
24823 | 38314 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
26972 | 245608 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 669 Ellsworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007971.01243 | 2095757.87168 | 37.7350024558046 | -122.414862562055 | (37.7350024558046, -122.414862562055) | 2 | 7 | 7 | 28859 | 2 | |||
26987 | 245560 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2895 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009015.34966 | 2101644.53277 | 37.7512245599714 | -122.41166770072 | (37.7512245599714, -122.41166770072) | 2 | 4 | 7 | 28859 | 19 | |||
27907 | 108600 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
29355 | 245611 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 144 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009288.92711 | 2096649.46707 | 37.7375245496104 | -122.410368978947 | (37.7375245496104, -122.410368978947) | 10 | 7 | 7 | 28859 | 2 | |||
29554 | 245643 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 397 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006236.48715 | 2100897.99969 | 37.7490184762356 | -122.421224322147 | (37.7490184762356, -122.421224322147) | 2 | 4 | 5 | 28859 | 19 | |||
29647 | 245552 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1187 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007687.51516 | 2102781.67448 | 37.7542723174215 | -122.41634004478 | (37.7542723174215, -122.41634004478) | 2 | 4 | 7 | 28859 | 19 | |||
30956 | 245626 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 322 Elsie St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006348.59893 | 2096985.53448 | 37.7382820485678 | -122.420558948829 | (37.7382820485678, -122.420558948829) | 2 | 7 | 7 | 28859 | 2 | |||
31424 | 245622 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 45 Aztec St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 48 | Width 3ft | 6007740.56347 | 2099594.44436 | 37.745523885229 | -122.415930903595 | (37.745523885229, -122.415930903595) | 2 | 7 | 7 | 28859 | 2 | |||
32281 | 245499 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 290 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6010401.30335 | 2099970.53997 | 37.7467057922326 | -122.406756935608 | (37.7467057922326, -122.406756935608) | 2 | 7 | 7 | 28859 | 2 | |||
33188 | 39188 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1189 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.416343098068 | (37.7541746987817, -122.416343098068) | 2 | 4 | 7 | 28859 | 19 | ||
33840 | 30007 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005678.3438 | 2098731.55781 | 37.7430384387857 | -122.42300042833 | (37.7430384387857, -122.42300042833) | 2 | 7 | 7 | 28859 | 2 | ||
34073 | 29992 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 7 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005877.58141 | 2099371.3233 | 37.7448063305595 | -122.422356964316 | (37.7448063305595, -122.422356964316) | 2 | 7 | 5 | 28859 | 2 | ||
36282 | 38313 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
37986 | 245636 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008273.01473 | 2099327.11999 | 37.7448197924968 | -122.414070855604 | (37.7448197924968, -122.414070855604) | 2 | 7 | 7 | 28859 | 2 | |||
40523 | 245558 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2895 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009016.51977 | 2101624.75591 | 37.7511703227723 | -122.411662257123 | (37.7511703227723, -122.411662257123) | 2 | 4 | 7 | 28859 | 19 | |||
42780 | 84884 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2895 HARRISON St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | Permit No. 49261 | 6009003 | 2101605 | 37.7511153190475 | -122.411707614344 | (37.7511153190475, -122.411707614344) | 2 | 4 | 7 | 28859 | 19 | |||
43803 | 245562 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2445 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008870.65753 | 2104208.97793 | 37.7582578303569 | -122.41234930408 | (37.7582578303569, -122.41234930408) | 2 | 4 | 7 | 28859 | 19 | |||
43857 | 43115 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 200 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 |
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) );