Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140076 | 140076 | 49200 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 3x3 | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |
| 6152 | 6152 | 34989 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2447 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38568 | 6002987.46694 | 2116484.72723 | 37.7916321004801 | -122.433573216253 | (37.7916321004801, -122.433573216253) | ||
| 113551 | 113551 | 39284 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142789 | 142789 | 39301 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 13712 | 13712 | 6809 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.9784699995 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | ||
| 81436 | 81436 | 6830 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 83488 | 83488 | 6826 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 124744 | 124744 | 6820 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 127073 | 127073 | 6827 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 128886 | 128886 | 6821 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 118460 | 118460 | 14967 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 395 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 6016770.717680001 | 2097736.2935200003 | 37.7409253302671 | -122.384576328932 | (37.7409253302671, -122.384576328932) | ||
| 78149 | 78149 | 93301 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 589X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667.0 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | ||
| 78468 | 78468 | 93310 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004202.0 | 2107132.0 | 37.7660206593376 | -122.428703930527 | (37.7660206593376, -122.428703930527) | ||
| 90775 | 90775 | 93305 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 489 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004284.5 | 2106064.7 | 37.7630947783555 | -122.42834250308701 | (37.7630947783555, -122.428342503087) | ||
| 91782 | 91782 | 93313 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 241 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004184.0 | 2107469.0 | 37.766944961369 | -122.428790215647 | (37.766944961369, -122.428790215647) | ||
| 91972 | 91972 | 93314 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004180.0 | 2107540.0 | 37.7671396838414 | -122.42880911313999 | (37.7671396838414, -122.42880911314) | ||
| 100180 | 100180 | 93311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 253 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004187.0 | 2107409.0 | 37.766780385636395 | -122.428775561342 | (37.7667803856364, -122.428775561342) | ||
| 104608 | 104608 | 93312 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004185.0 | 2107449.0 | 37.7668901027922 | -122.428785330871 | (37.7668901027922, -122.428785330871) | ||
| 105119 | 105119 | 93303 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 139363 | 139363 | 93304 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 140879 | 140879 | 93306 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 465 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004251.0 | 2106168.0 | 37.7633765197798 | -122.428465731621 | (37.7633765197798, -122.428465731621) | ||
| 167422 | 167422 | 78131 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2040 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53996 | 6000457.66404 | 2121004.4785 | 37.8038982794373 | -122.442650952296 | (37.8038982794373, -122.442650952296) |
| 120939 | 120939 | 10320 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 758 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1992 12:00:00 AM | 25 | 3X3 | 6002531.73322 | 2109228.96362 | 37.771683734938996 | -122.43463099668699 | (37.771683734939, -122.434630996687) | ||
| 125756 | 125756 | 65015 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 278 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 3 | 2x3 | Permit Number 768137 | 6007725.96636 | 2097829.89859682 | 37.74067801414021 | -122.415856451174 | (37.7406780141402, -122.415856451174) | |
| 2291 | 2291 | 228437 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 6 | Width 3ft | 6004091.19769 | 2108012.29591 | 37.7684314676748 | -122.429149946611 | (37.7684314676748, -122.429149946611) | ||
| 88787 | 88787 | 93236 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004223.0 | 2105723.0 | 37.762153071666496 | -122.428530853207 | (37.7621530716665, -122.428530853207) | ||
| 90135 | 90135 | 93237 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 576 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004202.7 | 2105545.3 | 37.76166400108121 | -122.428588395846 | (37.7616640010812, -122.428588395846) | ||
| 102377 | 102377 | 93232 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004136.0 | 2107205.0 | 37.766217364214604 | -122.42893741621 | (37.7662173642146, -122.42893741621) | ||
| 120948 | 120948 | 93230 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092.0 | 2108018.0 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | ||
| 144149 | 144149 | 93235 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004170.4 | 2105921.7 | 37.7626956775589 | -122.428726941839 | (37.7626956775589, -122.428726941839) | ||
| 145340 | 145340 | 93231 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092.0 | 2108018.0 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | ||
| 44241 | 44241 | 64733 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1988 12:00:00 AM | 8 | Permit Number 25692 | 5994873.94035 | 2114654.72726 | 37.786143729617294 | -122.461513011375 | (37.7861437296173, -122.461513011375) | ||
| 105952 | 105952 | 67708 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Stillman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31319 | 6013961.97114475 | 2112919.16578606 | 37.78245845414779 | -122.395351361788 | (37.7824584541478, -122.395351361788) | ||
| 23175 | 23175 | 25492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.43286102333299 | (37.7717331028377, -122.432861023333) | ||
| 16779 | 16779 | 6759 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.097680001 | 2096971.1659799998 | 37.7388481798969 | -122.38303843809099 | (37.7388481798969, -122.383038438091) | ||
| 91292 | 91292 | 50559 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/2003 12:00:00 AM | Permit Number 47181 | 6003055.27396348 | 2109235.82329281 | 37.7717322771379 | -122.43282052857 | (37.7717322771379, -122.43282052857) | ||
| 100280 | 100280 | 6723 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1200X Fairfax Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 80305 | 80305 | 32927 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1550 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 87419 | 87419 | 32861 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | ||
| 143377 | 143377 | 32828 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.43724693926201 | (37.7511683628484, -122.437246939262) | ||
| 19533 | 19533 | 25491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069334998 | (37.7717244144917, -122.43292069335) | ||
| 113110 | 113110 | 27335 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 12 | 3X3 | 6004279.72317 | 2109472.24988 | 37.7724508171595 | -122.428601935914 | (37.7724508171595, -122.428601935914) | ||
| 139543 | 139543 | 10297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 540 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003554.89128 | 2109371.3672 | 37.7721327712956 | -122.43110199714701 | (37.7721327712956, -122.431101997147) | ||
| 13462 | 13462 | 15276 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1563X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.7778199995 | 2109715.95764 | 37.7732881790271 | -122.41831089463699 | (37.7732881790271, -122.418310894637) | ||
| 91318 | 91318 | 44081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 122875 | 122875 | 44082 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 141850 | 141850 | 27324 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 320 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:31:00 AM | 3 | 4x4 | 6004588.93351 | 2109631.91786 | 37.7729067207461 | -122.42754372417801 | (37.7729067207461, -122.427543724178) | ||
| 114509 | 114509 | 37417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1406 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 39895 | 6001966.85277742 | 2099994.31437339 | 37.746295538854795 | -122.435924071348 | (37.7462955388548, -122.435924071348) | ||
| 70201 | 70201 | 32479 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 81 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 8 | Permit Number 36987 | 6000177.30918 | 2105965.99025 | 37.762590484284395 | -122.44254075744499 | (37.7625904842844, -122.442540757445) | |
| 84002 | 84002 | 32443 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36965 | 6001261.23901245 | 2105800.41566985 | 37.762197583242795 | -122.438779978808 | (37.7621975832428, -122.438779978808) | ||
| 153340 | 153340 | 32442 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 11 | Permit Number 36965 | 6001246.93122 | 2105801.18273 | 37.7621988754027 | -122.43882951888901 | (37.7621988754027, -122.438829518889) | |
| 105905 | 105905 | 29880 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6006057.16025 | 2108040.46288 | 37.76861990192471 | -122.42235185 | (37.7686199019247, -122.42235185) | ||
| 100348 | 100348 | 71197 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3966 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53734 | 6004099.24997097 | 2100745.29337187 | 37.7484784588463 | -122.42860401950001 | (37.7484784588463, -122.4286040195) | |
| 128858 | 128858 | 66456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 144 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2008 12:00:00 AM | 3x3 | Permit Number 51700 | 6009019.86661618 | 2097810.11966481 | 37.7406963622889 | -122.41138122330099 | (37.7406963622889, -122.411381223301) | ||
| 117935 | 117935 | 48637 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | ||
| 138636 | 138636 | 48636 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) |
| 161170 | 161170 | 67435 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2632 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 6 | Permit Number 30937 | 5990433.164530001 | 2112001.81298 | 37.7786029615899 | -122.47668286606199 | (37.7786029615899, -122.476682866062) | |
| 41126 | 41126 | 67427 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1515 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30929 | 5990869.16638 | 2110599.51462 | 37.7747779148712 | -122.475072189476 | (37.7747779148712, -122.475072189476) | |
| 74043 | 74043 | 67428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.774932181016204 | -122.47517347719901 | (37.7749321810162, -122.475173477199) | |
| 156740 | 156740 | 67426 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1502 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30928 | 5990903.71531 | 2110660.74638 | 37.7749480428024 | -122.474957149423 | (37.7749480428024, -122.474957149423) | |
| 167443 | 167443 | 67430 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.774633233377706 | -122.4782759878 | (37.7746332333777, -122.4782759878) | |
| 78873 | 78873 | 94419 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 95770 | 95770 | 94417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 100907 | 100907 | 94418 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 128623 | 128623 | 94420 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 110596 | 110596 | 34537 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 62 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38246 | 6009318.56317763 | 2097091.62254667 | 37.73874027405461 | -122.41029772240299 | (37.7387402740546, -122.410297722403) | ||
| 85659 | 85659 | 43634 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.42172477262301 | (37.7488955027959, -122.421724772623) | ||
| 85155 | 85155 | 1635 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 819 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2014 12:00:00 AM | 3 | 4X4 | 5995645.06873 | 2110681.65476 | 37.775279084646 | -122.458557415767 | (37.775279084646, -122.458557415767) | ||
| 46527 | 46527 | 30692 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52599 | 6005954.788 | 2109697.461 | 37.7731638465829 | -122.42282372387301 | (37.7731638465829, -122.422823723873) | |
| 140495 | 140495 | 30691 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52599 | 6006108.61199537 | 2109713.28983155 | 37.773215986766296 | -122.422292750625 | (37.7732159867663, -122.422292750625) | ||
| 161804 | 161804 | 34455 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1711 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 7 | Permit Number 38199 | 6008299.19736 | 2118343.4802 | 37.7970357237711 | -122.415326264207 | (37.7970357237711, -122.415326264207) | |
| 176976 | 176976 | 34454 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 881 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 14 | Permit Number 38198 | 6008682.269119999 | 2120023.6323700002 | 37.8016705265302 | -122.414119665415 | (37.8016705265302, -122.414119665415) | |
| 38824 | 38824 | 51853 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220261999 | (37.7610732389628, -122.39907220262) | ||
| 21394 | 21394 | 10288 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 447 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6003998.901740001 | 2109366.95645 | 37.77214581071579 | -122.429565813827 | (37.7721458107158, -122.429565813827) | ||
| 112436 | 112436 | 6785 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1360 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
| 36077 | 36077 | 37655 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1521 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40065 | 5990857.78217 | 2110597.46577 | 37.774771629499796 | -122.475111419797 | (37.7747716294998, -122.475111419797) | |
| 87935 | 87935 | 63738 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 614 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1987 12:00:00 AM | Permit Number 24409 | 6003616.13531823 | 2109713.3650038997 | 37.773075283639706 | -122.430914560979 | (37.7730752836397, -122.430914560979) | ||
| 100362 | 100362 | 42081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 254 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42391 | 6008092.42384606 | 2100220.76756697 | 37.7472634047037 | -122.41475853876999 | (37.7472634047037, -122.41475853877) | ||
| 143858 | 143858 | 93234 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 306 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | ||
| 113736 | 113736 | 32823 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 37181 | 6001484.39499205 | 2102303.82093127 | 37.75260947422421 | -122.43775772935 | (37.7526094742242, -122.43775772935) | ||
| 141131 | 141131 | 93307 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 445 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 07:00:00 AM | 3 | 3x3 | 6004245.0 | 2106273.0 | 37.763664485103895 | -122.42849396833701 | (37.7636644851039, -122.428493968337) | ||
| 58955 | 58955 | 37026 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.746789273196796 | -122.429947677166 | (37.7467892731968, -122.429947677166) | ||
| 2982 | 2982 | 244493 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.772325546907794 | -122.42924796682699 | (37.7723255469078, -122.429247966827) | ||
| 95037 | 95037 | 91195 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 422 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 1 | 3x3 | 6004087.9204 | 2109490.98672 | 37.772491407466205 | -122.429266736662 | (37.7724914074662, -122.429266736662) | ||
| 89343 | 89343 | 36994 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39614 | 6009898.14777577 | 2102820.5904951002 | 37.754503234678005 | -122.408697833051 | (37.754503234678, -122.408697833051) | ||
| 16973 | 16973 | 10247 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | ||
| 2952 | 2952 | 244491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.42954388259199 | (37.7722877948852, -122.429543882592) | ||
| 94475 | 94475 | 91197 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003996.812969999 | 2109443.98025 | 37.772357180985 | -122.429578533241 | (37.772357180985, -122.429578533241) | ||
| 106323 | 106323 | 91201 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 542 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003536.88264 | 2109349.2972 | 37.772071151994204 | -122.43116271492399 | (37.7720711519942, -122.431162714924) | ||
| 112069 | 112069 | 93308 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2015 01:54:00 PM | 3 | 3x3 | 6004205.0 | 2107085.0 | 37.7658917784387 | -122.428690203394 | (37.7658917784387, -122.428690203394) | ||
| 101754 | 101754 | 36675 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1815 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 15 | 3x3 | Permit Number 39480 | 6005408.20742805 | 2107215.17723629 | 37.7663172364539 | -122.42453781561001 | (37.7663172364539, -122.42453781561) | |
| 106437 | 106437 | 73597 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 825 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2011 12:00:00 AM | 3x3 | Permit Number 767161 | 6007569.13590268 | 2104853.84433691 | 37.7599553630185 | -122.416896234376 | (37.7599553630185, -122.416896234376) | ||
| 110522 | 110522 | 6249 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1310X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2013 12:00:00 AM | 18 | 4X4 | 6004670.79192 | 2113352.05321 | 37.7831259277051 | -122.42752564758699 | (37.7831259277051, -122.427525647587) | ||
| 3093 | 3093 | 124473 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.774772198948796 | -122.456257787006 | (37.7747721989488, -122.456257787006) | |
| 3016 | 3016 | 244492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | ||
| 94224 | 94224 | 91199 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 460 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6003924.61561 | 2109422.82576 | 37.7722950077597 | -122.429826761418 | (37.7722950077597, -122.429826761418) | ||
| 108051 | 108051 | 91198 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6003949.90821 | 2109426.34577 | 37.7723061050967 | -122.429739523154 | (37.7723061050967, -122.429739523154) | ||
| 91452 | 91452 | 48986 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 372 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46173 | 6004094.60882476 | 2100160.1254271 | 37.7468714608035 | -122.428578362797 | (37.7468714608035, -122.428578362797) | ||
| 87737 | 87737 | 36126 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39222 | 5993608.5123809995 | 2106430.08869154 | 37.76348815576279 | -122.46529338011999 | (37.7634881557628, -122.46529338012) | ||
| 140863 | 140863 | 36113 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.764722731307394 | -122.47182229152901 | (37.7647227313074, -122.471822291529) |
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");