Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6655 | 6655 | 20047 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 8287 | 8287 | 47845 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 8319 | 8319 | 47848 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12078 | 12078 | 47847 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12229 | 12229 | 47849 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12714 | 12714 | 47846 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 13145 | 13145 | 19899 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 15056 | 15056 | 20048 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 16207 | 16207 | 47844 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 60822 | 60822 | 175987 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 170 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6002239.25029 | 2086152.9627200002 | 37.708305791247504 | -122.43399292266199 | (37.7083057912475, -122.433992922662) | |||
| 41818 | 41818 | 175988 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 170 Baltimore Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6002235.39507 | 2086153.26872 | 37.708306412667206 | -122.43400626858299 | (37.7083064126672, -122.434006268583) | |||
| 137871 | 137871 | 175986 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 164 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6002363.53933 | 2086199.02425 | 37.708439318980396 | -122.43356665568399 | (37.7084393189804, -122.433566655684) | |||
| 41727 | 41727 | 175985 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 160 Baltimore Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002380.953509999 | 2086206.35478 | 37.7084604350668 | -122.433506993768 | (37.7084604350668, -122.433506993768) | |||
| 176962 | 176962 | 175882 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.708812949517394 | -122.413957113834 | (37.7088129495174, -122.413957113834) | |||
| 179124 | 179124 | 175881 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | |||
| 55394 | 55394 | 175880 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008040.572369999 | 2086224.4613400002 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | |||
| 154303 | 154303 | 175879 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.41394392978701 | (37.708843197325, -122.413943929787) | |||
| 57129 | 57129 | 175878 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | |||
| 48408 | 48408 | 187498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.42398018305599 | (37.7093929151184, -122.423980183056) | ||||
| 23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
| 134081 | 134081 | 187501 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005123.3425 | 2086496.8566299998 | 37.7094133054443 | -122.42404960170099 | (37.7094133054443, -122.424049601701) | ||||
| 73009 | 73009 | 187502 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | ||||
| 60503 | 60503 | 187503 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005106.379430001 | 2086503.4563099998 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | ||||
| 46886 | 46886 | 175915 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 350x Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000968.48443 | 2086648.8804900001 | 37.7095952724697 | -122.43842033004299 | (37.7095952724697, -122.438420330043) | |||
| 57572 | 57572 | 175913 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 6003123.75236 | 2086687.83288 | 37.7098245860981 | -122.430974132365 | (37.7098245860981, -122.430974132365) | |||
| 158716 | 158716 | 175914 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 51 | Width 4ft | 6003141.02013 | 2086709.17727 | 37.709884171596606 | -122.43091597409901 | (37.7098841715966, -122.430915974099) | |||
| 180971 | 180971 | 175912 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 220 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003237.89384 | 2086718.30125 | 37.7099147125636 | -122.43058181121799 | (37.7099147125636, -122.430581811218) | |||
| 11858 | 11858 | 111285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x10 | 6003156.565119999 | 2086725.0907599998 | 37.709928747378505 | -122.43086338266501 | (37.7099287473785, -122.430863382665) | |||
| 68499 | 68499 | 175876 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998776.13579 | 2086731.33993 | 37.709696740283604 | -122.446003364979 | (37.7096967402836, -122.446003364979) | ||||
| 135146 | 135146 | 175875 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998788.01102 | 2086736.62559 | 37.709711931626394 | -122.445962702139 | (37.7097119316264, -122.445962702139) | ||||
| 68694 | 68694 | 175911 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 220 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003229.520959999 | 2086738.40607 | 37.7099694417119 | -122.430612183119 | (37.7099694417119, -122.430612183119) | |||
| 135543 | 135543 | 175885 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2249 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 5996106.65685 | 2086744.5034 | 37.709580085622896 | -122.455230455925 | (37.7095800856229, -122.455230455925) | |||
| 46537 | 46537 | 111286 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x10 | 6003182.4283300005 | 2086750.5759400001 | 37.7100001895294 | -122.43077581205799 | (37.7100001895294, -122.430775812058) | |||
| 73301 | 73301 | 175981 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 967 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001590.3397699995 | 2086770.3710900003 | 37.709964211261294 | -122.436279782607 | (37.7099642112613, -122.436279782607) | |||
| 57682 | 57682 | 175980 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 967 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001586.84738 | 2086770.85375 | 37.7099653381068 | -122.43629188747101 | (37.7099653381068, -122.436291887471) | |||
| 132805 | 132805 | 175905 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 205 Nueva Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6012845.81254 | 2086882.70524 | 37.7109057537785 | -122.397386329935 | (37.7109057537785, -122.397386329935) | |||
| 77951 | 77951 | 99580 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650X Brunswick St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 133830 | 133830 | 175909 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6012814.5616 | 2086915.18102 | 37.7109931858583 | -122.397496617385 | (37.7109931858583, -122.397496617385) | |||
| 152840 | 152840 | 175908 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6012813.7614 | 2086935.46325 | 37.711048832311796 | -122.39750080462 | (37.7110488323118, -122.39750080462) | |||
| 40909 | 40909 | 175907 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6012827.98154 | 2086955.6822799998 | 37.7111051415626 | -122.39745307312401 | (37.7111051415626, -122.397453073124) | |||
| 71667 | 71667 | 54767 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 198 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 7 | 3x3 | Permit Number 10616 | 6012845.85571 | 2087036.62523 | 37.7113283901643 | -122.397396968017 | (37.7113283901643, -122.397396968017) | |
| 174505 | 174505 | 175984 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 96 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002946.98339 | 2087041.36261 | 37.7107852841807 | -122.431610301084 | (37.7107852841807, -122.431610301084) | |||
| 164247 | 164247 | 175906 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 185 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012910.661719999 | 2087085.51703 | 37.71146624544971 | -122.39717640658999 | (37.7114662454497, -122.39717640659) | |||
| 61420 | 61420 | 175904 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012465.00059 | 2087095.54364 | 37.711468956008794 | -122.398717440763 | (37.7114689560088, -122.398717440763) | |||
| 43654 | 43654 | 175903 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012445.87825 | 2087102.32465 | 37.711486509874796 | -122.39878400857201 | (37.7114865098748, -122.398784008572) | |||
| 182117 | 182117 | 175902 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012419.93786 | 2087109.24403 | 37.711504063734104 | -122.398874151239 | (37.7115040637341, -122.398874151239) | |||
| 55701 | 55701 | 175901 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012404.40104 | 2087114.7535599999 | 37.7115183260741 | -122.398928237353 | (37.7115183260741, -122.398928237353) | |||
| 34395 | 34395 | 175877 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 224 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6007380.7921 | 2087208.4436400002 | 37.7114943717343 | -122.416297828777 | (37.7114943717343, -122.416297828777) | |||
| 150262 | 150262 | 175910 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 256 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012412.28873 | 2087359.88016 | 37.7121918346656 | -122.398918168549 | (37.7121918346656, -122.398918168549) | |||
| 73986 | 73986 | 44437 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 518 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43770 | 6002524.7057300005 | 2087459.34052 | 37.711909015872 | -122.433099632359 | (37.711909015872, -122.433099632359) | |
| 73365 | 73365 | 175884 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 431 Ellington Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5998446.27134 | 2087485.89752 | 37.7117497423219 | -122.44719769972099 | (37.7117497423219, -122.447197699721) | |||
| 150846 | 150846 | 175982 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 433 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6002166.64633 | 2087706.56118 | 37.712567512053 | -122.43435484850599 | (37.712567512053, -122.434354848506) | |||
| 177656 | 177656 | 175983 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 433 Rolph St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6002149.79643 | 2087722.12847 | 37.7126092999622 | -122.43441419925699 | (37.7126092999622, -122.434414199257) | |||
| 160769 | 160769 | 175900 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 115 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000983.67354 | 2087943.0423700002 | 37.7131496180356 | -122.43846049468 | (37.7131496180356, -122.43846049468) | |||
| 170444 | 170444 | 175916 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6010863.76059 | 2087996.01367 | 37.7138521198643 | -122.404315111648 | (37.7138521198643, -122.404315111648) | ||||
| 27164 | 27164 | 187561 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.40405920239401 | (37.7143031001696, -122.404059202394) | ||||
| 75494 | 75494 | 187560 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010944.5891 | 2088158.85993 | 37.7143037791818 | -122.40404719012699 | (37.7143037791818, -122.404047190127) | ||||
| 49402 | 49402 | 187559 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6010948.12811 | 2088162.00128 | 37.714312602426894 | -122.404035178792 | (37.7143126024269, -122.404035178792) | ||||
| 173566 | 173566 | 187579 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 299 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6008885.34324 | 2088289.2599799999 | 37.7145465601547 | -122.411173984595 | (37.7145465601547, -122.411173984595) | ||||
| 36720 | 36720 | 175883 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 52 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5999221.0603 | 2088431.7990299999 | 37.7143912139527 | -122.444587768206 | (37.7143912139527, -122.444587768206) | |||
| 24304 | 24304 | 175944 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1764 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5997944.4131 | 2088561.35887 | 37.7146740246601 | -122.449009674469 | (37.7146740246601, -122.449009674469) | |||
| 37288 | 37288 | 175889 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 963 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001524.34401 | 2088591.42567 | 37.7149606745828 | -122.436638139935 | (37.7149606745828, -122.436638139935) | |||
| 46753 | 46753 | 39939 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 570 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 5 | Permit Number 41210 | 6009909.04196 | 2088692.11823 | 37.715710084123394 | -122.407664040379 | (37.7157100841234, -122.407664040379) | |
| 32209 | 32209 | 78576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 574 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2011 12:00:00 AM | 3 | Permit Number 767978 | 6009888.44286 | 2088699.0602400003 | 37.7157279923247 | -122.40773572982599 | (37.7157279923247, -122.407735729826) | |
| 11441 | 11441 | 25394 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1045 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6000938.80793 | 2088782.07415 | 37.715450859936 | -122.43867564846902 | (37.715450859936, -122.438675648469) | |||
| 177541 | 177541 | 104238 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 169 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770721 | 6009785.90495 | 2088868.0004599998 | 37.716186126767894 | -122.408102056979 | (37.7161861267679, -122.408102056979) | |
| 163753 | 163753 | 104239 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 169 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2013 12:00:00 AM | 13 | 3x3 | Permit Number 770721 | 6009791.07087 | 2088880.72075 | 37.716221343316995 | -122.40808509757 | (37.716221343317, -122.40808509757) | |
| 158532 | 158532 | 205332 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5996356.8338 | 2088999.78722 | 37.7157869222184 | -122.454528620522 | (37.7157869222184, -122.454528620522) | |||
| 167470 | 167470 | 205331 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5996300.3893099995 | 2089001.53161 | 37.715788474438206 | -122.45472384354099 | (37.7157884744382, -122.454723843541) | |||
| 175826 | 175826 | 205330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996263.21296 | 2089001.7429400003 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | |||
| 29945 | 29945 | 205329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996217.253769999 | 2089002.70313 | 37.715786922192294 | -122.455011281241 | (37.7157869221923, -122.455011281241) | |||
| 18978 | 18978 | 15065 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1X Minerva St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996005.0253 | 2089004.0026599998 | 37.7157783129984 | -122.45574493019501 | (37.7157783129984, -122.455744930195) | |||
| 181923 | 181923 | 205336 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5992219.92484 | 2089237.66093 | 37.7162019305526 | -122.46884485802099 | (37.7162019305526, -122.468844858021) | |||
| 146468 | 146468 | 205337 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5992219.91923 | 2089255.52232 | 37.716250973274704 | -122.46884617642901 | (37.7162509732747, -122.468846176429) | |||
| 24964 | 24964 | 205338 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Ralston St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5992219.15057 | 2089273.39944 | 37.716300015102796 | -122.46885013342899 | (37.7163000151028, -122.468850133429) | |||
| 61513 | 61513 | 205328 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 438 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5994041.13473 | 2089285.6739299998 | 37.7164388128869 | -122.462553409618 | (37.7164388128869, -122.462553409618) | |||
| 58663 | 58663 | 205335 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 134 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5991702.384930001 | 2089452.4236400002 | 37.7167617027762 | -122.470649341406 | (37.7167617027762, -122.470649341406) | |||
| 48237 | 48237 | 205333 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 Caine Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5997549.343280001 | 2089570.2528799998 | 37.717421611803495 | -122.45044787838002 | (37.7174216118035, -122.45044787838) | |||
| 148932 | 148932 | 175917 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 95 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010099.42141 | 2089574.9600900002 | 37.718144842076505 | -122.40706819096701 | (37.7181448420765, -122.407068190967) | |||
| 54791 | 54791 | 175874 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1441 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5999110.44202 | 2089599.42923 | 37.717590947838104 | -122.44505399834699 | (37.7175909478381, -122.445053998347) | |||
| 175950 | 175950 | 175945 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 901 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5998663.60507 | 2089603.57639 | 37.7175768212865 | -122.44659880250099 | (37.7175768212865, -122.446598802501) | |||
| 188196 | 188196 | 175918 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 95 Delta St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010112.71728 | 2089613.53023 | 37.7182514917899 | -122.407024949752 | (37.7182514917899, -122.407024949752) | |||
| 159339 | 159339 | 175919 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 95 Delta St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010124.34327 | 2089644.13259 | 37.718336170157 | -122.406986919224 | (37.718336170157, -122.406986919224) | |||
| 56275 | 56275 | 87953 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 97897 | 97897 | 87951 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 107077 | 107077 | 87952 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 145789 | 145789 | 87954 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 42232 | 42232 | 205327 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 218 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5994824.42193 | 2089656.9549900002 | 37.7175033403925 | -122.45987288223499 | (37.7175033403925, -122.459872882235) | |||
| 93049 | 93049 | 84597 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010148.19523638 | 2089662.82896813 | 37.7183888412655 | -122.406905789617 | (37.7183888412655, -122.406905789617) | ||
| 167568 | 167568 | 189317 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1015 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013888.25038 | 2089668.52955 | 37.718613065116294 | -122.393978282498 | (37.7186130651163, -122.393978282498) | ||||
| 187399 | 187399 | 205334 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 73 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997009.746259999 | 2089680.74953 | 37.7176941117806 | -122.452320974643 | (37.7176941117806, -122.452320974643) | |||
| 140666 | 140666 | 54120 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 775 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/2000 12:00:00 AM | Permit Number 9853 | 5994299.65074367 | 2089905.11614326 | 37.7181545378086 | -122.461704745095 | (37.7181545378086, -122.461704745095) | ||
| 181669 | 181669 | 205325 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 775 Lakeview Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5994321.8349 | 2089907.93714 | 37.718163560582795 | -122.46162826895599 | (37.7181635605828, -122.461628268956) | |||
| 47188 | 47188 | 205323 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 744 Lakeview Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5994595.93663 | 2089945.86852 | 37.7182834851695 | -122.460683570699 | (37.7182834851695, -122.460683570699) | |||
| 147270 | 147270 | 205324 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 748 Lakeview Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994550.0079 | 2089946.83095 | 37.7182834851855 | -122.460842395483 | (37.7182834851855, -122.460842395483) | |||
| 157561 | 157561 | 189316 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1089 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6013485.95319 | 2089984.75612 | 37.7194589935203 | -122.39539101131099 | (37.7194589935203, -122.395391011311) | ||||
| 71237 | 71237 | 205326 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 15 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995597.57429 | 2090027.5624 | 37.718565374973004 | -122.45722726115 | (37.718565374973, -122.45722726115) | |||
| 112072 | 112072 | 102061 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 5992454.0 | 2090050.0 | 37.718445937317796 | -122.468094845853 | (37.7184459373178, -122.468094845853) | |||
| 32340 | 32340 | 205339 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992450.822319999 | 2090054.7824900001 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | |||
| 39557 | 39557 | 189319 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1121 Jamestown Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013379.939590001 | 2090055.2755099998 | 37.71964672878121 | -122.39576240251499 | (37.7196467287812, -122.395762402515) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");