Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125644 | 125644 | 3784 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.735613192974704 | -122.382544123056 | (37.7356131929747, -122.382544123056) | ||
| 120792 | 120792 | 1764 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 139081 | 139081 | 92211 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 34129 | 34129 | 63191 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.006630001 | 2112603.98729 | 37.7798871547077 | -122.49862546555599 | (37.7798871547077, -122.498625465556) |
| 160351 | 160351 | 63201 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 434 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 17 | Permit Number 23742 | 5984713.13689 | 2112937.02697 | 37.7808373486479 | -122.496539369055 | (37.7808373486479, -122.496539369055) | |
| 84587 | 84587 | 57695 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1976 12:00:00 AM | 30 | 6x6 | Permit Number 16599 | 6001771.77462005 | 2103491.48426394 | 37.75588684919521 | -122.436848936392 | (37.7558868491952, -122.436848936392) | |
| 88221 | 88221 | 46423 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 179 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1969 12:00:00 AM | Permit Number 44645 | 5999395.58867085 | 2107159.64271916 | 37.765823365237296 | -122.445330264611 | (37.7658233652373, -122.445330264611) | |||
| 107617 | 107617 | 12553 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X Lake St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/1992 12:00:00 AM | 24 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | ||
| 144019 | 144019 | 30320 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 867 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.773194323540004 | -122.484328404455 | (37.77319432354, -122.484328404455) | |||
| 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) | ||
| 92060 | 92060 | 87052 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 511 Euclid Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789.0 | 37.783875296894294 | -122.45491032952499 | (37.7838752968943, -122.454910329525) | |||
| 81015 | 81015 | 11666 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1992 12:00:00 AM | 12 | 4X4 | 5991320.9947906 | 2093088.5989831001 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | ||
| 98229 | 98229 | 62433 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.762087537224396 | -122.44303428204901 | (37.7620875372244, -122.443034282049) | ||
| 143093 | 143093 | 45817 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1168 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44444 | 6015539.10076278 | 2103555.89602939 | 37.756836556070496 | -122.389241112249 | (37.7568365560705, -122.389241112249) | |||
| 101100 | 101100 | 33710 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 107 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37778 | 6003699.03578605 | 2108805.33287927 | 37.770586746466606 | -122.430562993164 | (37.7705867464666, -122.430562993164) | |||
| 117549 | 117549 | 33715 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 184 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37783 | 6003401.63659312 | 2108816.63624682 | 37.770600930555894 | -122.431592506668 | (37.7706009305559, -122.431592506668) | ||
| 95388 | 95388 | 33683 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.42478108729999 | (37.7772038638652, -122.4247810873) | |||
| 103408 | 103408 | 33684 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.42478108729999 | (37.7772038638652, -122.4247810873) | |||
| 143413 | 143413 | 33677 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 455 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.42560274302299 | (37.776954366261, -122.425602743023) | |||
| 145919 | 145919 | 33685 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.42478108729999 | (37.7772038638652, -122.4247810873) | |||
| 155674 | 155674 | 33680 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.777026699408296 | -122.425035932953 | (37.7770266994083, -122.425035932953) | ||
| 20806 | 20806 | 2048 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2000 12:00:00 AM | 3 | 3X3 | 6001958.681419999 | 2095417.21372 | 37.7337274221844 | -122.435624928664 | (37.7337274221844, -122.435624928664) | ||
| 120353 | 120353 | 33561 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 270 PROSPECT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37668 | 6006489.0 | 2098160.0 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | |||
| 63415 | 63415 | 33467 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.744638227793395 | -122.419218573599 | (37.7446382277934, -122.419218573599) | ||
| 77439 | 77439 | 33533 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.41742214701401 | (37.7409482571652, -122.417422147014) | |||
| 79901 | 79901 | 33532 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 179 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | 16 | 5x5 | Permit Number 37642 | 6007307.15222384 | 2097996.82035732 | 37.741112790036794 | -122.41731638048401 | (37.7411127900368, -122.417316380484) | |
| 80970 | 80970 | 33511 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.41869883835899 | (37.7454365257217, -122.418698838359) | |||
| 83354 | 83354 | 33464 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 52 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37617 | 6006854.98101405 | 2099423.3660818003 | 37.7450043146116 | -122.418980984578 | (37.7450043146116, -122.418980984578) | ||
| 85324 | 85324 | 33493 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | ||
| 91219 | 91219 | 33466 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 60 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37619 | 6006826.41498367 | 2099370.6210257 | 37.7448578799465 | -122.41907602046601 | (37.7448578799465, -122.419076020466) | ||
| 95599 | 95599 | 33528 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 183 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37638 | 6007285.94975907 | 2097957.3067179 | 37.7410031014535 | -122.417386891564 | (37.7410031014535, -122.417386891564) | ||
| 109025 | 109025 | 33515 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37620 | 6006865.28384578 | 2099333.19830806 | 37.74475731433971 | -122.41893896519899 | (37.7447573143397, -122.418938965199) | |||
| 109169 | 109169 | 33489 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 41 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37615 | 6006958.13481375 | 2099504.24101761 | 37.7452321871095 | -122.41863003056999 | (37.7452321871095, -122.41863003057) | |||
| 113077 | 113077 | 33531 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 177 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37641 | 6007317.75345238 | 2098016.57716988 | 37.741167634292005 | -122.417281124878 | (37.741167634292, -122.417281124878) | ||
| 114203 | 114203 | 33523 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 180 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37633 | 6007234.13744004 | 2097970.72636993 | 37.7410370335385 | -122.417566990918 | (37.7410370335385, -122.417566990918) | |||
| 120610 | 120610 | 33503 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 161 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | 3x3 | Permit Number 37597 | 6006560.16848411 | 2098769.04119675 | 37.7431910803563 | -122.41995397132 | (37.7431910803563, -122.41995397132) | |
| 121117 | 121117 | 33542 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 213 BOCANA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007149.0 | 2097726.0 | 37.740360278366104 | -122.417844022689 | (37.7403602783661, -122.417844022689) | |||
| 123999 | 123999 | 33492 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | ||
| 126596 | 126596 | 33502 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.743270591712104 | -122.419902509091 | (37.7432705917121, -122.419902509091) | ||
| 143201 | 143201 | 33536 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 187 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37646 | 6007264.74730199 | 2097917.79309279 | 37.740893412865894 | -122.417457402411 | (37.7408934128659, -122.417457402411) | |||
| 84125 | 84125 | 52252 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 237 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48419 | 6006717.04487845 | 2104738.84078637 | 37.7595916236736 | -122.419835049965 | (37.7595916236736, -122.419835049965) | |||
| 76127 | 76127 | 50574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 108489 | 108489 | 50567 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 138454 | 138454 | 50572 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 129049 | 129049 | 41146 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1534 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41879 | 5998316.1437305 | 2108281.00611102 | 37.7688406669583 | -122.449144612222 | (37.7688406669583, -122.449144612222) | ||
| 91115 | 91115 | 57655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 101 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1976 12:00:00 AM | 20 | 6x8 | Permit Number 16555 | 6006226.5518322 | 2097569.54766444 | 37.7398787392856 | -122.42102238294301 | (37.7398787392856, -122.421022382943) | |
| 98155 | 98155 | 19460 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1700X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 3 | 20 | 5985858.9484667 | 2095882.6709765 | 37.7340778499573 | -122.49131993236901 | (37.7340778499573, -122.491319932369) | ||
| 99939 | 99939 | 19428 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1200X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 3 | 20 | 5987947.5018995 | 2095985.7700737999 | 37.7344827526385 | -122.484106799366 | (37.7344827526385, -122.484106799366) | ||
| 114224 | 114224 | 19423 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 880X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 187259 | 187259 | 92861 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2245 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 11 | 3x3 | 6006750.866719999 | 2118980.24307 | 37.7986969721415 | -122.42072910149099 | (37.7986969721415, -122.420729101491) | ||
| 126732 | 126732 | 94848 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970.0 | 2109980.0 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | |
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 79741 | 79741 | 16693 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X NORIEGA ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991142.4 | 2103205.1 | 37.7544906639436 | -122.473587529216 | (37.7544906639436, -122.473587529216) | ||
| 82044 | 82044 | 33219 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 89057 | 89057 | 33184 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.743997782291395 | -122.46324393518499 | (37.7439977822914, -122.463243935185) | ||
| 107470 | 107470 | 33185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.743997782291395 | -122.46324393518499 | (37.7439977822914, -122.463243935185) | ||
| 109389 | 109389 | 33217 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 114080 | 114080 | 33218 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 121772 | 121772 | 33216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 91120 | 91120 | 53212 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 132 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | |||
| 59209 | 59209 | 33675 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | |
| 89125 | 89125 | 44162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 853 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | Permit Number 43636 | 6002495.49530521 | 2109506.13705466 | 37.772442727355205 | -122.43477616990101 | (37.7724427273552, -122.434776169901) | ||
| 44875 | 44875 | 32939 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.76122625950521 | -122.39674381646999 | (37.7612262595052, -122.39674381647) | |
| 67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
| 110404 | 110404 | 38838 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | Permit Number 40667 | 5994882.83677024 | 2114872.91229278 | 37.7867433187024 | -122.46149805609501 | (37.7867433187024, -122.461498056095) | ||
| 86969 | 86969 | 99459 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |
| 100862 | 100862 | 99476 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 19233 | 19233 | 5084 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2567 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1994 12:00:00 AM | 12 | 3X3 | 6002282.63151 | 2096922.4202 | 37.7378787673769 | -122.434612531259 | (37.7378787673769, -122.434612531259) | ||
| 3045 | 3045 | 141431 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.776585419130896 | -122.42481571306601 | (37.7765854191309, -122.424815713066) | |
| 94325 | 94325 | 52113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.42465811266199 | (37.7765968250138, -122.424658112662) | |
| 51955 | 51955 | 57553 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 18 | 3x3 | Permit Number 16416 | 6004949.77312 | 2110889.41028 | 37.7763798917414 | -122.426385087108 | (37.7763798917414, -122.426385087108) | |
| 139549 | 139549 | 55340 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | Permit Number 769406 | 5992478.56101588 | 2104770.1953725 | 37.758865297372104 | -122.46908067431299 | (37.7588652973721, -122.469080674313) | |||
| 77803 | 77803 | 86893 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | ||
| 119201 | 119201 | 57140 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3224 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 22 | 4x4 | Permit Number 14415 | 6007386.0 | 2102705.0 | 37.7540448270925 | -122.417377329228 | (37.7540448270925, -122.417377329228) | |
| 127381 | 127381 | 57112 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 3x3 | Permit Number 14382 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | ||
| 95868 | 95868 | 50448 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 303on BOCANA Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47095 | 6006949.39342482 | 2097361.11055858 | 37.739347137768604 | -122.418508317181 | (37.7393471377686, -122.418508317181) | |||
| 81000 | 81000 | 57042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 14305. Tree 1 on Page St | 5999842.06289616 | 2109172.2578569 | 37.7713749769665 | -122.44393062683201 | (37.7713749769665, -122.443930626832) | |||
| 123756 | 123756 | 52083 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | |||
| 77699 | 77699 | 50634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 98743 | 98743 | 50635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 135524 | 135524 | 50633 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997210996 | -122.393359654849 | (37.721936997211, -122.393359654849) | |
| 130842 | 130842 | 67625 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1281 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 16 | Permit Number 31211 | 6007384.19721 | 2118457.0336700003 | 37.7972960451262 | -122.41850045014601 | (37.7972960451262, -122.418500450146) | |
| 122131 | 122131 | 85112 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4201 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198.0 | 2102882.0 | 37.7541807256906 | -122.43878955892201 | (37.7541807256906, -122.438789558922) | |||
| 7248 | 7248 | 65393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | ||
| 40493 | 40493 | 53401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.4951299997 | 37.774181835613206 | -122.476707321825 | (37.7741818356132, -122.476707321825) | ||
| 135052 | 135052 | 49693 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 23 | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) |
| 92857 | 92857 | 53058 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | |||
| 107100 | 107100 | 53057 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | |||
| 165321 | 165321 | 64666 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2649 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1988 12:00:00 AM | 20 | Permit Number 25599 | 6000212.56039 | 2118841.15322 | 37.7979443906796 | -122.443343666786 | (37.7979443906796, -122.443343666786) | ||
| 32763 | 32763 | 68295 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.604780001 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | |
| 40997 | 40997 | 68216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 13 | 4x4 | Permit Number 32003 | 5991199.85508 | 2112923.89297 | 37.781179180083704 | -122.474097911754 | (37.7811791800837, -122.474097911754) |
| 124432 | 124432 | 53048 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.42288195252199 | (37.7391743410359, -122.422881952522) | |||
| 165111 | 165111 | 39935 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770539 | 6010138.7177 | 2087941.04422 | 37.713660642495 | -122.406817269312 | (37.713660642495, -122.406817269312) |
| 115643 | 115643 | 71451 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1329 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1982 12:00:00 AM | 14 | 3x3 | 6007730.91514483 | 2101916.84218349 | 37.751900124737205 | -122.41612871161301 | (37.7519001247372, -122.416128711613) | ||
| 116460 | 116460 | 52036 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 551 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2005 12:00:00 AM | Permit Number 48248 | 6003933.03406109 | 2105071.04130005 | 37.760346535270706 | -122.429487238107 | (37.7603465352707, -122.429487238107) | |||
| 78022 | 78022 | 50314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 98374 | 98374 | 50312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 127177 | 127177 | 50313 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 142729 | 142729 | 50311 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 143258 | 143258 | 50315 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) |
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");