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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6278 | 6278 | 103957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2465 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770692 | 6002902.62076 | 2116470.8664700002 | 37.7915892279996 | -122.433865791789 | (37.7915892279996, -122.433865791789) | |
| 6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
| 6326 | 6326 | 58062 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1732 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 10 | 3x3 | Permit Number 17032 | 5999582.2359 | 2114859.9248 | 37.78697702365571 | -122.44523837241199 | (37.7869770236557, -122.445238372412) | |
| 6329 | 6329 | 18985 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2926 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 3 | 3X3 | 6000546.31871 | 2115537.57863 | 37.7888926683961 | -122.441951530652 | (37.7888926683961, -122.441951530652) | ||
| 6424 | 6424 | 29121 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008434.8728 | 2114228.13336 | 37.7857436131333 | -122.414565426956 | (37.7857436131333, -122.414565426956) | ||
| 6663 | 6663 | 17852 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2105 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003811.8281 | 2115238.2923 | 37.7882564446804 | -122.430631953837 | (37.7882564446804, -122.430631953837) | |||
| 6684 | 6684 | 38517 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2150 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1998 12:00:00 AM | 25 | 6x6 | Permit Number 40504 | 5997521.1508 | 2110251.9474 | 37.77420686213429 | -122.45203664156999 | (37.7742068621343, -122.45203664157) |
| 6707 | 6707 | 97136 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000665.32299 | 2116159.50281 | 37.790607091004404 | -122.441584441793 | (37.7906070910044, -122.441584441793) | |
| 6781 | 6781 | 28297 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 886 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2003 12:00:00 AM | 3 | 3X3 | 6003187.6794 | 2110345.6225 | 37.77478702085 | -122.43244181014799 | (37.77478702085, -122.432441810148) | ||
| 6889 | 6889 | 27340 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 646 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004269.3633 | 2110497.2933 | 37.7752647494287 | -122.428710856528 | (37.7752647494287, -122.428710856528) | ||
| 7098 | 7098 | 98592 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2331 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774879 | 6003024.44034 | 2116816.90003 | 37.7925462595429 | -122.43346903696998 | (37.7925462595429, -122.43346903697) | |
| 7196 | 7196 | 53176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 3 | 3x3 | Permit Number 49094 | 5998327.8723 | 2109933.5008 | 37.7733786657012 | -122.449223112808 | (37.7733786657012, -122.449223112808) |
| 7287 | 7287 | 82972 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2808 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775067 | 6000141.37646 | 2117136.25898 | 37.79325914223679 | -122.44346745307199 | (37.7932591422368, -122.443467453072) | |
| 7343 | 7343 | 58834 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1864 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1979 12:00:00 AM | 14 | 3x3 | Permit Number 772490 | 6003989.96335 | 2119411.99542 | 37.7997264575584 | -122.430313528149 | (37.7997264575584, -122.430313528149) | |
| 7381 | 7381 | 50780 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2257 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47307 | 6002153.86522 | 2118764.0547700003 | 37.7978432097613 | -122.436620688605 | (37.7978432097613, -122.436620688605) | |
| 7388 | 7388 | 5226 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1031 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 3 | 3X3 | 6001391.1909 | 2111988.4032 | 37.779195648412 | -122.43877396477501 | (37.779195648412, -122.438773964775) | ||
| 7504 | 7504 | 58099 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 864X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1977 12:00:00 AM | 22 | 4x4 | Permit Number 17073 | 6006749.38738 | 2113618.48291 | 37.7839748265105 | -122.42035345285 | (37.7839748265105, -122.42035345285) | |
| 7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 7600 | 7600 | 2716 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2178 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003083.0342 | 2114847.1509 | 37.7871411551889 | -122.433125499331 | (37.7871411551889, -122.433125499331) | |||
| 7606 | 7606 | 27342 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 658 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004212.4421 | 2110492.9405 | 37.7752495760457 | -122.428907449576 | (37.7752495760457, -122.428907449576) | ||
| 7742 | 7742 | 17849 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2098 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003937.153 | 2115309.199 | 37.7884582356735 | -122.43020341123001 | (37.7884582356735, -122.43020341123) | |||
| 7813 | 7813 | 18956 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2867 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | 6001086.2115 | 2115563.33325 | 37.788994134415496 | -122.440085427516 | (37.7889941344155, -122.440085427516) | ||
| 7835 | 7835 | 103691 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 136 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2013 12:00:00 AM | 2 | 2x4 | Permit Number 768685 | 6002704.424240001 | 2119047.06433 | 37.7986515518927 | -122.434735850806 | (37.7986515518927, -122.434735850806) | |
| 7843 | 7843 | 18977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2912 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000739.52312 | 2115564.90607 | 37.788978710133 | -122.44128503318599 | (37.788978710133, -122.441285033186) | |||
| 7885 | 7885 | 21612 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | |||
| 7977 | 7977 | 121363 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2235 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6003480.6040199995 | 2116883.14161 | 37.792754011941106 | -122.431895428424 | (37.7927540119411, -122.431895428424) | |||
| 8052 | 8052 | 3037 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2611 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6001770.5365 | 2115308.215 | 37.7883325797422 | -122.437699479333 | (37.7883325797422, -122.437699479333) | |||
| 8059 | 8059 | 34906 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 8080 | 8080 | 18902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2599 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002415.46801 | 2115750.47994 | 37.7895835752639 | -122.43549977541599 | (37.7895835752639, -122.435499775416) | |||
| 8101 | 8101 | 18925 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2679 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002005.1865 | 2115691.57373 | 37.7893985235705 | -122.43691508526301 | (37.7893985235705, -122.436915085263) | |||
| 8133 | 8133 | 5227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 4 | 3X3 | 6001390.1765 | 2112022.1316 | 37.779288200344894 | -122.438779891576 | (37.7792882003449, -122.438779891576) | ||
| 8143 | 8143 | 53665 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | Permit Number 6603 | 6006700.2941 | 2116215.7306 | 37.791103462133705 | -122.420707740038 | (37.7911034621337, -122.420707740038) | |||
| 8310 | 8310 | 110965 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x5 | 6003004.00297 | 2116485.50112 | 37.791635163595096 | -122.433516057127 | (37.7916351635951, -122.433516057127) | |||
| 8425 | 8425 | 60186 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1982 12:00:00 AM | 14 | 4x4 | Permit Number 19730 | 6002369.68995 | 2116773.36894 | 37.7923895652649 | -122.435731376003 | (37.7923895652649, -122.435731376003) | |
| 8544 | 8544 | 110463 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000109.08248 | 2117133.8316 | 37.7932506355596 | -122.443579017584 | (37.7932506355596, -122.443579017584) | |||
| 8601 | 8601 | 103873 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1331 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006745.9342 | 2115531.8344 | 37.789228224750296 | -122.42050126058999 | (37.7892282247503, -122.42050126059) | ||
| 8652 | 8652 | 17853 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2107 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003780.8726 | 2115230.9219 | 37.7882344536868 | -122.430738528508 | (37.7882344536868, -122.430738528508) | |||
| 8688 | 8688 | 19233 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 605 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 6 | 3X3 | 6002090.2242 | 2110622.18 | 37.7754840861265 | -122.436257924088 | (37.7754840861265, -122.436257924088) | ||
| 8749 | 8749 | 94239 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2517 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 18 | 3x3 | Permit Number 53613 | 6001890.99196 | 2116983.8431599997 | 37.792940270517995 | -122.437402758825 | (37.792940270518, -122.437402758825) | |
| 8755 | 8755 | 110066 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2800 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775072 | 6000181.955 | 2117156.2585 | 37.79331636970829 | -122.443328486221 | (37.7933163697083, -122.443328486221) | |
| 9024 | 9024 | 17192 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004636.98078 | 2116874.21207 | 37.792794979656 | -122.42789367737801 | (37.792794979656, -122.427893677378) | |||
| 9116 | 9116 | 26550 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1997 12:00:00 AM | 9 | 3x3 | 6009840.2362842 | 2101212.306322 | 37.750084000170396 | -122.40878464955401 | (37.7500840001704, -122.408784649554) | ||
| 9144 | 9144 | 23646 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006680.626318 | 2098423.5908349 | 37.7422493368979 | -122.419512955866 | (37.7422493368979, -122.419512955866) | |||
| 9222 | 9222 | 3940 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002266.5 | 2107605.5 | 37.767211043352 | -122.435432299631 | (37.767211043352, -122.435432299631) | |||
| 9312 | 9312 | 28298 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.475430001 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | ||
| 9362 | 9362 | 2360 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2450 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1999 12:00:00 AM | 8 | 3X3 | 6009684.705885201 | 2103070.313359 | 37.755176960826795 | -122.409453597226 | (37.7551769608268, -122.409453597226) | ||
| 9379 | 9379 | 18368 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 635 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1991 12:00:00 AM | 18 | 3X3 | 6010442.749915901 | 2105355.8900533 | 37.7614950871774 | -122.40699313368299 | (37.7614950871774, -122.406993133683) | ||
| 9763 | 9763 | 47337 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | |
| 9817 | 9817 | 121467 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778925 | 6002578.0 | 2096112.0 | 37.735670303373 | -122.4335333993 | (37.735670303373, -122.4335333993) | ||
| 9913 | 9913 | 59381 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 484 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1982 12:00:00 AM | Permit Number 19657 | 6003572.8522015 | 2096120.76265672 | 37.735750758984295 | -122.430094437299 | (37.7357507589843, -122.430094437299) | |||
| 10415 | 10415 | 47411 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45322 | ||||||||
| 10641 | 10641 | 87649 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2132 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6011869.04727 | 2087711.09521 | 37.7131259154971 | -122.400820441523 | (37.7131259154971, -122.400820441523) | |||
| 10761 | 10761 | 108557 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 107 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773716 | 6001404.8891199995 | 2092211.15094 | 37.7248928376179 | -122.43731005943701 | (37.7248928376179, -122.437310059437) |
| 10864 | 10864 | 115820 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 70 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | Permit Number 773037 | 6006341.45931 | 2093992.33165 | 37.730062972613794 | -122.420371241439 | (37.7300629726138, -122.420371241439) | ||
| 11169 | 11169 | 13364 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 830 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X6 | 6009414.26867 | 2090086.5826 | 37.7195112854978 | -122.409472568024 | (37.7195112854978, -122.409472568024) | ||
| 11183 | 11183 | 107055 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 116 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003293.700669999 | 2094464.35217 | 37.7311868176017 | -122.430941393456 | (37.7311868176017, -122.430941393456) | |||
| 11351 | 11351 | 1825 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2122 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 3x3 | 6011914.69441 | 2087767.06521 | 37.7132821439374 | -122.400666598098 | (37.7132821439374, -122.400666598098) | ||
| 11359 | 11359 | 36625 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11397 | 11397 | 1847 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2401 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/1992 12:00:00 AM | 6 | 3X3 | 6011018.94328 | 2086899.6940900001 | 37.710850517399294 | -122.403701647223 | (37.7108505173993, -122.403701647223) | ||
| 11663 | 11663 | 83295 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 641 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52331 | 6004020.00573 | 2091733.79655 | 37.7237304468 | -122.42823589727 | (37.7237304468, -122.42823589727) | |
| 11706 | 11706 | 1824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6011980.13832 | 2087849.66723 | 37.71351260240579 | -122.40044619853201 | (37.7135126024058, -122.400446198532) | |||
| 11889 | 11889 | 87695 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2630 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6010495.31841 | 2086065.48531 | 37.7085306829266 | -122.40545271269501 | (37.7085306829266, -122.405452712695) | |||
| 12252 | 12252 | 109584 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 130 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774182 | 6000387.321140001 | 2092667.05411 | 37.7260867433969 | -122.440860354433 | (37.7260867433969, -122.440860354433) |
| 12308 | 12308 | 19103 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011731.72061 | 2090797.59755 | 37.7215931665719 | -122.40151188079099 | (37.7215931665719, -122.401511880791) | ||
| 12384 | 12384 | 1828 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2144 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011802.738969999 | 2087632.59723 | 37.7129066769684 | -122.40104411460199 | (37.7129066769684, -122.401044114602) | |||
| 12528 | 12528 | 108544 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 150 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003029.8186099995 | 2094379.55796 | 37.730939036385 | -122.43184762766899 | (37.730939036385, -122.431847627669) |
| 12608 | 12608 | 13371 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 910 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 3X10 | 6009145.59882 | 2090004.2145 | 37.7192700621295 | -122.410395452309 | (37.7192700621295, -122.410395452309) | ||
| 12645 | 12645 | 30435 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | Permit Number 88 | ||||||||
| 12886 | 12886 | 33080 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37335 | ||||||||
| 13179 | 13179 | 13362 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 735 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3X3 | 6009726.8800800005 | 2090058.8572200001 | 37.719452668580296 | -122.408390025292 | (37.7194526685803, -122.408390025292) | ||
| 13420 | 13420 | 85563 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.0442599999 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | ||
| 13505 | 13505 | 96669 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1401 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015030.8283 | 2095408.9192 | 37.734438465157794 | -122.39042969561301 | (37.7344384651578, -122.390429695613) | |||
| 13517 | 13517 | 17430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1887 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013360.18498 | 2096350.84555 | 37.7369319827098 | -122.396271694904 | (37.7369319827098, -122.396271694904) | |||
| 13527 | 13527 | 17453 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1978 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6012900.1702 | 2096763.4249599997 | 37.7380392316108 | -122.39789111398599 | (37.7380392316108, -122.397891113986) | |||
| 13541 | 13541 | 17406 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1788 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 6 | 3x3 | 6013914.850190001 | 2096007.1900099998 | 37.736019223903796 | -122.39432990213001 | (37.7360192239038, -122.39432990213) | ||
| 13544 | 13544 | 85704 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 938 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010866.4915 | 2112368.00991 | 37.7807724621315 | -122.406021584247 | (37.7807724621315, -122.406021584247) | ||
| 13557 | 13557 | 85590 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1570 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015074.2477 | 2095138.5099 | 37.733698384584706 | -122.39026069321599 | (37.7336983845847, -122.390260693216) | ||
| 13572 | 13572 | 85710 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1076 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010030.29241 | 2111566.1673 | 37.7785239870252 | -122.40885782654199 | (37.7785239870252, -122.408857826542) | ||
| 13575 | 13575 | 85711 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1142 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009562.66342 | 2111118.44012 | 37.777268429139205 | -122.410443916749 | (37.7772684291392, -122.410443916749) | ||
| 13614 | 13614 | 110036 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1899x Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x105 | 6013794.5157699995 | 2098115.90007 | 37.741802613794 | -122.39489359088199 | (37.741802613794, -122.394893590882) | |||
| 13657 | 13657 | 37185 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 140 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 2 | Permit Number 39756 | 6009578.451859999 | 2111630.6587099996 | 37.7786757458161 | -122.41042547617901 | (37.7786757458161, -122.410425476179) | ||
| 13696 | 13696 | 18312 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 150 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2001 12:00:00 AM | 3 | 4X4 | 6010232.50216 | 2107573.2091900003 | 37.7675715736855 | -122.40787665988 | (37.7675715736855, -122.40787665988) | ||
| 13751 | 13751 | 85582 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1486 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015517.7847 | 2094813.6891 | 37.7328310842891 | -122.388704574636 | (37.7328310842891, -122.388704574636) | ||
| 13767 | 13767 | 106955 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Lydia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012806.82936 | 2092830.5845700002 | 37.7272352666734 | -122.397938034333 | (37.7272352666734, -122.397938034333) | |||
| 13782 | 13782 | 121585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 424 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6013758.73818 | 2105099.18568 | 37.760975233543 | -122.395506429391 | (37.760975233543, -122.395506429391) | ||
| 13786 | 13786 | 85847 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1556 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007771.67614 | 2109375.7232 | 37.7723827775814 | -122.41651605826401 | (37.7723827775814, -122.416516058264) | ||
| 13790 | 13790 | 17386 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1648 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 3 | 6x8 | 6014603.23708 | 2095493.0278200002 | 37.734645681237 | -122.391913910302 | (37.734645681237, -122.391913910302) | ||
| 13809 | 13809 | 28891 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 525 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2011 12:00:00 AM | 3 | 3x3 | 6013294.03669 | 2111784.2420799998 | 37.779305042839106 | -122.397582515238 | (37.7793050428391, -122.397582515238) | ||
| 13844 | 13844 | 56718 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1542 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | Permit Number 775560 | 6015709.0498 | 2095719.9997 | 37.7353302290178 | -122.388106542106 | (37.7353302290178, -122.388106542106) | ||
| 13860 | 13860 | 85609 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1551 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015130.3081 | 2095032.4348 | 37.7334102332415 | -122.390059466624 | (37.7334102332415, -122.390059466624) | ||
| 13886 | 13886 | 85845 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1488 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008105.12065 | 2109729.2869599997 | 37.773372326810396 | -122.41538767349701 | (37.7733723268104, -122.415387673497) | ||
| 13923 | 13923 | 29859 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1900X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014017.477000001 | 2099779.02044 | 37.7463815884414 | -122.394239070574 | (37.7463815884414, -122.394239070574) | ||
| 13952 | 13952 | 28719 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1636 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6014663.94428 | 2095448.06679 | 37.734525597483895 | -122.391700880702 | (37.7345255974839, -122.391700880702) | ||
| 13973 | 13973 | 85703 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 934 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010909.37789 | 2112408.77368 | 37.7808867884374 | -122.40587609101401 | (37.7808867884374, -122.405876091014) | ||
| 13994 | 13994 | 111136 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 301 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6011714.08738 | 2112122.07313 | 37.7801445464617 | -122.40307201838199 | (37.7801445464617, -122.403072018382) | |||
| 14016 | 14016 | 85738 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 843 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011557.50766 | 2112935.25415 | 37.782368606777204 | -122.40367093449 | (37.7823686067772, -122.40367093449) | ||
| 14028 | 14028 | 85729 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1035 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010261.4115 | 2111695.5435099998 | 37.778892166773296 | -122.408067420501 | (37.7788921667733, -122.408067420501) | ||
| 14094 | 14094 | 85585 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1516 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015333.6646 | 2094945.596 | 37.733183067921 | -122.389350338061 | (37.733183067921, -122.389350338061) | ||
| 14117 | 14117 | 85591 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1574 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015045.6678 | 2095162.1433 | 37.733761691797106 | -122.390361153846 | (37.7337616917971, -122.390361153846) |
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");