Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95836 | 95836 | 29310 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
100870 | 100870 | 29309 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
108929 | 108929 | 29308 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
110045 | 110045 | 29301 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
112838 | 112838 | 29307 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
117140 | 117140 | 29298 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:33:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
119457 | 119457 | 29300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
139242 | 139242 | 29304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/23/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
139984 | 139984 | 29306 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:19:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
140081 | 140081 | 29311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/03/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
146106 | 146106 | 29299 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:24:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
83861 | 83861 | 19426 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
104159 | 104159 | 19424 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
122200 | 122200 | 19427 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
122760 | 122760 | 19425 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
115847 | 115847 | 23311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 11/18/2010 12:00:00 AM | 6 | 3X3 | 6006537.8278087005 | 2113902.4302931 | 37.7847425526754 | -122.421105541385 | (37.7847425526754, -122.421105541385) | ||
127717 | 127717 | 23312 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/18/2010 12:00:00 AM | 6 | 3X3 | 6006537.8278087005 | 2113902.4302931 | 37.7847425526754 | -122.421105541385 | (37.7847425526754, -122.421105541385) | ||
53388 | 53388 | 137760 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001423.7559 | 2112018.8276 | 37.7792810387103 | -122.438663489904 | (37.7792810387103, -122.438663489904) | |||
63089 | 63089 | 137761 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001442.3691 | 2111886.1663 | 37.7789178432038 | -122.43858959128299 | (37.7789178432038, -122.438589591283) | |||
67396 | 67396 | 137764 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001436.616 | 2111937.2679 | 37.7790578279952 | -122.438613156035 | (37.7790578279952, -122.438613156035) | |||
138085 | 138085 | 137763 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001437.9696 | 2111922.039 | 37.77901609029121 | -122.438607381917 | (37.7790160902912, -122.438607381917) | |||
154554 | 154554 | 137759 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001427.817000001 | 2112000.5528 | 37.7792310917629 | -122.438648131089 | (37.7792310917629, -122.438648131089) | |||
165225 | 165225 | 137749 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | |||
172170 | 172170 | 137762 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | |||
179995 | 179995 | 137750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209408995 | -122.43867130831 | (37.779356209409, -122.43867130831) | |||
34286 | 34286 | 221545 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005721.87722 | 2103062.7074700003 | 37.754933239094704 | -122.423157698184 | (37.7549332390947, -122.423157698184) | |||
67326 | 67326 | 221557 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.42305441913099 | (37.7537703032837, -122.423054419131) | |||
68227 | 68227 | 221553 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.111409999 | 2102791.4847 | 37.7541892146839 | -122.42309611170799 | (37.7541892146839, -122.423096111708) | |||
76663 | 76663 | 221554 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005736.5559 | 2102753.56312 | 37.754085228758505 | -122.423084962814 | (37.7540852287585, -122.423084962814) | |||
76927 | 76927 | 221546 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.96055 | 2103030.09242 | 37.7548438033068 | -122.423148175257 | (37.7548438033068, -122.423148175257) | |||
131374 | 131374 | 221548 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005727.072790001 | 2102965.9789400003 | 37.7546679382008 | -122.42313285530899 | (37.7546679382008, -122.423132855309) | |||
135861 | 135861 | 221547 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.42314790545299 | (37.7547603282456, -122.423147905453) | |||
143107 | 143107 | 221551 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005731.5319 | 2102850.00284 | 37.7543497463656 | -122.423109191463 | (37.7543497463656, -122.423109191463) | |||
169550 | 169550 | 221558 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005728.5881 | 2102926.2105099997 | 37.754558828830106 | -122.423124788381 | (37.7545588288301, -122.423124788381) | |||
176544 | 176544 | 221552 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.10722 | 2102815.94179 | 37.754256367947704 | -122.423097864468 | (37.7542563679477, -122.423097864468) | |||
176764 | 176764 | 221549 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) | |||
177873 | 177873 | 221550 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) | |||
180267 | 180267 | 221556 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.42306215689501 | (37.753875475376, -122.423062156895) | |||
182798 | 182798 | 221555 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | |||
30755 | 30755 | 208080 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991162.63824 | 2089810.37082 | 37.7177133113937 | -122.472541042839 | (37.7177133113937, -122.472541042839) | |||
31562 | 31562 | 212298 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991179.120709999 | 2090094.55389 | 37.7184945623549 | -122.47250477768699 | (37.7184945623549, -122.472504777687) | |||
31596 | 31596 | 205081 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.47243117628099 | (37.7198427189488, -122.472431176281) | |||
32028 | 32028 | 212310 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991202.259869999 | 2090434.6504900001 | 37.7194297232904 | -122.472449576395 | (37.7194297232904, -122.472449576395) | |||
33216 | 33216 | 208082 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991232.009819999 | 2090962.1201799999 | 37.720879746979705 | -122.47238517505 | (37.7208797469797, -122.47238517505) | |||
39182 | 39182 | 205077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991206.77223 | 2090490.8774299999 | 37.719584369801396 | -122.47243807587601 | (37.7195843698014, -122.472438075876) | |||
41461 | 41461 | 212306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.719151359714395 | -122.472463376508 | (37.7191513597144, -122.472463376508) | |||
42602 | 42602 | 208081 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991233.74878 | 2090918.35178 | 37.720759670396106 | -122.47237597496999 | (37.7207596703961, -122.47237597497) | |||
44624 | 44624 | 205088 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991229.30633 | 2090865.43732 | 37.7206141232198 | -122.47238747550301 | (37.7206141232198, -122.472387475503) | |||
52489 | 52489 | 212303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991192.118419999 | 2090269.21075 | 37.7189748794765 | -122.47247257657601 | (37.7189748794765, -122.472472576576) | |||
55711 | 55711 | 205076 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991204.8696099995 | 2090463.7504 | 37.7195097755318 | -122.472442675902 | (37.7195097755318, -122.472442675902) | |||
58519 | 58519 | 212305 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.47246797653901 | (37.7190858620976, -122.472467976539) | |||
62175 | 62175 | 212292 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991164.37326 | 2089829.54432 | 37.7177660575462 | -122.472536442798 | (37.7177660575462, -122.472536442798) | |||
65001 | 65001 | 208083 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991231.056580001 | 2090980.0304 | 37.720928868853896 | -122.472389775075 | (37.7209288688539, -122.472389775075) | |||
65755 | 65755 | 205087 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991229.32936 | 2090834.95737 | 37.7205304341251 | -122.47238517504499 | (37.7205304341251, -122.472385175045) | |||
66442 | 66442 | 212308 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.47244957640801 | (37.7193278390954, -122.472449576408) | |||
67053 | 67053 | 212297 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991177.8274300005 | 2090064.7629799999 | 37.7184126889791 | -122.47250707726002 | (37.7184126889791, -122.47250707726) | |||
67638 | 67638 | 205084 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991220.51447 | 2090732.43963 | 37.720248435491904 | -122.472408175222 | (37.7202484354919, -122.472408175222) | |||
68407 | 68407 | 212307 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991200.212719999 | 2090369.09522 | 37.7192496061609 | -122.47245187595 | (37.7192496061609, -122.47245187595) | |||
69407 | 69407 | 205083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991217.1837 | 2090700.70485 | 37.720161106826 | -122.472417376171 | (37.720161106826, -122.472417376171) | |||
70422 | 70422 | 205090 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991232.93514 | 2090942.88536 | 37.7208269864641 | -122.472380575028 | (37.7208269864641, -122.472380575028) | |||
72304 | 72304 | 205082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991216.27623 | 2090657.6545099998 | 37.720042848675604 | -122.47241737616501 | (37.7200428486756, -122.472417376165) | |||
73785 | 73785 | 205079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5991209.0936900005 | 2090537.87387 | 37.7197135448202 | -122.47243347583 | (37.7197135448202, -122.47243347583) | |||
146358 | 146358 | 212299 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991184.2984 | 2090150.76712 | 37.7186492097602 | -122.47249097667401 | (37.7186492097602, -122.472490976674) | |||
154256 | 154256 | 212294 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991166.95703 | 2089883.0190299999 | 37.7179130355286 | -122.472531408396 | (37.7179130355286, -122.472531408396) | |||
156267 | 156267 | 205085 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991225.77549 | 2090792.62573 | 37.720413996187 | -122.47239437511601 | (37.720413996187, -122.472394375116) | |||
157693 | 157693 | 212304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991192.55124 | 2090289.74279 | 37.7190312804608 | -122.472472576553 | (37.7190312804608, -122.472472576553) | |||
158549 | 158549 | 205078 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991207.21899 | 2090512.07145 | 37.7196425892212 | -122.47243807587601 | (37.7196425892212, -122.472438075876) | |||
162733 | 162733 | 212296 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991176.06439 | 2090044.25898 | 37.7183562879852 | -122.472511677268 | (37.7183562879852, -122.472511677268) | |||
163038 | 163038 | 212302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991190.15994 | 2090239.4345099998 | 37.7188930078858 | -122.47247717658001 | (37.7188930078858, -122.47247717658) | |||
166561 | 166561 | 212309 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991201.91083 | 2090418.0925900002 | 37.719384239169294 | -122.472449576413 | (37.7193842391693, -122.472449576413) | |||
169141 | 169141 | 205089 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991231.16702 | 2090890.57712 | 37.7206832586037 | -122.47238287549601 | (37.7206832586037, -122.472382875496) | |||
170614 | 170614 | 212293 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.717846180842294 | -122.472536226064 | (37.7178461808423, -122.472536226064) | |||
173416 | 173416 | 212300 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | |||
174777 | 174777 | 205080 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | |||
182927 | 182927 | 205086 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991226.90116 | 2090814.4677099998 | 37.7204740340313 | -122.472392075543 | (37.7204740340313, -122.472392075543) | |||
184198 | 184198 | 212301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991188.84719 | 2090215.0879099998 | 37.7188260821255 | -122.47247994019199 | (37.7188260821255, -122.472479940192) | |||
186690 | 186690 | 212295 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991170.53267 | 2089939.6813400001 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | |||
76622 | 76622 | 214857 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5991776.8185 | 2105223.32879 | 37.7600689102828 | -122.471540622615 | (37.7600689102828, -122.471540622615) | |||
58367 | 58367 | 132070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 6013297.802519999 | 2119184.84583 | 37.7996255806051 | -122.39808881644501 | (37.7996255806051, -122.398088816445) | |||
24987 | 24987 | 249468 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006497.80011 | 2114033.78335 | 37.7851009593808 | -122.421253354956 | (37.7851009593808, -122.421253354956) | |||
26885 | 26885 | 249467 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6006503.72956 | 2113992.67034 | 37.7849884074321 | -122.421229920427 | (37.7849884074321, -122.421229920427) | |||
71548 | 71548 | 249471 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006474.14305 | 2114137.78522 | 37.7853851892236 | -122.421342589296 | (37.7853851892236, -122.421342589296) | |||
147308 | 147308 | 249472 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6006469.09533 | 2114171.09667 | 37.785476369688 | -122.42136241936599 | (37.785476369688, -122.421362419366) | |||
157902 | 157902 | 249469 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006493.04465 | 2114068.6458799997 | 37.7851964152265 | -122.421272283894 | (37.7851964152265, -122.421272283894) | |||
162246 | 162246 | 249470 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006480.79574 | 2114106.51606 | 37.7852997068671 | -122.421317351637 | (37.7852997068671, -122.421317351637) | |||
150090 | 150090 | 140685 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x WEBSTER ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003852.8969 | 2112257.5815 | 37.7800744864318 | -122.43027712243799 | (37.7800744864318, -122.430277122438) | |||
114256 | 114256 | 106577 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
98125 | 98125 | 102273 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100X Casitas Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x14 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
110524 | 110524 | 102270 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X Casitas Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x100 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
111121 | 111121 | 102271 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 100X Casitas Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x200 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
119248 | 119248 | 102269 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 100X Casitas Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x10 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
124605 | 124605 | 102272 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 100X Casitas Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x70 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
142517 | 142517 | 102267 | DPW Maintained 3 | Shrub :: Shrub 98 | 100X Casitas Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x3 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
142952 | 142952 | 102268 | DPW Maintained 3 | Shrub :: Shrub 98 | 100X Casitas Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6x3 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
1982 | 1982 | 118349 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 3 | ||||||||
2168 | 2168 | 118346 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 3 | ||||||||
2766 | 2766 | 118353 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 3 | ||||||||
3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 |
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");