trees
3,587 rows where qSpecies_id = 28 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34548 | 3784 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.7356131929747 | -122.382544123056 | (37.7356131929747, -122.382544123056) | 10 | 3 | 8 | 58 | 1 | ||
165448 | 1764 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
185735 | 92211 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
177425 | 63201 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 434 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 17 | Permit Number 23742 | 5984713.13689 | 2112937.02697 | 37.7808373486479 | -122.496539369055 | (37.7808373486479, -122.496539369055) | 11 | 6 | 2 | 55 | 26 | |
182735 | 63191 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.00663 | 2112603.98729 | 37.7798871547077 | -122.498625465556 | (37.7798871547077, -122.498625465556) | 11 | 6 | 2 | 55 | 26 |
20135 | 248904 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | 28 | Width 5ft | Permit Number 16599 | 6001658.90013 | 2103489.46423 | 37.7558748868343 | -122.437239147875 | (37.7558748868343, -122.437239147875) | 2 | 4 | 5 | 28862 | 22 | |
53982 | 57695 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | 30 | 6x6 | Permit Number 16599 | 6001771.77462005 | 2103491.48426394 | 37.7558868491952 | -122.436848936392 | (37.7558868491952, -122.436848936392) | 2 | 4 | 5 | 28862 | 22 | |
59385 | 46423 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 179 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | Permit Number 44645 | 5999395.58867085 | 2107159.64271916 | 37.7658233652373 | -122.445330264611 | (37.7658233652373, -122.445330264611) | 15 | 5 | 5 | 29492 | 9 | |||
127875 | 12553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1992 12:00:00 AM | 24 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | 11 | 6 | 1 | 54 | 11 | ||
182506 | 30320 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 867 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.77319432354 | -122.484328404455 | (37.77319432354, -122.484328404455) | 11 | 6 | 2 | 55 | 26 | |||
122589 | 6169 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1075 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 3x3 | 6005763.6544 | 2113429.69831 | 37.7834008746955 | -122.423750304634 | (37.7834008746955, -122.423750304634) | 7 | 9 | 11 | 28858 | 41 | ||
85829 | 87052 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 Euclid Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789 | 37.7838752968943 | -122.454910329525 | (37.7838752968943, -122.454910329525) | 11 | 6 | 1 | 54 | 31 | |||
50543 | 11666 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/1992 12:00:00 AM | 12 | 4X4 | 5991320.9947906 | 2093088.5989831 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | 9 | 8 | 4 | 64 | 40 | ||
95752 | 62433 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.7620875372244 | -122.443034282049 | (37.7620875372244, -122.443034282049) | 15 | 5 | 5 | 28862 | 3 | ||
183413 | 45817 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1168 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44444 | 6015539.10076278 | 2103555.89602939 | 37.7568365560705 | -122.389241112249 | (37.7568365560705, -122.389241112249) | 10 | 3 | 8 | 28856 | 29 | |||
105886 | 33710 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 107 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37778 | 6003699.03578605 | 2108805.33287927 | 37.7705867464666 | -122.430562993164 | (37.7705867464666, -122.430562993164) | 15 | 9 | 11 | 29492 | 10 | |||
156344 | 33715 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 184 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | Permit Number 37783 | 6003401.63659312 | 2108816.63624682 | 37.7706009305559 | -122.431592506668 | (37.7706009305559, -122.431592506668) | 15 | 9 | 11 | 29492 | 10 | ||
2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
29506 | 33680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.7770266994083 | -122.425035932953 | (37.7770266994083, -122.425035932953) | 7 | 9 | 11 | 28852 | 10 | ||
84823 | 33683 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
113345 | 33684 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
177146 | 33677 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 455 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.425602743023 | (37.776954366261, -122.425602743023) | 7 | 9 | 11 | 28852 | 10 | |||
190002 | 33685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
150996 | 2048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701X Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/27/2000 12:00:00 AM | 3 | 3X3 | 6001958.68142 | 2095417.21372 | 37.7337274221844 | -122.435624928664 | (37.7337274221844, -122.435624928664) | 9 | 7 | 5 | 63 | 40 | ||
152374 | 33561 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 270 PROSPECT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37668 | 6006489 | 2098160 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | 2 | 7 | 7 | 28859 | 2 | |||
10872 | 33492 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | 2 | 7 | 7 | 28859 | 2 | ||
18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 2 | 7 | 7 | 28859 | 2 | ||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
33171 | 33502 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.7432705917121 | -122.419902509091 | (37.7432705917121, -122.419902509091) | 2 | 7 | 7 | 28859 | 2 | ||
43222 | 33511 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.418698838359 | (37.7454365257217, -122.418698838359) | 2 | 7 | 7 | 28859 | 2 | |||
47971 | 33532 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 179 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | 16 | 5x5 | Permit Number 37642 | 6007307.15222384 | 2097996.82035732 | 37.7411127900368 | -122.417316380484 | (37.7411127900368, -122.417316380484) | 2 | 7 | 7 | 28859 | 2 | |
54221 | 33464 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 52 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37617 | 6006854.98101405 | 2099423.3660818 | 37.7450043146116 | -122.418980984578 | (37.7450043146116, -122.418980984578) | 2 | 7 | 7 | 28859 | 2 | ||
67088 | 33493 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | 2 | 7 | 7 | 28859 | 2 | ||
82080 | 33466 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 60 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37619 | 6006826.41498367 | 2099370.6210257 | 37.7448578799465 | -122.419076020466 | (37.7448578799465, -122.419076020466) | 2 | 7 | 7 | 28859 | 2 | ||
82202 | 33528 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 183 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37638 | 6007285.94975907 | 2097957.3067179 | 37.7410031014535 | -122.417386891564 | (37.7410031014535, -122.417386891564) | 2 | 7 | 7 | 28859 | 2 | ||
121374 | 33515 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37620 | 6006865.28384578 | 2099333.19830806 | 37.7447573143397 | -122.418938965199 | (37.7447573143397, -122.418938965199) | 2 | 7 | 7 | 28859 | 2 | |||
132902 | 33489 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 41 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37615 | 6006958.13481375 | 2099504.24101761 | 37.7452321871095 | -122.41863003057 | (37.7452321871095, -122.41863003057) | 2 | 7 | 7 | 28859 | 2 | |||
136578 | 33523 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 180 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37633 | 6007234.13744004 | 2097970.72636993 | 37.7410370335385 | -122.417566990918 | (37.7410370335385, -122.417566990918) | 2 | 7 | 7 | 28859 | 2 | |||
148674 | 33531 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 177 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37641 | 6007317.75345238 | 2098016.57716988 | 37.741167634292 | -122.417281124878 | (37.741167634292, -122.417281124878) | 2 | 7 | 7 | 28859 | 2 | ||
159403 | 33503 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 161 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | 3x3 | Permit Number 37597 | 6006560.16848411 | 2098769.04119675 | 37.7431910803563 | -122.41995397132 | (37.7431910803563, -122.41995397132) | 2 | 7 | 7 | 28859 | 2 | |
169169 | 33542 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 BOCANA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007149 | 2097726 | 37.7403602783661 | -122.417844022689 | (37.7403602783661, -122.417844022689) | 2 | 7 | 7 | 28859 | 2 | |||
179716 | 33536 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 187 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37646 | 6007264.74730199 | 2097917.79309279 | 37.7408934128659 | -122.417457402411 | (37.7408934128659, -122.417457402411) | 2 | 7 | 7 | 28859 | 2 | |||
53453 | 52252 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 237 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | Permit Number 48419 | 6006717.04487845 | 2104738.84078637 | 37.7595916236736 | -122.419835049965 | (37.7595916236736, -122.419835049965) | 2 | 4 | 7 | 28859 | 19 | |||
24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
121795 | 50567 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
158590 | 50572 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
37225 | 41146 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1534 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41879 | 5998316.1437305 | 2108281.00611102 | 37.7688406669583 | -122.449144612222 | (37.7688406669583, -122.449144612222) | 15 | 5 | 11 | 29492 | 9 | ||
86541 | 57655 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 101 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1976 12:00:00 AM | 20 | 6x8 | Permit Number 16555 | 6006226.5518322 | 2097569.54766444 | 37.7398787392856 | -122.421022382943 | (37.7398787392856, -122.421022382943) | 2 | 7 | 7 | 28859 | 2 | |
95798 | 19460 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1700X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 11/13/2007 12:00:00 AM | 3 | 20 | 5985858.9484667 | 2095882.6709765 | 37.7340778499573 | -122.491319932369 | (37.7340778499573, -122.491319932369) | 1 | 8 | 3 | 64 | 35 | ||
104513 | 19428 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1200X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11/13/2007 12:00:00 AM | 3 | 20 | 5987947.5018995 | 2095985.7700738 | 37.7344827526385 | -122.484106799366 | (37.7344827526385, -122.484106799366) | 1 | 8 | 3 | 64 | 35 | ||
133551 | 19423 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 880X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11/13/2007 12:00:00 AM | 3 | 20 | 5988998.1028282 | 2096024.0271709 | 37.7346489082814 | -122.480477366023 | (37.7346489082814, -122.480477366023) | 1 | 8 | 3 | 64 | 35 | ||
144405 | 92861 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2245 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2009 12:00:00 AM | 11 | 3x3 | 6006750.86672 | 2118980.24307 | 37.7986969721415 | -122.420729101491 | (37.7986969721415, -122.420729101491) | 13 | 9 | 10 | 28858 | 32 | ||
30283 | 94848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |
48458 | 16693 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X NORIEGA ST | 4 | Median : Cutout | Tree | DPW 1 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991142.4 | 2103205.1 | 37.7544906639436 | -122.473587529216 | (37.7544906639436, -122.473587529216) | 1 | 8 | 4 | 56 | 12 | ||
77824 | 16690 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | 1 | 8 | 4 | 56 | 12 | ||
45933 | 33219 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
68568 | 33184 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 585 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.7439977822914 | -122.463243935185 | (37.7439977822914, -122.463243935185) | 1 | 8 | 4 | 59 | 40 | ||
82317 | 206370 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37411 | 5995131.60036 | 2099773.99475 | 37.7452999315413 | -122.45954343988 | (37.7452999315413, -122.45954343988) | 1 | 8 | 4 | 59 | 40 | |
126326 | 33217 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
129877 | 33185 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 585 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.7439977822914 | -122.463243935185 | (37.7439977822914, -122.463243935185) | 1 | 8 | 4 | 59 | 40 | ||
136387 | 33218 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
150835 | 206374 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/06/1996 12:00:00 AM | 16 | Width 3ft | Permit Number 37411 | 5995150.27092 | 2099717.15619 | 37.7451449406021 | -122.459474764954 | (37.7451449406021, -122.459474764954) | 1 | 8 | 4 | 59 | 40 | |
161760 | 33216 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
80097 | 53212 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 132 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | 7 | 9 | 5 | 28862 | 3 | |||
58279 | 44162 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 853 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 43636 | 6002495.49530521 | 2109506.13705466 | 37.7724427273552 | -122.434776169901 | (37.7724427273552, -122.434776169901) | 15 | 5 | 11 | 29492 | 9 | ||
87222 | 32939 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.7612262595052 | -122.39674381647 | (37.7612262595052, -122.39674381647) | 10 | 3 | 8 | 28856 | 29 | |
141117 | 32978 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.28183 | 37.759262335301 | -122.393399153246 | (37.759262335301, -122.393399153246) | 10 | 3 | 8 | 28856 | 29 | |
136155 | 38838 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40667 | 5994882.83677024 | 2114872.91229278 | 37.7867433187024 | -122.461498056095 | (37.7867433187024, -122.461498056095) | 11 | 6 | 1 | 54 | 11 | ||
57864 | 99459 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |
97346 | 99476 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
74962 | 5084 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2567 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1994 12:00:00 AM | 12 | 3X3 | 6002282.63151 | 2096922.4202 | 37.7378787673769 | -122.434612531259 | (37.7378787673769, -122.434612531259) | 2 | 7 | 5 | 63 | 7 | ||
44167 | 141431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.7765854191309 | -122.424815713066 | (37.7765854191309, -122.424815713066) | 7 | 9 | 11 | 28852 | 10 | |
79926 | 52113 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.424658112662 | (37.7765968250138, -122.424658112662) | 7 | 9 | 11 | 28852 | 10 | |
108047 | 57553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 18 | 3x3 | Permit Number 16416 | 6004949.77312 | 2110889.41028 | 37.7763798917414 | -122.426385087108 | (37.7763798917414, -122.426385087108) | 7 | 9 | 11 | 28852 | 10 | |
179000 | 55340 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | Permit Number 769406 | 5992478.56101588 | 2104770.1953725 | 37.7588652973721 | -122.469080674313 | (37.7588652973721, -122.469080674313) | 1 | 8 | 4 | 56 | 12 | |||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
36447 | 57112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 3x3 | Permit Number 14382 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||
111727 | 245879 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 20 | Width 0ft | Permit Number 14382 | 6001380 | 2109122 | 37.7713245889133 | -122.438607239112 | (37.7713245889133, -122.438607239112) | 15 | 5 | 11 | 29492 | 9 | |
163450 | 57140 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3224 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 22 | 4x4 | Permit Number 14415 | 6007386 | 2102705 | 37.7540448270925 | -122.417377329228 | (37.7540448270925, -122.417377329228) | 2 | 4 | 7 | 28859 | 19 | |
174457 | 57060 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1969 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 23 | Permit Number 14324 | 6000588.88106555 | 2112021.36574223 | 37.7792404783104 | -122.441551843076 | (37.7792404783104, -122.441551843076) | 15 | 5 | 11 | 29490 | 41 | ||
94218 | 50448 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 303on BOCANA Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47095 | 6006949.39342482 | 2097361.11055858 | 37.7393471377686 | -122.418508317181 | (37.7393471377686, -122.418508317181) | 2 | 7 | 7 | 28859 | 2 | |||
57366 | 57042 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 14305. Tree 1 on Page St | 5999842.06289616 | 2109172.2578569 | 37.7713749769665 | -122.443930626832 | (37.7713749769665, -122.443930626832) | 15 | 5 | 11 | 29492 | 9 | |||
4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
29446 | 50634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
102301 | 50635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
118360 | 50633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997211 | -122.393359654849 | (37.721936997211, -122.393359654849) | 10 | 3 | 8 | 58 | 1 | |
153999 | 67625 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1281 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 16 | Permit Number 31211 | 6007384.19721 | 2118457.03367 | 37.7972960451262 | -122.418500450146 | (37.7972960451262, -122.418500450146) | 5 | 1 | 10 | 28858 | 32 | |
31243 | 212222 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10/13/2014 11:02:00 AM | 16 | 6000900.61271 | 2095850.79313 | 37.7348577764545 | -122.439314043907 | (37.7348577764545, -122.439314043907) | 2 | 7 | 5 | 63 | 7 | |||
161476 | 85112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4201 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198 | 2102882 | 37.7541807256906 | -122.438789558922 | (37.7541807256906, -122.438789558922) | 2 | 4 | 5 | 28862 | 22 | |||
171436 | 65393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | 5 | 1 | 10 | 28857 | 21 | ||
149432 | 53401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.49513 | 37.7741818356132 | -122.476707321825 | (37.7741818356132, -122.476707321825) | 11 | 6 | 2 | 55 | 26 | ||
17411 | 12539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2019 12:00:00 AM | 3 | 3x3 | 5994802.33005 | 2114932.67469 | 37.7869027759417 | -122.461780923147 | (37.7869027759417, -122.461780923147) | 11 | 6 | 1 | 54 | 11 | ||
88292 | 53058 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 235@ FOLSOM Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.7902200672067 | -122.392792095849 | (37.7902200672067, -122.392792095849) | 6 | 2 | 9 | 28855 | 6 | |||
124291 | 53057 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 235@ FOLSOM Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.7902200672067 | -122.392792095849 | (37.7902200672067, -122.392792095849) | 6 | 2 | 9 | 28855 | 6 | |||
185288 | 64666 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1988 12:00:00 AM | 20 | Permit Number 25599 | 6000212.56039 | 2118841.15322 | 37.7979443906796 | -122.443343666786 | (37.7979443906796, -122.443343666786) | 13 | 9 | 1 | 57 | 17 | ||
72747 | 68295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.60478 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | 11 | 6 | 1 | 54 | 33 | |
148936 | 68216 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 371 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 13 | 4x4 | Permit Number 32003 | 5991199.85508 | 2112923.89297 | 37.7811791800837 | -122.474097911754 | (37.7811791800837, -122.474097911754) | 11 | 6 | 2 | 54 | 26 |
29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
36198 | 39935 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770539 | 6010138.7177 | 2087941.04422 | 37.713660642495 | -122.406817269312 | (37.713660642495, -122.406817269312) | 9 | 7 | 8 | 309 | 39 |
146351 | 71451 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1329 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1982 12:00:00 AM | 14 | 3x3 | 6007730.91514483 | 2101916.84218349 | 37.7519001247372 | -122.416128711613 | (37.7519001247372, -122.416128711613) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );