trees
1,650 rows where qSpecies_id = 64 sorted by Latitude
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 | |||||||||||||
108829 | 175987 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 170 Baltimore Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6002239.25029 | 2086152.96272 | 37.7083057912475 | -122.433992922662 | (37.7083057912475, -122.433992922662) | 9 | 7 | 6 | 28861 | 5 | |||
127079 | 175988 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 170 Baltimore Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6002235.39507 | 2086153.26872 | 37.7083064126672 | -122.434006268583 | (37.7083064126672, -122.434006268583) | 9 | 7 | 6 | 28861 | 5 | |||
70888 | 175986 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 164 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6002363.53933 | 2086199.02425 | 37.7084393189804 | -122.433566655684 | (37.7084393189804, -122.433566655684) | 9 | 7 | 6 | 28861 | 5 | |||
65336 | 175985 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 160 Baltimore Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002380.95351 | 2086206.35478 | 37.7084604350668 | -122.433506993768 | (37.7084604350668, -122.433506993768) | 9 | 7 | 6 | 28861 | 5 | |||
106898 | 175882 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.7088129495174 | -122.413957113834 | (37.7088129495174, -122.413957113834) | 9 | 7 | 8 | 309 | 39 | |||
131907 | 175881 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 4 | : | Tree | Private 2 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | 9 | 7 | 8 | 309 | 39 | |||
63814 | 175880 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6008040.57237 | 2086224.46134 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | 9 | 7 | 8 | 309 | 39 | |||
160356 | 175879 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.413943929787 | (37.708843197325, -122.413943929787) | 9 | 7 | 8 | 309 | 39 | |||
179058 | 175878 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | 9 | 7 | 8 | 309 | 39 | |||
113594 | 187498 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.423980183056 | (37.7093929151184, -122.423980183056) | 9 | 7 | 6 | 309 | 5 | ||||
162303 | 187500 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6005130.65162 | 2086494.38351 | 37.7094069274488 | -122.424024164397 | (37.7094069274488, -122.424024164397) | 9 | 7 | 6 | 309 | 5 | ||||
57083 | 187501 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6005123.3425 | 2086496.85663 | 37.7094133054443 | -122.424049601701 | (37.7094133054443, -122.424049601701) | 9 | 7 | 6 | 309 | 5 | ||||
174461 | 187502 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 8 | Front Yard : Yard | Tree | Private 2 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | 9 | 7 | 6 | 309 | 5 | ||||
83872 | 187503 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 9 | Front Yard : Yard | Tree | Private 2 | 2 | 6005106.37943 | 2086503.45631 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | 9 | 7 | 6 | 309 | 5 | ||||
102621 | 175885 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2249 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 5996106.65685 | 2086744.5034 | 37.7095800856229 | -122.455230455925 | (37.7095800856229, -122.455230455925) | 9 | 7 | 6 | 28861 | 25 | |||
52266 | 175915 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 350x Winding Way | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6000968.48443 | 2086648.88049 | 37.7095952724697 | -122.438420330043 | (37.7095952724697, -122.438420330043) | 9 | 7 | 6 | 28861 | 5 | |||
42410 | 175876 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Brunswick St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 5998776.13579 | 2086731.33993 | 37.7096967402836 | -122.446003364979 | (37.7096967402836, -122.446003364979) | 9 | 7 | 6 | 28861 | 5 | ||||
43030 | 175875 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 5998788.01102 | 2086736.62559 | 37.7097119316264 | -122.445962702139 | (37.7097119316264, -122.445962702139) | 9 | 7 | 6 | 28861 | 5 | ||||
36634 | 175913 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 6003123.75236 | 2086687.83288 | 37.7098245860981 | -122.430974132365 | (37.7098245860981, -122.430974132365) | 9 | 7 | 6 | 28861 | 5 | |||
53427 | 175914 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 51 | Width 4ft | 6003141.02013 | 2086709.17727 | 37.7098841715966 | -122.430915974099 | (37.7098841715966, -122.430915974099) | 9 | 7 | 6 | 28861 | 5 | |||
107606 | 175912 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 220 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003237.89384 | 2086718.30125 | 37.7099147125636 | -122.430581811218 | (37.7099147125636, -122.430581811218) | 9 | 7 | 6 | 28861 | 5 | |||
99704 | 111285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Baltimore Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6x10 | 6003156.56512 | 2086725.09076 | 37.7099287473785 | -122.430863382665 | (37.7099287473785, -122.430863382665) | 9 | 7 | 6 | 28861 | 5 | |||
144470 | 175981 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 967 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001590.33977 | 2086770.37109 | 37.7099642112613 | -122.436279782607 | (37.7099642112613, -122.436279782607) | 9 | 7 | 6 | 28861 | 5 | |||
12196 | 175980 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 967 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001586.84738 | 2086770.85375 | 37.7099653381068 | -122.436291887471 | (37.7099653381068, -122.436291887471) | 9 | 7 | 6 | 28861 | 5 | |||
130564 | 175911 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 220 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003229.52096 | 2086738.40607 | 37.7099694417119 | -122.430612183119 | (37.7099694417119, -122.430612183119) | 9 | 7 | 6 | 28861 | 5 | |||
155307 | 111286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Baltimore Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x10 | 6003182.42833 | 2086750.57594 | 37.7100001895294 | -122.430775812058 | (37.7100001895294, -122.430775812058) | 9 | 7 | 6 | 28861 | 5 | |||
36617 | 99580 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 650X Brunswick St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
186432 | 175984 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 96 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002946.98339 | 2087041.36261 | 37.7107852841807 | -122.431610301084 | (37.7107852841807, -122.431610301084) | 9 | 7 | 6 | 28861 | 5 | |||
175332 | 175905 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 205 Nueva Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6012845.81254 | 2086882.70524 | 37.7109057537785 | -122.397386329935 | (37.7109057537785, -122.397386329935) | 10 | 3 | 8 | 309 | 1 | |||
37843 | 175909 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Nueva Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012814.5616 | 2086915.18102 | 37.7109931858583 | -122.397496617385 | (37.7109931858583, -122.397496617385) | 10 | 3 | 8 | 309 | 1 | |||
148561 | 175908 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Nueva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012813.7614 | 2086935.46325 | 37.7110488323118 | -122.39750080462 | (37.7110488323118, -122.39750080462) | 10 | 3 | 8 | 309 | 1 | |||
169005 | 175907 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Nueva Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6012827.98154 | 2086955.68228 | 37.7111051415626 | -122.397453073124 | (37.7111051415626, -122.397453073124) | 10 | 3 | 8 | 309 | 1 | |||
109746 | 54767 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | 3x3 | Permit Number 10616 | 6012845.85571 | 2087036.62523 | 37.7113283901643 | -122.397396968017 | (37.7113283901643, -122.397396968017) | 10 | 3 | 8 | 309 | 1 | |
112467 | 175906 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 185 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6012910.66172 | 2087085.51703 | 37.7114662454497 | -122.39717640659 | (37.7114662454497, -122.39717640659) | 10 | 3 | 8 | 309 | 1 | |||
83280 | 175904 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012465.00059 | 2087095.54364 | 37.7114689560088 | -122.398717440763 | (37.7114689560088, -122.398717440763) | 10 | 3 | 8 | 309 | 1 | |||
154953 | 175903 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012445.87825 | 2087102.32465 | 37.7114865098748 | -122.398784008572 | (37.7114865098748, -122.398784008572) | 10 | 3 | 8 | 309 | 1 | |||
48706 | 175877 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 224 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6007380.7921 | 2087208.44364 | 37.7114943717343 | -122.416297828777 | (37.7114943717343, -122.416297828777) | 9 | 7 | 8 | 309 | 39 | |||
141538 | 175902 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012419.93786 | 2087109.24403 | 37.7115040637341 | -122.398874151239 | (37.7115040637341, -122.398874151239) | 10 | 3 | 8 | 309 | 1 | |||
124041 | 175901 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012404.40104 | 2087114.75356 | 37.7115183260741 | -122.398928237353 | (37.7115183260741, -122.398928237353) | 10 | 3 | 8 | 309 | 1 | |||
14509 | 175884 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 431 Ellington Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5998446.27134 | 2087485.89752 | 37.7117497423219 | -122.447197699721 | (37.7117497423219, -122.447197699721) | 9 | 7 | 6 | 28861 | 25 | |||
46089 | 44437 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 518 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43770 | 6002524.70573 | 2087459.34052 | 37.711909015872 | -122.433099632359 | (37.711909015872, -122.433099632359) | 9 | 7 | 6 | 28861 | 5 | |
59321 | 175910 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 256 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012412.28873 | 2087359.88016 | 37.7121918346656 | -122.398918168549 | (37.7121918346656, -122.398918168549) | 10 | 3 | 8 | 309 | 1 | |||
187491 | 175982 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 433 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6002166.64633 | 2087706.56118 | 37.712567512053 | -122.434354848506 | (37.712567512053, -122.434354848506) | 9 | 7 | 6 | 28861 | 5 | |||
41808 | 175983 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 433 Rolph St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6002149.79643 | 2087722.12847 | 37.7126092999622 | -122.434414199257 | (37.7126092999622, -122.434414199257) | 9 | 7 | 6 | 28861 | 5 | |||
150000 | 175900 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 115 Newton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000983.67354 | 2087943.04237 | 37.7131496180356 | -122.43846049468 | (37.7131496180356, -122.43846049468) | 9 | 7 | 6 | 28861 | 5 | |||
68673 | 175916 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010863.76059 | 2087996.01367 | 37.7138521198643 | -122.404315111648 | (37.7138521198643, -122.404315111648) | 9 | 7 | 8 | 309 | 39 | ||||
174880 | 187561 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 136 Alpha St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.404059202394 | (37.7143031001696, -122.404059202394) | 9 | 7 | 8 | 309 | 39 | ||||
116572 | 187560 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 136 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6010944.5891 | 2088158.85993 | 37.7143037791818 | -122.404047190127 | (37.7143037791818, -122.404047190127) | 9 | 7 | 8 | 309 | 39 | ||||
152814 | 187559 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 136 Alpha St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6010948.12811 | 2088162.00128 | 37.7143126024269 | -122.404035178792 | (37.7143126024269, -122.404035178792) | 9 | 7 | 8 | 309 | 39 | ||||
182199 | 175883 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 52 Ottawa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999221.0603 | 2088431.79903 | 37.7143912139527 | -122.444587768206 | (37.7143912139527, -122.444587768206) | 9 | 7 | 6 | 28861 | 25 | |||
107267 | 187579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 19 | 6008885.34324 | 2088289.25998 | 37.7145465601547 | -122.411173984595 | (37.7145465601547, -122.411173984595) | 9 | 7 | 8 | 309 | 39 | ||||
22806 | 175944 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1764 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5997944.4131 | 2088561.35887 | 37.7146740246601 | -122.449009674469 | (37.7146740246601, -122.449009674469) | 9 | 7 | 6 | 28861 | 25 | |||
23604 | 175889 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 963 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001524.34401 | 2088591.42567 | 37.7149606745828 | -122.436638139935 | (37.7149606745828, -122.436638139935) | 9 | 7 | 6 | 28861 | 5 | |||
85267 | 25394 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1045 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4X4 | 6000938.80793 | 2088782.07415 | 37.715450859936 | -122.438675648469 | (37.715450859936, -122.438675648469) | 9 | 7 | 6 | 28861 | 5 | |||
136583 | 39939 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 570 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 5 | Permit Number 41210 | 6009909.04196 | 2088692.11823 | 37.7157100841234 | -122.407664040379 | (37.7157100841234, -122.407664040379) | 9 | 7 | 8 | 309 | 39 | |
101855 | 78576 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 574 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | Permit Number 781441 | 6009888.44286 | 2088699.06024 | 37.7157279923247 | -122.407735729826 | (37.7157279923247, -122.407735729826) | 9 | 7 | 8 | 309 | 39 | |
79053 | 15065 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1X Minerva St | 8 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996005.0253 | 2089004.00266 | 37.7157783129984 | -122.455744930195 | (37.7157783129984, -122.455744930195) | 9 | 8 | 6 | 28861 | 24 | |||
20932 | 205329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 21 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 5996217.25377 | 2089002.70313 | 37.7157869221923 | -122.455011281241 | (37.7157869221923, -122.455011281241) | 9 | 8 | 6 | 28861 | 24 | |||
183505 | 205330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 26 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5996263.21296 | 2089001.74294 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | 9 | 8 | 6 | 28861 | 24 | |||
143116 | 205332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 37 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5996356.8338 | 2088999.78722 | 37.7157869222184 | -122.454528620522 | (37.7157869222184, -122.454528620522) | 9 | 8 | 6 | 28861 | 24 | |||
161251 | 205331 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 30 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5996300.38931 | 2089001.53161 | 37.7157884744382 | -122.454723843541 | (37.7157884744382, -122.454723843541) | 9 | 8 | 6 | 28861 | 24 | |||
138731 | 104238 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 169 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770721 | 6009785.90495 | 2088868.00046 | 37.7161861267679 | -122.408102056979 | (37.7161861267679, -122.408102056979) | 9 | 7 | 8 | 309 | 39 | |
79966 | 205336 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992219.92484 | 2089237.66093 | 37.7162019305526 | -122.468844858021 | (37.7162019305526, -122.468844858021) | 9 | 8 | 6 | 64 | 24 | |||
158027 | 104239 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 169 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 13 | 3x3 | Permit Number 770721 | 6009791.07087 | 2088880.72075 | 37.716221343317 | -122.40808509757 | (37.716221343317, -122.40808509757) | 9 | 7 | 8 | 309 | 39 | |
100632 | 205337 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992219.91923 | 2089255.52232 | 37.7162509732747 | -122.468846176429 | (37.7162509732747, -122.468846176429) | 9 | 8 | 6 | 64 | 24 | |||
145937 | 205338 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992219.15057 | 2089273.39944 | 37.7163000151028 | -122.468850133429 | (37.7163000151028, -122.468850133429) | 9 | 8 | 6 | 64 | 24 | |||
82184 | 205328 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 438 Orizaba Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 5994041.13473 | 2089285.67393 | 37.7164388128869 | -122.462553409618 | (37.7164388128869, -122.462553409618) | 9 | 8 | 6 | 28861 | 24 | |||
7959 | 205335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 134 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5991702.38493 | 2089452.42364 | 37.7167617027762 | -122.470649341406 | (37.7167617027762, -122.470649341406) | 9 | 8 | 6 | 64 | 24 | |||
82403 | 205333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 10 Caine Ave | 15 | : | Tree | Private 2 | 1 | Width 0ft | 5997549.34328 | 2089570.25288 | 37.7174216118035 | -122.45044787838 | (37.7174216118035, -122.45044787838) | 9 | 8 | 6 | 28861 | 24 | |||
179965 | 205327 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 218 Thrift St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5994824.42193 | 2089656.95499 | 37.7175033403925 | -122.459872882235 | (37.7175033403925, -122.459872882235) | 9 | 8 | 6 | 28861 | 24 | |||
40884 | 175945 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 901 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5998663.60507 | 2089603.57639 | 37.7175768212865 | -122.446598802501 | (37.7175768212865, -122.446598802501) | 9 | 7 | 6 | 28861 | 25 | |||
29379 | 254551 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 1433 Cayuga Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5999129 | 2089595 | 37.7175798453783 | -122.444989533853 | (37.7175798453783, -122.444989533853) | 9 | 7 | 6 | 28861 | 25 | ||||
43187 | 175874 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1441 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5999110.44202 | 2089599.42923 | 37.7175909478381 | -122.445053998347 | (37.7175909478381, -122.445053998347) | 9 | 7 | 6 | 28861 | 25 | |||
106221 | 205334 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Margaret Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997009.74626 | 2089680.74953 | 37.7176941117806 | -122.452320974643 | (37.7176941117806, -122.452320974643) | 9 | 8 | 6 | 28861 | 24 | |||
157425 | 175917 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 95 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010099.42141 | 2089574.96009 | 37.7181448420765 | -122.407068190967 | (37.7181448420765, -122.407068190967) | 10 | 7 | 8 | 309 | 39 | |||
185367 | 54120 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 775 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/2000 12:00:00 AM | Permit Number 9853 | 5994299.65074367 | 2089905.11614326 | 37.7181545378086 | -122.461704745095 | (37.7181545378086, -122.461704745095) | 9 | 8 | 6 | 28861 | 24 | ||
48824 | 205325 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 775 Lakeview Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994321.8349 | 2089907.93714 | 37.7181635605828 | -122.461628268956 | (37.7181635605828, -122.461628268956) | 9 | 8 | 6 | 28861 | 24 | |||
81559 | 175918 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 95 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010112.71728 | 2089613.53023 | 37.7182514917899 | -122.407024949752 | (37.7182514917899, -122.407024949752) | 10 | 7 | 8 | 309 | 39 | |||
30133 | 205323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 744 Lakeview Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994595.93663 | 2089945.86852 | 37.7182834851695 | -122.460683570699 | (37.7182834851695, -122.460683570699) | 9 | 8 | 6 | 28861 | 24 | |||
148276 | 205324 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 748 Lakeview Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994550.0079 | 2089946.83095 | 37.7182834851855 | -122.460842395483 | (37.7182834851855, -122.460842395483) | 9 | 8 | 6 | 28861 | 24 | |||
158704 | 175919 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 95 Delta St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010124.34327 | 2089644.13259 | 37.718336170157 | -122.406986919224 | (37.718336170157, -122.406986919224) | 10 | 7 | 8 | 309 | 39 | |||
1995 | 87953 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | 10 | 7 | 8 | 309 | 39 | ||
105038 | 87951 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | 10 | 7 | 8 | 309 | 39 | ||
120702 | 87952 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | 10 | 7 | 8 | 309 | 39 | ||
191375 | 87954 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | 10 | 7 | 8 | 309 | 39 | ||
78225 | 84597 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010148.19523638 | 2089662.82896813 | 37.7183888412655 | -122.406905789617 | (37.7183888412655, -122.406905789617) | 10 | 7 | 8 | 309 | 39 | ||
136799 | 102061 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 5992454 | 2090050 | 37.7184459373178 | -122.468094845853 | (37.7184459373178, -122.468094845853) | 9 | 8 | 6 | 64 | 24 | |||
125522 | 205339 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992450.82232 | 2090054.78249 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | 9 | 8 | 6 | 64 | 24 | |||
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
148449 | 205326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 15 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995597.57429 | 2090027.5624 | 37.718565374973 | -122.45722726115 | (37.718565374973, -122.45722726115) | 9 | 8 | 6 | 28861 | 24 |
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) );