Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10647 | 10647 | 19755 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 16139 | 16139 | 19754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 105466 | 105466 | 12651 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992370.23809 | 2114839.71142 | 37.7865072187383 | -122.47018855413201 | (37.7865072187383, -122.470188554132) | |||
| 128154 | 128154 | 12652 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5992352.412880001 | 2114839.20557 | 37.7865047992766 | -122.47025018752399 | (37.7865047992766, -122.470250187524) | |||
| 102520 | 102520 | 2100 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 121104 | 121104 | 2102 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 141161 | 141161 | 2097 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 146288 | 146288 | 2099 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 103550 | 103550 | 26667 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1005X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992391.245730001 | 2114787.53549 | 37.7863651725209 | -122.470112072904 | (37.7863651725209, -122.470112072904) | |||
| 21923 | 21923 | 2107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1019 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6001281.91782 | 2095601.18761 | 37.7341941091789 | -122.437977868977 | (37.7341941091789, -122.437977868977) | ||
| 77692 | 77692 | 3754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1020 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 18 | 6012443.0515847 | 2103208.5839527003 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | |||
| 22127 | 22127 | 10169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1025 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005766.4364 | 2102791.42728 | 37.7541908811074 | -122.422984319668 | (37.7541908811074, -122.422984319668) | |||
| 106945 | 106945 | 19176 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 103 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003521.128629 | 2107701.1764308996 | 37.7675449218832 | -122.431099554618 | (37.7675449218832, -122.431099554618) | |||
| 87969 | 87969 | 24481 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 103X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002240.5138934 | 2096668.0977393002 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | |||
| 119614 | 119614 | 8152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1040 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6002782.41251 | 2111346.1011200002 | 37.7775110971373 | -122.433915238462 | (37.7775110971373, -122.433915238462) | |||
| 92301 | 92301 | 12659 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1040 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992205.79142 | 2114830.06485 | 37.7864712234678 | -122.47075679064301 | (37.7864712234678, -122.470756790643) | |||
| 19148 | 19148 | 2110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2005 12:00:00 AM | 3 | 3X3 | 6001168.361930001 | 2095632.80978 | 37.734274477972896 | -122.43837273163601 | (37.7342744779729, -122.438372731636) | ||
| 118523 | 118523 | 12662 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1044 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992177.16633 | 2114831.4087900002 | 37.7864732581467 | -122.470855923323 | (37.7864732581467, -122.470855923323) | |||
| 114258 | 114258 | 8154 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1056 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002712.32604 | 2111336.3258700003 | 37.7774802791955 | -122.434156991651 | (37.7774802791955, -122.434156991651) | |||
| 107310 | 107310 | 20153 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1057 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002883.62839 | 2111924.02445 | 37.779103673622295 | -122.433606412251 | (37.7791036736223, -122.433606412251) | |||
| 109266 | 109266 | 20154 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1057 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1995 12:00:00 AM | 12 | 3X3 | 6002861.53407 | 2111923.7394 | 37.77910163730439 | -122.433682825046 | (37.7791016373044, -122.433682825046) | ||
| 7212 | 7212 | 6169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1075 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 3 | 3x3 | 6005763.6544 | 2113429.69831 | 37.7834008746955 | -122.423750304634 | (37.7834008746955, -122.423750304634) | ||
| 92955 | 92955 | 6180 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1075 Ellis St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | |||
| 119640 | 119640 | 6170 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1075 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | |||
| 20831 | 20831 | 24479 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 108X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002216.666730001 | 2096706.7655900002 | 37.7372828846813 | -122.434825185857 | (37.7372828846813, -122.434825185857) | |||
| 105083 | 105083 | 4386 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001708.3008261 | 2095817.8256998002 | 37.7348131857142 | -122.436519230882 | (37.7348131857142, -122.436519230882) | |||
| 134097 | 134097 | 189485 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Garlington Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016768.7449900005 | 2094679.8943900003 | 37.7325329624249 | -122.384370330438 | (37.7325329624249, -122.384370330438) | |||
| 53230 | 53230 | 248775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6002997.286669999 | 2095073.79392 | 37.732843406592295 | -122.432009651347 | (37.7328434065923, -122.432009651347) | |||
| 135595 | 135595 | 248774 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6003001.138169999 | 2095064.3103599998 | 37.7328175852443 | -122.43199565878 | (37.7328175852443, -122.43199565878) | |||
| 163293 | 163293 | 248777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6002988.77776 | 2095086.3960799999 | 37.7328775268597 | -122.43203996838699 | (37.7328775268597, -122.432039968387) | |||
| 188426 | 188426 | 248776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6002998.16884 | 2095083.8511700002 | 37.73287107152721 | -122.43200731937999 | (37.7328710715272, -122.43200731938) | |||
| 80329 | 80329 | 14886 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6017031.41664 | 2098528.6924900003 | 37.743115510800706 | -122.383730076065 | (37.7431155108007, -122.383730076065) | ||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103736 | 103736 | 2138 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 109301 | 109301 | 2114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 111789 | 111789 | 2122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 14 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 124325 | 124325 | 2136 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125511 | 125511 | 2128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128749 | 128749 | 2116 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 141483 | 141483 | 2129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 142290 | 142290 | 2131 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 17402 | 17402 | 2557 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1101 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001119.92736 | 2095647.46626 | 37.7343119662085 | -122.43854123490802 | (37.7343119662085, -122.438541234908) | |||
| 101724 | 101724 | 8162 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1104 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6002393.15082 | 2111291.80956 | 37.7773399284264 | -122.435257938115 | (37.7773399284264, -122.435257938115) | |||
| 103925 | 103925 | 2556 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1105X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001087.07151 | 2095656.5462099998 | 37.734335028599 | -122.43865547833201 | (37.734335028599, -122.438655478332) | |||
| 142226 | 142226 | 2555 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1105X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001048.76834 | 2095649.35823 | 37.7343131130124 | -122.438787389587 | (37.7343131130124, -122.438787389587) | |||
| 95442 | 95442 | 29636 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 98950 | 98950 | 29632 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 99891 | 99891 | 29635 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 100149 | 100149 | 29637 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 103060 | 103060 | 29629 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 103985 | 103985 | 29638 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 108232 | 108232 | 29628 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 140900 | 140900 | 29634 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) |
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");