Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6135 | 6135 | 48746 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6959 | 6959 | 48747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7180 | 7180 | 48749 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 8095 | 8095 | 50823 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 8773 | 8773 | 48750 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 8939 | 8939 | 48748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 9025 | 9025 | 48744 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 10143 | 10143 | 58653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.45276901450501 | (37.7650453439116, -122.452769014505) | ||
| 10338 | 10338 | 30354 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1956 12:00:00 AM | Permit Number 43 | |||||||||
| 13566 | 13566 | 48742 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 18367 | 18367 | 99991 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 19062 | 19062 | 50066 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | ||
| 30547 | 30547 | 54566 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | ||
| 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) | ||
| 66741 | 66741 | 50805 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | |||
| 72582 | 72582 | 34885 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.804807956300394 | -122.43437403696699 | (37.8048079563004, -122.434374036967) | ||||
| 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) | ||
| 77327 | 77327 | 33952 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
| 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) | |||
| 77484 | 77484 | 97635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008163.0 | 2117572.0 | 37.794909774633105 | -122.415742887246 | (37.7949097746331, -122.415742887246) | |||||
| 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) | ||
| 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) | ||
| 77978 | 77978 | 50685 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.765470983210896 | -122.44610545370399 | (37.7654709832109, -122.446105453704) | ||||
| 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) | |||
| 78069 | 78069 | 51559 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | ||||
| 78254 | 78254 | 100023 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 78428 | 78428 | 103592 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||||
| 78495 | 78495 | 121113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 78551 | 78551 | 38221 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595002 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | |||
| 78924 | 78924 | 41636 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.43563542227899 | (37.7704201835081, -122.435635422279) | |||
| 79856 | 79856 | 51669 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.734972472287104 | -122.43630569021099 | (37.7349724722871, -122.436305690211) | |||
| 79986 | 79986 | 49370 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.735320603541204 | -122.471425664133 | (37.7353206035412, -122.471425664133) | |||
| 80226 | 80226 | 99208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | ||||
| 80381 | 80381 | 100004 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 80480 | 80480 | 100029 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 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) | |||
| 80978 | 80978 | 94439 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | |||||
| 80983 | 80983 | 50445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.44484663077499 | (37.7713018555978, -122.444846630775) | ||||
| 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) | |||
| 81041 | 81041 | 49157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2003 12:00:00 AM | Permit Number 46278 | 6004391.65758992 | 2101053.62273947 | 37.749341603598204 | -122.42761484309999 | (37.7493416035982, -122.4276148431) | |||
| 81062 | 81062 | 30494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 245 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.736199676901705 | -122.431810162156 | (37.7361996769017, -122.431810162156) | |||
| 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) | ||
| 82373 | 82373 | 121115 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 82664 | 82664 | 94440 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | ||||
| 83274 | 83274 | 99496 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
| 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) | ||
| 83492 | 83492 | 100027 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 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) | |||
| 84191 | 84191 | 101134 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||||
| 84602 | 84602 | 47600 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 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) | ||
| 86305 | 86305 | 103594 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||||
| 87006 | 87006 | 102864 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2750X Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7.5 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | ||||
| 87404 | 87404 | 99494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
| 87458 | 87458 | 99996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 87578 | 87578 | 51565 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.753282718477294 | -122.428929306917 | (37.7532827184773, -122.428929306917) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 89145 | 89145 | 50979 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 89444 | 89444 | 120946 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3224 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6007386.0 | 2102705.0 | 37.7540448270925 | -122.417377329228 | (37.7540448270925, -122.417377329228) | ||||
| 89535 | 89535 | 112306 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | ||||
| 89684 | 89684 | 60589 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 538 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 20207 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | ||
| 89897 | 89897 | 100020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 90001 | 90001 | 100009 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 90186 | 90186 | 121100 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | ||||
| 90746 | 90746 | 121116 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 90853 | 90853 | 58013 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3531 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1977 12:00:00 AM | 10x5 | Permit Number 16980 | 6005344.55719622 | 2106027.69514764 | 37.76305309818179 | -122.424673487617 | (37.7630530981818, -122.424673487617) | ||
| 91050 | 91050 | 97402 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 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) | |||
| 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) | ||
| 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) | |||
| 92184 | 92184 | 94438 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | ||||
| 92591 | 92591 | 100000 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 92719 | 92719 | 99993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 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) | |||
| 93348 | 93348 | 38998 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2180 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | ||
| 94189 | 94189 | 47042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 6x9 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | |
| 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) | |
| 94404 | 94404 | 67891 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 737 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | Permit Number 31591 | 5999915.87653863 | 2107957.83758922 | 37.768044694701096 | -122.443588048997 | (37.7680446947011, -122.443588048997) | |||
| 94725 | 94725 | 94441 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | ||||
| 95095 | 95095 | 103597 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Hermann St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||||
| 95177 | 95177 | 112307 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 95969 | 95969 | 121114 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 97178 | 97178 | 102863 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2750X Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | ||||
| 97408 | 97408 | 46076 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 97491 | 97491 | 112305 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | |||
| 97535 | 97535 | 33818 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 746 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37832 | 5997388.75056927 | 2098060.66039763 | 37.7407250625957 | -122.45161506422501 | (37.7407250625957, -122.451615064225) | |||
| 98128 | 98128 | 50878 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47388 | 6002262.04828144 | 2097251.96755917 | 37.7387824596371 | -122.43470725599501 | (37.7387824596371, -122.434707255995) | ||||
| 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) | ||
| 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) | |||
| 98716 | 98716 | 121098 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) |
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");