trees
3,587 rows where qSpecies_id = 28 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35139 | 104434 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
35363 | 51559 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | ||||
35907 | 248657 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 111 | Front Yard : Yard | Tree | Private 2 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | 2 | 7 | 5 | 63 | 7 | ||||
36700 | 176017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 13 | Front Yard : Yard | Tree | Private 2 | 25 | 6009623.16291 | 2089154.94299 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | 9 | 7 | 8 | 309 | 18 | ||||
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 | ||
37240 | 50313 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
37254 | 176052 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989234.20998 | 2089407.11974 | 37.7164942740645 | -122.47917719598 | (37.7164942740645, -122.47917719598) | 1 | 8 | 4 | 64 | 14 | ||||
38380 | 2128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
38558 | 212154 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Miramar Ave | 4 | Median : Yard | Tree | DPW 1 | 5 | 5995400.46902 | 2094347.10151 | 37.7304144726506 | -122.458221033597 | (37.7304144726506, -122.458221033597) | 9 | 7 | 4 | 28861 | 40 | ||||
39739 | 176040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989182.35151 | 2090508.47222 | 37.7195153009692 | -122.479436972335 | (37.7195153009692, -122.479436972335) | 1 | 8 | 4 | 64 | 14 | ||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
39845 | 49157 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46278 | 6004391.65758992 | 2101053.62273947 | 37.7493416035982 | -122.4276148431 | (37.7493416035982, -122.4276148431) | 2 | 4 | 5 | 28862 | 22 | |||
39880 | 212135 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 4 | 5995377.61196 | 2093148.71744 | 37.7271226859638 | -122.458213351562 | (37.7271226859638, -122.458213351562) | 9 | 7 | 4 | 28861 | 40 | ||||
41861 | 30494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 245 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.7361996769017 | -122.431810162156 | (37.7361996769017, -122.431810162156) | 2 | 7 | 5 | 63 | 7 | |||
42309 | 24332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | 7 | 9 | 11 | 28852 | 41 | |||
42878 | 212147 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 2 | 5995390.97132 | 2094022.65308 | 37.7295230700261 | -122.458230394627 | (37.7295230700261, -122.458230394627) | 9 | 7 | 4 | 28861 | 40 | ||||
43053 | 41636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.435635422279 | (37.7704201835081, -122.435635422279) | 15 | 5 | 5 | 29492 | 9 | |||
43094 | 50445 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.444846630775 | (37.7713018555978, -122.444846630775) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
43481 | 107218 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.473576991848 | (37.7269912477326, -122.473576991848) | 9 | 8 | 4 | 64 | 40 | ||||
43802 | 57383 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1038 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 20 | Permit Number 16222 | 6008178.63757 | 2116060.00557 | 37.790759089023 | -122.415581676167 | (37.790759089023, -122.415581676167) | 5 | 1 | 10 | 28858 | 21 | ||
43941 | 46350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 12 | Permit Number 44594 | 6011800.91872 | 2117592.16753 | 37.7951689839044 | -122.403156514164 | (37.7951689839044, -122.403156514164) | 3 | 1 | 10 | 28860 | 4 | ||
44019 | 249723 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 7 | Front Yard : Yard | Tree | Private 2 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) | 13 | 9 | 1 | 57 | 27 | ||||
44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
44230 | 49370 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.7353206035412 | -122.471425664133 | (37.7353206035412, -122.471425664133) | 1 | 8 | 4 | 29491 | 40 | |||
44776 | 212130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 7 | Median : Yard | Tree | DPW 1 | 5 | 5995375.50202 | 2092861.84028 | 37.7263348690517 | -122.458199891406 | (37.7263348690517, -122.458199891406) | 9 | 7 | 4 | 28861 | 40 | ||||
44949 | 100027 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
45308 | 212203 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6001598.82808 | 2095593.88337 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
46853 | 251245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.7344536174122 | -122.433896153002 | (37.7344536174122, -122.433896153002) | 2 | 7 | 5 | 63 | 7 | ||||
47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
47807 | 212150 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 4 | 5995395.95716 | 2094183.25498 | 37.7299643304883 | -122.45822477747 | (37.7299643304883, -122.45822477747) | 9 | 7 | 4 | 28861 | 40 | ||||
48096 | 99968 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
48657 | 212189 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002068.07736 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | 2 | 7 | 5 | 63 | 7 | ||||
48762 | 34585 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 19 | Permit Number 38286 | 5999325.9998 | 2116419.19935 | 37.7912437525454 | -122.446237095163 | (37.7912437525454, -122.446237095163) | 13 | 6 | 1 | 29490 | 31 | ||
49715 | 54763 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 158 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 18 | Permit Number 10612 | 6012922.81222 | 2087247.37446 | 37.7119113504878 | -122.397145753168 | (37.7119113504878, -122.397145753168) | 10 | 3 | 8 | 309 | 1 | ||
49940 | 212149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700x Miramar Ave | 4 | Median : Yard | Tree | DPW 1 | 2 | 5995397.3757 | 2094149.66806 | 37.7298721904459 | -122.458217443476 | (37.7298721904459, -122.458217443476) | 9 | 7 | 4 | 28861 | 40 | ||||
50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
50994 | 212191 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002043.86502 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | 2 | 7 | 5 | 63 | 7 | ||||
51467 | 248648 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2x Lyell St | 2 | Median : Yard | Tree | DPW 1 | 18 | 6002994.42779 | 2095088.08837 | 37.7328824938235 | -122.432020555603 | (37.7328824938235, -122.432020555603) | 9 | 7 | 5 | 28861 | 25 | ||||
51496 | 212178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 610 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6002338.16376 | 2095402.39755 | 37.7337082872919 | -122.434311888799 | (37.7337082872919, -122.434311888799) | 2 | 7 | 5 | 63 | 7 | ||||
52388 | 99208 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
52760 | 94439 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998670 | 2105688 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | 15 | 5 | 11 | 29492 | 9 | |||||
53056 | 46349 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 15 | Permit Number 44594 | 6011797.44129 | 2117605.10565 | 37.7952043146792 | -122.403169457224 | (37.7952043146792, -122.403169457224) | 3 | 1 | 10 | 28860 | 4 | ||
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 | |||
53489 | 107162 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 798X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993812 | 2110401 | 37.7744029620428 | -122.464877983618 | (37.7744029620428, -122.464877983618) | 11 | 6 | 2 | 54 | 11 | |||||
53491 | 2119 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
54553 | 212136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 9 | Median : Yard | Tree | DPW 1 | 4 | 5995379.948 | 2093237.13475 | 37.7273655928402 | -122.458211672546 | (37.7273655928402, -122.458211672546) | 9 | 7 | 4 | 28861 | 40 | ||||
54643 | 258523 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
54735 | 176050 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989206.75613 | 2089405.10082 | 37.7164871361381 | -122.47927194137 | (37.7164871361381, -122.47927194137) | 1 | 8 | 4 | 64 | 14 | ||||
55940 | 38221 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | 9 | 8 | 6 | 64 | 24 | |||
56270 | 212197 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 820 Bosworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6001769.12489 | 2095547.72558 | 37.7340750092381 | -122.436289617596 | (37.7340750092381, -122.436289617596) | 2 | 7 | 5 | 63 | 7 | ||||
56701 | 248645 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701 Church St | 43 | Front Yard : Yard | Tree | Private 2 | 26 | 6004348.66213 | 2104681.30747 | 37.7592999422487 | -122.428022000737 | (37.7592999422487, -122.428022000737) | 2 | 4 | 5 | 28862 | 3 | ||||
56824 | 249742 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 26 | Front Yard : Yard | Tree | Private 2 | 15 | 6000223.59296 | 2117195.73646 | 37.7934271400971 | -122.443187253112 | (37.7934271400971, -122.443187253112) | 13 | 9 | 1 | 57 | 27 | ||||
56876 | 51669 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.7349724722871 | -122.436305690211 | (37.7349724722871, -122.436305690211) | 2 | 7 | 5 | 63 | 7 | |||
57214 | 212140 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 602x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 7 | 5995385.57791 | 2093583.78482 | 37.7283177338747 | -122.458217288803 | (37.7283177338747, -122.458217288803) | 9 | 7 | 4 | 28861 | 40 | ||||
57271 | 100029 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
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 | |||
57462 | 176018 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 12 | Front Yard : Yard | Tree | Private 2 | 13 | 6009605.36223 | 2089158.99044 | 37.7169750147514 | -122.40874661906 | (37.7169750147514, -122.40874661906) | 9 | 7 | 8 | 309 | 18 | ||||
57649 | 212123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 5 | 5995365.84941 | 2092284.31295 | 37.7247485629694 | -122.458191479165 | (37.7247485629694, -122.458191479165) | 9 | 7 | 4 | 28861 | 40 | ||||
57866 | 47600 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
58195 | 176054 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989245.31981 | 2089315.24778 | 37.7162426617475 | -122.479132078791 | (37.7162426617475, -122.479132078791) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||
58684 | 111272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 8 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
59195 | 93735 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
59739 | 201542 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 6020585.50312 | 2093400.19609 | 37.7292294638519 | -122.371086248457 | (37.7292294638519, -122.371086248457) | 10 | 3 | 8 | 58 | 1 | ||||
59837 | 212240 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 298 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998225.68329 | 2093821.95796 | 37.7291344900407 | -122.448416107518 | (37.7291344900407, -122.448416107518) | 9 | 7 | 4 | 28861 | 40 | ||||
60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
60437 | 212145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 650x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 3 | 5995391.25206 | 2093803.15728 | 37.7289204037391 | -122.458213544026 | (37.7289204037391, -122.458213544026) | 9 | 7 | 4 | 28861 | 40 | ||||
60561 | 201722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Lindsay Cir | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6016307.52162 | 2095597.12385 | 37.7350259766618 | -122.386028821491 | (37.7350259766618, -122.386028821491) | 10 | 3 | 8 | 58 | 1 | ||||
60809 | 100009 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
60934 | 258521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
61486 | 67390 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 21 | Permit Number 30887 | 6013339.22791 | 2116980.96183 | 37.7935765453846 | -122.397790795502 | (37.7935765453846, -122.397790795502) | 4 | 1 | 10 | 28860 | 6 | ||
61509 | 212202 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6001677.26505 | 2095571.45354 | 37.734134940976 | -122.436608902975 | (37.734134940976, -122.436608902975) | 2 | 7 | 5 | 63 | 7 | ||||
61941 | 54995 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 692 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 13 | Permit Number 10873 | 5991003.86193 | 2110730.86063 | 37.7751463606227 | -122.474615842608 | (37.7751463606227, -122.474615842608) | 11 | 6 | 2 | 54 | 26 | ||
62048 | 212127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 7 | 5995366.60081 | 2092506.27853 | 37.7253580704006 | -122.458204939327 | (37.7253580704006, -122.458204939327) | 9 | 7 | 4 | 28861 | 40 | ||||
62274 | 258513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
62295 | 106457 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011546 | 2121132 | 37.8048742648975 | -122.404287845465 | (37.8048742648975, -122.404287845465) | 3 | 1 | 10 | 28860 | 6 | |||||
63627 | 104944 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
63771 | 248654 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.424913285419 | (37.7383130275105, -122.424913285419) | 2 | 7 | 5 | 28859 | 7 | ||||
64138 | 99494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 1 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
64576 | 104958 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
66095 | 104946 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
66269 | 99611 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||||
66477 | 247575 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 350x Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 25 | 6008404.3383 | 2095155.19461 | 37.7333719741436 | -122.413321789588 | (37.7333719741436, -122.413321789588) | 9 | 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 | ||
67404 | 59113 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 672 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 23 | Permit Number 18417 | 5993196.84936 | 2110897.84489 | 37.7757316778167 | -122.467042017098 | (37.7757316778167, -122.467042017098) | 11 | 6 | 2 | 54 | 11 | ||
67710 | 249480 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 18 | 6006341.46577 | 2115150.70304 | 37.7881589304427 | -122.421873590397 | (37.7881589304427, -122.421873590397) | 13 | 9 | 1 | 28858 | 21 | ||||
67808 | 54126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.19326 | 37.7103848043898 | -122.399454574563 | (37.7103848043898, -122.399454574563) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||
68726 | 176047 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5988958.7133 | 2089588.42281 | 37.7169760831658 | -122.480142699133 | (37.7169760831658, -122.480142699133) | 1 | 8 | 4 | 64 | 14 | ||||
68870 | 95969 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5600 Geary Blvd | 4 | Median : | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 2 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | 11 | 6 | 2 | 55 | 26 | |||
69083 | 95961 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.7806931223902 | -122.475618082454 | (37.7806931223902, -122.475618082454) | 11 | 6 | 2 | 54 | 26 | ||||
69228 | 102411 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
69323 | 212131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 8 | Median : Yard | Tree | DPW 1 | 34 | 5995375.28934 | 2092898.1948 | 37.7264346776031 | -122.458203256672 | (37.7264346776031, -122.458203256672) | 9 | 7 | 4 | 28861 | 40 | ||||
69678 | 212092 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1485x Northwood Dr | 8 | Median : Yard | Tree | DPW 1 | 31 | 5995863.34016 | 2094047.68745 | 37.7296189404529 | -122.456599188129 | (37.7296189404529, -122.456599188129) | 9 | 7 | 4 | 28861 | 40 | ||||
69845 | 54653 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 274 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 16 | Permit Number 10477 | 6012392.2248 | 2087295.07392 | 37.7120127715543 | -122.398982970103 | (37.7120127715543, -122.398982970103) | 10 | 3 | 8 | 309 | 1 | ||
70393 | 51565 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.7532827184773 | -122.428929306917 | (37.7532827184773, -122.428929306917) | 2 | 4 | 5 | 28862 | 22 |
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) );