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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123638 | 123638 | 27929 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
128206 | 128206 | 27931 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
143792 | 143792 | 27934 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
108592 | 108592 | 25034 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
121919 | 121919 | 26536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 50 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | ||
123535 | 123535 | 25035 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
140592 | 140592 | 26537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
137503 | 137503 | 234343 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 6005056.066269999 | 2103868.0427200003 | 37.7571069049763 | -122.42551757317601 | (37.7571069049763, -122.425517573176) | |||
42292 | 42292 | 234344 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 751 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005051.924 | 2103931.9938 | 37.757282265587 | -122.42553644996299 | (37.757282265587, -122.425536449963) | |||
17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
18060 | 18060 | 25021 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005015.543430001 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | |||
19629 | 19629 | 25032 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005021.65336 | 2103769.84125 | 37.756835322312604 | -122.42562959723 | (37.7568353223126, -122.42562959723) | |||
19989 | 19989 | 25018 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005012.95019 | 2103889.3731400003 | 37.757163037054 | -122.42566820334 | (37.757163037054, -122.42566820334) | |||
21632 | 21632 | 25036 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005017.04415 | 2103831.36773 | 37.7570039991458 | -122.42564991650801 | (37.7570039991458, -122.425649916508) | |||
138553 | 138553 | 116529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 745X SANCHEZ ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
24676 | 24676 | 25027 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
69271 | 69271 | 25030 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
77825 | 77825 | 25016 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
80924 | 80924 | 25025 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
85048 | 85048 | 25019 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
88715 | 88715 | 25017 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
96774 | 96774 | 25020 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
18233 | 18233 | 25024 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005003.848780001 | 2104046.64903 | 37.757594365417496 | -122.42571087345699 | (37.7575943654175, -122.425710873457) | |||
18700 | 18700 | 25031 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6005006.55303 | 2104135.2293700003 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | |||
19160 | 19160 | 25028 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6005001.93677 | 2104182.12883 | 37.75796625306 | -122.425727128704 | (37.75796625306, -122.425727128704) | ||
21311 | 21311 | 25022 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.79572 | 2104126.38242 | 37.75781283950229 | -122.425744399279 | (37.7578128395023, -122.425744399279) | |||
101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
30590 | 30590 | 118002 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.780580098776795 | -122.49679463074699 | (37.7805800987768, -122.496794630747) | |||
127400 | 127400 | 119700 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
138316 | 138316 | 119699 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
92133 | 92133 | 27942 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
38595 | 38595 | 234356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004985.9304599995 | 2104422.99085 | 37.7586266989802 | -122.42579962935301 | (37.7586266989802, -122.425799629353) | ||||
131012 | 131012 | 234358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | ||||
157237 | 157237 | 234355 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004978.4588 | 2104465.76881 | 37.7587437349524 | -122.425828514675 | (37.7587437349524, -122.425828514675) | ||||
179789 | 179789 | 234357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004986.096919999 | 2104380.3629099997 | 37.758509662101204 | -122.425796019476 | (37.7585096621012, -122.425796019476) | ||||
83890 | 83890 | 27801 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
114362 | 114362 | 25635 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
117942 | 117942 | 25633 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
125804 | 125804 | 25634 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
140032 | 140032 | 25632 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
87718 | 87718 | 96830 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
110274 | 110274 | 96826 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
120614 | 120614 | 96829 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
121479 | 121479 | 96828 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
144123 | 144123 | 96827 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
6610 | 6610 | 25631 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.621619999 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | ||
8064 | 8064 | 25629 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.79627504929729 | -122.39536555327801 | (37.7962750492973, -122.395365553278) | ||
8404 | 8404 | 25630 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | ||
35095 | 35095 | 132128 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014303.114130001 | 2117497.5911 | 37.7950487184753 | -122.39449183764299 | (37.7950487184753, -122.394491837643) | |||
44784 | 44784 | 132123 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.795397945911205 | -122.394743875326 | (37.7953979459112, -122.394743875326) | |||
45951 | 45951 | 132119 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014187.59198 | 2117732.03905 | 37.795686034729 | -122.39490799262501 | (37.795686034729, -122.394907992625) | |||
54210 | 54210 | 132125 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014258.525909999 | 2117571.02815 | 37.79524788055 | -122.39465126585199 | (37.79524788055, -122.394651265852) | |||
54517 | 54517 | 132120 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014198.1938 | 2117703.48543 | 37.795608222695996 | -122.394869307388 | (37.795608222696, -122.394869307388) | |||
54710 | 54710 | 132121 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945031999 | (37.7955313378499, -122.39482945032) | |||
62627 | 62627 | 132124 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014245.1809 | 2117597.9501799997 | 37.7953210601821 | -122.39469932831301 | (37.7953210601821, -122.394699328313) | |||
131575 | 131575 | 132122 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.39479193780599 | (37.7954646414426, -122.394791937806) | |||
163255 | 163255 | 132126 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | |||
163649 | 163649 | 132127 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.79511912011571 | -122.39455279549401 | (37.7951191201157, -122.394552795494) | |||
183774 | 183774 | 132118 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6014172.89911 | 2117759.32578 | 37.795760140682894 | -122.394960745056 | (37.7957601406829, -122.394960745056) | |||
176298 | 176298 | 247642 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 632 Banks St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.41307547425501 | (37.7354426820387, -122.413075474255) | |||
100781 | 100781 | 109174 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.46264404963699 | (37.7270439629203, -122.462644049637) | |
110630 | 110630 | 92744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52968 | 6009200.0 | 2091312.0 | 37.722864017361395 | -122.41029969523998 | (37.7228640173614, -122.41029969524) | |||
68513 | 68513 | 210928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 5997342.33131 | 2095240.63361 | 37.732979290542104 | -122.451572201795 | (37.7329792905421, -122.451572201795) | ||||
95346 | 95346 | 96821 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
118260 | 118260 | 96823 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
127732 | 127732 | 96824 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
128933 | 128933 | 96822 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
141757 | 141757 | 96825 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
109140 | 109140 | 25155 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 60X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004737.5115877995 | 2107959.1242988 | 37.768322037027 | -122.426910616409 | (37.768322037027, -122.426910616409) | |||
130698 | 130698 | 234352 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6004969.77736 | 2104678.02917 | 37.7593260612613 | -122.425873648056 | (37.7593260612613, -122.425873648056) | ||||
161954 | 161954 | 234349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004962.28051 | 2104795.65924 | 37.7596486220069 | -122.42590794909599 | (37.7596486220069, -122.425907949096) | ||||
165757 | 165757 | 234350 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004963.57632 | 2104757.16703 | 37.759543004714 | -122.425900727537 | (37.759543004714, -122.425900727537) | ||||
177827 | 177827 | 234351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004966.99113 | 2104720.1905900002 | 37.759441669116796 | -122.425886285347 | (37.7594416691168, -122.425886285347) | ||||
182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
93392 | 93392 | 26026 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
110645 | 110645 | 27936 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | |||
127947 | 127947 | 26028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
144869 | 144869 | 26027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
144953 | 144953 | 26025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
70473 | 70473 | 210915 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994038.34106 | 2099299.34237 | 37.743933731866605 | -122.463289283487 | (37.7439337318666, -122.463289283487) | |||
159196 | 159196 | 210916 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) | |||
21228 | 21228 | 5457 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 8 | 6004998.45452 | 2104996.17843 | 37.760201244618294 | -122.42579711395099 | (37.7602012446183, -122.425797113951) | |||
39479 | 39479 | 234374 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6004996.87402 | 2105008.5457599997 | 37.760235113069896 | -122.425803460464 | (37.7602351130699, -122.425803460464) | |||
159189 | 159189 | 234375 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.760238249920604 | -122.425809806971 | (37.7602382499206, -122.425809806971) | |||
179975 | 179975 | 234373 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 9ft | 6004999.25531 | 2105001.6441599997 | 37.76021629747461 | -122.42579473344401 | (37.7602162974746, -122.425794733444) | |||
164993 | 164993 | 118208 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 578 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | |||
76588 | 76588 | 247039 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 574 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 6ft | 6002246.4280199995 | 2099186.76685 | 37.7440940809725 | -122.43489959305 | (37.7440940809725, -122.43489959305) | |||
126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) | ||||
119491 | 119491 | 234348 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004955.107340001 | 2105017.7620200003 | 37.760258058393205 | -122.425948567888 | (37.7602580583932, -122.425948567888) | ||||
133649 | 133649 | 234347 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | ||||
104738 | 104738 | 25646 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
113255 | 113255 | 25643 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) |
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");