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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64722 | 64722 | 129090 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.803924702438394 | -122.404815037597 | (37.8039247024384, -122.404815037597) | |||
| 68617 | 68617 | 228483 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.44363115936198 | (37.751787354827, -122.443631159362) | |||
| 68672 | 68672 | 228487 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.764069559682206 | -122.41325481347401 | (37.7640695596822, -122.413254813474) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 69661 | 69661 | 190652 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 310 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.39852852018299 | (37.7621425904374, -122.398528520183) | |||
| 70029 | 70029 | 129087 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.803946988513104 | -122.40461329806801 | (37.8039469885131, -122.404613298068) | |||
| 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) | |
| 70341 | 70341 | 228445 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 391 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004290.10245 | 2109410.4526299997 | 37.7722817243588 | -122.428561627213 | (37.7722817243588, -122.428561627213) | |||
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 71186 | 71186 | 106356 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | ||
| 71808 | 71808 | 190649 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1164 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014097.05519 | 2105748.35032 | 37.7627765099393 | -122.394381783993 | (37.7627765099393, -122.394381783993) | |||
| 72860 | 72860 | 228438 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003321.74278 | 2109274.9224400003 | 37.7718547433349 | -122.43190158878599 | (37.7718547433349, -122.431901588786) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 73706 | 73706 | 120866 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990027.965580001 | 2110538.28947 | 37.774561018937796 | -122.477977567474 | (37.7745610189378, -122.477977567474) | |||
| 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) | |
| 74343 | 74343 | 190667 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.39796168649099 | (37.7780121091073, -122.397961686491) | |||
| 74581 | 74581 | 228446 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 379 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 5ft | 6004344.901769999 | 2109415.2001400003 | 37.7722978608825 | -122.428372409862 | (37.7722978608825, -122.428372409862) | |||
| 74585 | 74585 | 228472 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004182.38579 | 2107503.9785 | 37.767040912528294 | -122.428798292811 | (37.7670409125283, -122.428798292811) | |||
| 75156 | 75156 | 35578 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1001 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38947 | 6006352.71975705 | 2103759.98649975 | 37.7568833861691 | -122.421025568698 | (37.7568833861691, -122.421025568698) | ||
| 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) | ||
| 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) | ||
| 80126 | 80126 | 91203 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2009 12:00:00 AM | 3 | 6003365.215480001 | 2109356.0742599997 | 37.772080030656 | -122.43175700892999 | (37.772080030656, -122.43175700893) | |||
| 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) | |||
| 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) | ||
| 82415 | 82415 | 49456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 82897 | 82897 | 15297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1625 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1995 12:00:00 AM | 0 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | ||
| 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) | ||
| 83968 | 83968 | 49189 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | |||
| 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) | ||
| 84617 | 84617 | 106357 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | |||
| 85140 | 85140 | 10309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 629 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2011 12:00:00 AM | 3 | 3X3 | 6003124.536169999 | 2109214.79731 | 37.7716784730152 | -122.43257944422399 | (37.7716784730152, -122.432579444224) | ||
| 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) | ||
| 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) | ||
| 85917 | 85917 | 35327 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.41999915657499 | (37.759397576581, -122.419999156575) | ||
| 86179 | 86179 | 6837 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1475 FAIRFAX AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 6 | 3X3 | 6016157.0 | 2097767.0 | 37.740975685587394 | -122.386700497992 | (37.7409756855874, -122.386700497992) | ||
| 86257 | 86257 | 49459 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 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) | ||
| 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) | ||
| 87775 | 87775 | 66598 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | Permit Number 29791 | 6007978.50985665 | 2115821.60445069 | 37.79009324672379 | -122.41625721778799 | (37.7900932467238, -122.416257217788) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 89601 | 89601 | 35493 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38903 | 6005339.71347882 | 2104322.52965211 | 37.7583708422124 | -122.42456893980601 | (37.7583708422124, -122.424568939806) | ||
| 89626 | 89626 | 91193 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 402 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | 3x3 | 6004165.42779 | 2109456.3421 | 37.772400669344705 | -122.428996160396 | (37.7724006693447, -122.428996160396) | ||
| 89783 | 89783 | 91200 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 482 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003865.9067400005 | 2109457.56257 | 37.7723870617714 | -122.43003231905001 | (37.7723870617714, -122.43003231905) | ||
| 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) | ||
| 90363 | 90363 | 105778 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 BRADY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | |
| 90692 | 90692 | 6807 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1395 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 91795 | 91795 | 6840 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1469 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016172.0 | 2097718.0 | 37.740841972016504 | -122.386645216998 | (37.7408419720165, -122.386645216998) | ||
| 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) | ||
| 93737 | 93737 | 91220 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6004167.50456 | 2109371.06405 | 37.7721666341778 | -122.428982895538 | (37.7721666341778, -122.428982895538) | ||
| 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) | ||
| 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) | ||
| 94980 | 94980 | 49194 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 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) | ||
| 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) | ||
| 96195 | 96195 | 122809 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 99299 | 99299 | 91209 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004404.0966 | 2109354.51914 | 37.7721345950401 | -122.428163324287 | (37.7721345950401, -122.428163324287) | ||
| 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) | ||
| 100253 | 100253 | 91223 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 577 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6003385.59355 | 2109287.85508 | 37.7718938726453 | -122.431681648151 | (37.7718938726453, -122.431681648151) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 101599 | 101599 | 91194 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | 3x3 | 6004119.82913 | 2109461.1016 | 37.7724111565911 | -122.42915422991999 | (37.7724111565911, -122.42915422992) | ||
| 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) | |
| 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) | ||
| 102751 | 102751 | 93183 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | 6004447.0 | 2109433.0 | 37.7723525117512 | -122.428020511442 | (37.7723525117512, -122.428020511442) | ||
| 104221 | 104221 | 6822 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 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) | ||
| 104856 | 104856 | 10264 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 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) | ||
| 105139 | 105139 | 91222 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 6003354.82967 | 2109257.95569 | 37.7718100324239 | -122.43178592736099 | (37.7718100324239, -122.431785927361) | |||
| 105341 | 105341 | 122811 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 105727 | 105727 | 15296 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1625 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 106928 | 106928 | 108370 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 823 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774572 | 5995757.2341599995 | 2113775.59974 | 37.783780682228 | -122.458393411251 | (37.783780682228, -122.458393411251) | |
| 107014 | 107014 | 49199 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 107229 | 107229 | 6843 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2007 12:00:00 AM | 6 | 3X3 | 6016186.0 | 2097583.0 | 37.7404720645711 | -122.38658739858299 | (37.7404720645711, -122.386587398583) | ||
| 107889 | 107889 | 62925 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776406 | 6007643.77781077 | 2096549.63091103 | 37.7371580604569 | -122.416049984435 | (37.7371580604569, -122.416049984435) | |
| 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) | ||
| 108343 | 108343 | 91208 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 379 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2011 12:00:00 AM | 3 | 3x3 | 6004350.8664 | 2109396.5846700002 | 37.772247084848 | -122.42835045064699 | (37.772247084848, -122.428350450647) | ||
| 109938 | 109938 | 49193 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 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) | ||
| 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) | ||
| 111515 | 111515 | 49197 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 113150 | 113150 | 49190 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 113346 | 113346 | 106355 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) |
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");