Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77325 | 77325 | 5120 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 135 | 5X5 | 6002393.1757827 | 2096184.1201448997 | 37.735857840487206 | -122.434177561301 | (37.7358578404872, -122.434177561301) | |||
| 85913 | 85913 | 12591 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 540 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 135 | 3X3 | 5993752.44537 | 2114880.64385 | 37.7866994199903 | -122.465409472784 | (37.7866994199903, -122.465409472784) | |||
| 97213 | 97213 | 12530 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 114 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 130 | 3X3 | 5995104.55115 | 2114935.75764 | 37.786928633878205 | -122.460735538354 | (37.7869286338782, -122.460735538354) | |||
| 119052 | 119052 | 12535 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 130 | 3X3 | 5994996.21554 | 2114933.31934 | 37.7869157052582 | -122.461110175363 | (37.7869157052582, -122.461110175363) | |||
| 78599 | 78599 | 12607 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 653 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 9x7 | 5993406.40366 | 2114819.71467 | 37.7865121620391 | -122.46660225402901 | (37.7865121620391, -122.466602254029) | |||
| 83955 | 83955 | 12598 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 604 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993561.79248 | 2114876.17941 | 37.786676164615294 | -122.46606875626001 | (37.7866761646153, -122.46606875626) | |||
| 94716 | 94716 | 19364 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993918.28317 | 2114892.65914 | 37.7867419735566 | -122.464836591079 | (37.7867419735566, -122.464836591079) | |||
| 125820 | 125820 | 12592 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993704.83087 | 2114833.84106 | 37.7865681661673 | -122.465570804819 | (37.7865681661673, -122.465570804819) | |||
| 126700 | 126700 | 12581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3x3 | 5994092.89819 | 2114844.89484 | 37.7866208917825 | -122.46422900028 | (37.7866208917825, -122.46422900028) | |||
| 127418 | 127418 | 12606 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 651 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3X3 | 5993439.12695 | 2114820.30449 | 37.786515669843205 | -122.466489083379 | (37.7865156698432, -122.466489083379) | |||
| 114429 | 114429 | 12626 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 830 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 120 | 3X3 | 5992851.54693 | 2114852.9076 | 37.786571265759 | -122.468524319967 | (37.786571265759, -122.468524319967) | |||
| 118283 | 118283 | 12625 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 830 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 120 | 3X3 | 5992875.842730001 | 2114855.09948 | 37.786578687444795 | -122.46844042271401 | (37.7865786874448, -122.468440422714) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 16630 | 16630 | 4771 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016532.61927 | 2094742.5477 | 37.7326919364855 | -122.385191045451 | (37.7326919364855, -122.385191045451) | |||
| 19090 | 19090 | 17231 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001200.02819 | 2098556.64623 | 37.7423044507995 | -122.438472666097 | (37.7423044507995, -122.438472666097) | |||
| 78188 | 78188 | 7673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 82446 | 82446 | 4768 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Commer Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1993 12:00:00 AM | 100 | 3X3 | 6016521.3746591 | 2094751.2728264 | 37.7327152718937 | -122.385230528967 | (37.7327152718937, -122.385230528967) | ||
| 84814 | 84814 | 4766 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Commer Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016516.0463685 | 2094701.5331358002 | 37.7325784018492 | -122.38524548572799 | (37.7325784018492, -122.385245485728) | |||
| 86346 | 86346 | 12587 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 452 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 6X6 | 5994011.04137 | 2114897.5595 | 37.7867607761959 | -122.46451602816299 | (37.7867607761959, -122.464516028163) | |||
| 88522 | 88522 | 13394 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999367.9101935 | 2097504.6578797 | 37.7393115562077 | -122.444731949771 | (37.7393115562077, -122.444731949771) | |||
| 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) | |||
| 101124 | 101124 | 4763 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 22 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016508.324428201 | 2094752.2608580003 | 37.732717262878396 | -122.385275716107 | (37.7327172628784, -122.385275716107) | |||
| 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) | |||
| 105690 | 105690 | 8166 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1124 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002264.1606 | 2111273.81911 | 37.7772832052401 | -122.435702869129 | (37.7772832052401, -122.435702869129) | |||
| 116697 | 116697 | 12594 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5993765.6939900005 | 2114834.3012 | 37.786572939805204 | -122.465360268476 | (37.7865729398052, -122.465360268476) | |||
| 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) | |||
| 119858 | 119858 | 12540 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 227 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5994726.9405 | 2114869.90451 | 37.786726085899794 | -122.462037198106 | (37.7867260858998, -122.462037198106) | |||
| 128485 | 128485 | 12541 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 233 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994692.63999 | 2114868.9307 | 37.7867214372248 | -122.462155798195 | (37.7867214372248, -122.462155798195) | |||
| 145511 | 145511 | 19288 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995247.58897 | 2114888.2393799997 | 37.7868063902482 | -122.46023721951599 | (37.7868063902482, -122.460237219516) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 22189 | 22189 | 24547 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007976.32415 | 2097161.8833 | 37.7388578628999 | -122.41494353791501 | (37.7388578628999, -122.414943537915) | |||
| 22218 | 22218 | 24546 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007961.02706 | 2097162.19636 | 37.7388578629053 | -122.414996450438 | (37.7388578629053, -122.414996450438) | |||
| 24663 | 24663 | 8164 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 77941 | 77941 | 12543 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 239 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5994669.04887 | 2114868.49847 | 37.786718892107004 | -122.46223738589701 | (37.786718892107, -122.462237385897) | |||
| 78527 | 78527 | 17723 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 83978 | 83978 | 12629 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 841 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992807.546159999 | 2114798.7757900003 | 37.7864200929582 | -122.468672610251 | (37.7864200929582, -122.468672610251) | |||
| 90915 | 90915 | 8148 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93458 | 93458 | 8147 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 96047 | 96047 | 12637 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 906 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992634.642000001 | 2114847.92041 | 37.786545040682604 | -122.469274388054 | (37.7865450406826, -122.469274388054) | |||
| 101785 | 101785 | 8165 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1114 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6002315.0099 | 2111292.01756 | 37.7773360617805 | -122.43552826746 | (37.7773360617805, -122.43552826746) | |||
| 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) | |||
| 104514 | 104514 | 19289 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5995266.05457 | 2114888.3363099997 | 37.786807718526795 | -122.46017334032699 | (37.7868077185268, -122.460173340327) | |||
| 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) | |||
| 110333 | 110333 | 12601 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993509.18858 | 2114827.45466 | 37.78653934484179 | -122.466247209305 | (37.7865393448418, -122.466247209305) | |||
| 111419 | 111419 | 12531 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 114 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6x5.4 | 5995086.0585900005 | 2114933.3198700002 | 37.7869208764305 | -122.460799341203 | (37.7869208764305, -122.460799341203) | |||
| 113302 | 113302 | 17727 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 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) | |||
| 122600 | 122600 | 28145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 429 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4x4 | 6006920.737469 | 2097958.7102788 | 37.7409864003091 | -122.418649764286 | (37.7409864003091, -122.418649764286) | |||
| 124902 | 124902 | 12672 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1132 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 5991897.52815 | 2114823.03375 | 37.786434086563 | -122.47182278185 | (37.786434086563, -122.47182278185) | |||
| 140018 | 140018 | 12815 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988780.51636 | 2114651.15635 | 37.7857813149586 | -122.48259413097601 | (37.7857813149586, -122.482594130976) | |||
| 142189 | 142189 | 12599 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5993522.38559 | 2114878.2686900003 | 37.786679627677294 | -122.466205245403 | (37.7866796276773, -122.466205245403) | |||
| 145303 | 145303 | 5126 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2750 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002442.8157587005 | 2095988.0085916 | 37.735322180490705 | -122.433991922534 | (37.7353221804907, -122.433991922534) | |||
| 145996 | 145996 | 12586 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 446 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 5994034.10882 | 2114901.58036 | 37.78677314610329 | -122.46443651291 | (37.7867731461033, -122.46443651291) | |||
| 19976 | 19976 | 5077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2530 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6002265.741640001 | 2097118.1201900002 | 37.738415155434296 | -122.434684917677 | (37.7384151554343, -122.434684917677) | |||
| 119186 | 119186 | 15987 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2543 Diamond St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | |||
| 121388 | 121388 | 15986 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2543 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | |||
| 14530 | 14530 | 12145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016306.3498599995 | 2095580.8792299998 | 37.734981307347205 | -122.386031740688 | (37.7349813073472, -122.386031740688) | |||
| 16427 | 16427 | 4769 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016624.63849 | 2094705.64307 | 37.732595693724605 | -122.384870339116 | (37.7325956937246, -122.384870339116) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 78918 | 78918 | 332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 84548 | 84548 | 13398 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 332 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 5 | 5999526.1960451 | 2097456.6056762002 | 37.739188647769296 | -122.44418121753901 | (37.7391886477693, -122.444181217539) | |||
| 89424 | 89424 | 8145 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 102654 | 102654 | 13397 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 326 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 5 | 5999496.7834134 | 2097465.9380067 | 37.7392125940965 | -122.44428358328001 | (37.7392125940965, -122.44428358328) | |||
| 103486 | 103486 | 27636 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 5994810.252090001 | 2114930.5984900002 | 37.7868975312955 | -122.461753364309 | (37.7868975312955, -122.461753364309) | |||
| 104551 | 104551 | 17603 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003916.62917 | 2090182.06037 | 37.7194638711075 | -122.428482700528 | (37.7194638711075, -122.428482700528) | |||
| 105533 | 105533 | 12657 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1030 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5992237.14862 | 2114834.7776 | 37.786485976689704 | -122.470648646947 | (37.7864859766897, -122.470648646947) | |||
| 112561 | 112561 | 14576 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5999375.95624 | 2108930.97827 | 37.7706858855295 | -122.445525553195 | (37.7706858855295, -122.445525553195) | |||
| 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) | |||
| 123133 | 123133 | 27430 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007606.86637 | 2121548.41017 | 37.8057967194592 | -122.417949212693 | (37.8057967194592, -122.417949212693) | |||
| 129460 | 129460 | 12580 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 430 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5X4 | 5994092.37339 | 2114901.2583 | 37.7867756202333 | -122.46423490940599 | (37.7867756202333, -122.464234909406) | |||
| 144164 | 144164 | 12568 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 325 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5994431.11917 | 2114832.80083 | 37.7866071733964 | -122.46305796876999 | (37.7866071733964, -122.46305796877) | |||
| 17846 | 17846 | 5083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2566 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6002238.293895099 | 2096914.6597978 | 37.7378549419938 | -122.434765273064 | (37.7378549419938, -122.434765273064) | |||
| 19719 | 19719 | 5088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2586 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002230.0958 | 2096785.7567599998 | 37.737500538614896 | -122.43478440250401 | (37.7375005386149, -122.434784402504) | |||
| 85802 | 85802 | 15985 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2543 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | |||
| 18773 | 18773 | 24545 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X4 | 6007936.0377400005 | 2097164.78596 | 37.7388635691031 | -122.415083035373 | (37.7388635691031, -122.415083035373) | |||
| 78668 | 78668 | 17728 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | ||
| 90178 | 90178 | 13395 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 316 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 5 | 5999447.6447037 | 2097480.7016993 | 37.7392503280525 | -122.44445454302401 | (37.7392503280525, -122.444454543024) | |||
| 106485 | 106485 | 12547 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5994746.027369999 | 2114925.4133 | 37.7868795968599 | -122.461975189313 | (37.7868795968599, -122.461975189313) | |||
| 106938 | 106938 | 12633 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 901 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 5992608.24045 | 2114791.4731 | 37.786388526257795 | -122.46936161985501 | (37.7863885262578, -122.469361619855) | |||
| 118089 | 118089 | 12634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 901 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 5992626.819069999 | 2114790.44344 | 37.7863867727046 | -122.469297268142 | (37.7863867727046, -122.469297268142) | |||
| 119942 | 119942 | 12635 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 901 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5992640.98396 | 2114793.0195 | 37.7863946643837 | -122.469248449218 | (37.7863946643837, -122.469248449218) | |||
| 121579 | 121579 | 12676 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1302 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 5991438.14945 | 2114803.82797 | 37.786354762234 | -122.473410699647 | (37.786354762234, -122.473410699647) | |||
| 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) | |||
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 122426 | 122426 | 5124 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2740 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6002421.30392 | 2096030.43222 | 37.735437445185106 | -122.434069328485 | (37.7354374451851, -122.434069328485) | |||
| 158348 | 158348 | 217821 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 65 | 5991615.013669999 | 2095586.81694 | 37.7336001735084 | -122.471398059368 | (37.7336001735084, -122.471398059368) | ||||
| 20073 | 20073 | 12679 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 5991386.800919999 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | |||
| 72525 | 72525 | 12552 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X Lake St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | |||
| 105613 | 105613 | 4767 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6016521.3746591 | 2094751.2728264 | 37.7327152718937 | -122.385230528967 | (37.7327152718937, -122.385230528967) | |||
| 142391 | 142391 | 98324 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1899X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | |||
| 144984 | 144984 | 12574 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 352 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 5994320.89991 | 2114924.89711 | 37.7868536951076 | -122.463445983594 | (37.7868536951076, -122.463445983594) | |||
| 9706 | 9706 | 5132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2787 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 5X5 | 6002542.444802401 | 2095842.6422614 | 37.734928691439706 | -122.433637082687 | (37.7349286914397, -122.433637082687) | |||
| 96965 | 96965 | 112126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | ||||
| 19765 | 19765 | 16171 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 427 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999238.94733 | 2094646.5725200002 | 37.731456569253396 | -122.444972438847 | (37.7314565692534, -122.444972438847) | |||
| 58965 | 58965 | 331 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 92957 | 92957 | 9322 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 109X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6001353.7110351 | 2098757.7986155 | 37.7428655085674 | -122.43795568375 | (37.7428655085674, -122.43795568375) | |||
| 104816 | 104816 | 1994 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 164 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007305.0525987 | 2098100.7713839 | 37.7413980983192 | -122.41733100504601 | (37.7413980983192, -122.417331005046) | |||
| 111897 | 111897 | 12677 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1302 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 5991425.31232 | 2114802.71928 | 37.7863509747102 | -122.473455031506 | (37.7863509747102, -122.473455031506) | |||
| 112488 | 112488 | 10569 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1627X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6001688.62119 | 2092532.05532 | 37.7257900940002 | -122.436352188242 | (37.7257900940002, -122.436352188242) |
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");