Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2357 | 2357 | 39974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 5109 | 5109 | 36635 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5809 | 5809 | 46193 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6461 | 6461 | 34901 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 6892 | 6892 | 36621 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 7024 | 7024 | 34903 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 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 | |||||||||
| 8112 | 8112 | 36618 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 9577 | 9577 | 36622 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 9973 | 9973 | 34904 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 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 | ||||||||
| 10516 | 10516 | 46191 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 10947 | 10947 | 34905 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 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 | |||||||||
| 11887 | 11887 | 46194 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11991 | 11991 | 46192 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12032 | 12032 | 39973 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 12274 | 12274 | 33081 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37335 | ||||||||
| 12314 | 12314 | 36623 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 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 | ||||||||
| 12930 | 12930 | 36616 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13312 | 13312 | 20032 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3ST | ||||||||
| 13700 | 13700 | 36624 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13764 | 13764 | 36627 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13775 | 13775 | 46199 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 14367 | 14367 | 46202 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15451 | 15451 | 34902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 15515 | 15515 | 39976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 15835 | 15835 | 19850 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 15974 | 15974 | 36620 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16053 | 16053 | 36610 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16211 | 16211 | 34900 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 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) | |||
| 160891 | 160891 | 177329 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010501.25874 | 2086080.5894099998 | 37.708572487900895 | -122.405433245075 | (37.7085724879009, -122.405433245075) | |||
| 12915 | 12915 | 87687 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010522.05865 | 2086133.85401 | 37.70871990477921 | -122.40536510614099 | (37.7087199047792, -122.405365106141) | |||
| 48575 | 48575 | 177328 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010526.80865 | 2086149.78348 | 37.708763909485796 | -122.405349810469 | (37.7087639094858, -122.405349810469) | |||
| 123433 | 123433 | 29249 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010557.087504701 | 2086190.1499448998 | 37.708876440573796 | -122.405248002787 | (37.7088764405738, -122.405248002787) | ||
| 11791 | 11791 | 1865 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2555 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6010708.42536 | 2086342.04995 | 37.709301987375206 | -122.404735641836 | (37.7093019873752, -122.404735641836) | |||
| 171493 | 171493 | 58008 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 36 Santa Barbara Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1977 12:00:00 AM | 10 | Permit Number 16974 | 5993293.611959999 | 2086427.3278599998 | 37.708547398612794 | -122.46492972693599 | (37.7085473986128, -122.464929726936) | ||
| 11526 | 11526 | 1872 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010689.185380001 | 2086549.45702 | 37.709870410169 | -122.40481673101101 | (37.709870410169, -122.404816731011) | ||
| 173643 | 173643 | 187485 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | |||
| 155889 | 155889 | 187486 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | |||
| 157169 | 157169 | 187487 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 9ft | 6006739.4924099995 | 2086592.2880099998 | 37.709766454838096 | -122.418470670891 | (37.7097664548381, -122.418470670891) | |||
| 57550 | 57550 | 187488 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 4ft | 6006708.59512 | 2086603.96966 | 37.7097967907675 | -122.418578285583 | (37.7097967907675, -122.418578285583) | |||
| 181907 | 181907 | 187489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006684.44019 | 2086612.8401400002 | 37.7098197873211 | -122.418662398253 | (37.7098197873211, -122.418662398253) | ||||
| 37476 | 37476 | 177325 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 499 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012707.89529 | 2086680.32707 | 37.7103423833654 | -122.397848820678 | (37.7103423833654, -122.397848820678) | |||
| 183355 | 183355 | 177326 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 499 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012697.69197 | 2086683.76637 | 37.7103512587691 | -122.39788432681101 | (37.7103512587691, -122.397884326811) | |||
| 148596 | 148596 | 177327 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 499 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012676.28456 | 2086691.4385799998 | 37.7103711329041 | -122.397958853633 | (37.7103711329041, -122.397958853633) | |||
| 158388 | 158388 | 70302 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50275 | 6008251.84805 | 2086827.4021299998 | 37.7104970532627 | -122.41326029305401 | (37.7104970532627, -122.413260293054) | |
| 116522 | 116522 | 31040 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1142 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34799 | 6000861.46493561 | 2086848.36005116 | 37.7101369112208 | -122.438804492218 | (37.7101369112208, -122.438804492218) | ||
| 10526 | 10526 | 1853 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1991 12:00:00 AM | 6 | 3X3 | 6011002.0813 | 2086868.5454799999 | 37.710764047595895 | -122.40375773612499 | (37.7107640475959, -122.403757736125) | ||
| 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) | ||
| 154735 | 154735 | 81046 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 0 | 5997413.7835 | 2086913.9109900002 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | ||
| 48000 | 48000 | 77997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6009714.16253 | 2086968.8520900002 | 37.710967436463704 | -122.408216166539 | (37.7109674364637, -122.408216166539) | ||
| 93924 | 93924 | 49780 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 308@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2006 12:00:00 AM | Permit Number 46566 | 6012576.33668152 | 2087040.28713415 | 37.711323435173796 | -122.39832875716499 | (37.7113234351738, -122.398328757165) | ||
| 154602 | 154602 | 80931 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 7 | 6001747.57084 | 2087049.21095 | 37.710738776641996 | -122.435756299834 | (37.710738776642, -122.435756299834) | ||
| 56745 | 56745 | 106453 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 27 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6002753.37537 | 2087052.6668099998 | 37.7108053471734 | -122.432280260948 | (37.7108053471734, -122.432280260948) | ||||
| 69479 | 69479 | 80747 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | ||
| 53468 | 53468 | 44401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1159 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 8 | Permit Number 43755 | 6001322.64573 | 2087056.41932 | 37.7107344230292 | -122.43722545029101 | (37.7107344230292, -122.437225450291) | |
| 37756 | 37756 | 177391 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 27 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6002763.35309 | 2087066.1098599997 | 37.7108428246043 | -122.432246735124 | (37.7108428246043, -122.432246735124) | |||
| 72346 | 72346 | 44440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 131 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 11 | Permit Number 43772 | 6001589.30817 | 2087293.5830400002 | 37.7114007774922 | -122.43632076831001 | (37.7114007774922, -122.43632076831) | |
| 129393 | 129393 | 69415 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 144 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33520 | 6001498.01524641 | 2087340.50878812 | 37.7115244375894 | -122.436639656352 | (37.7115244375894, -122.436639656352) | ||
| 41894 | 41894 | 177321 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1222 Naples St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 6001045.82775 | 2087348.99146 | 37.71152202140421 | -122.438203139287 | (37.7115220214042, -122.438203139287) | |||
| 12224 | 12224 | 95538 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6001061.1187 | 2087367.06647 | 37.711572521034604 | -122.438151583834 | (37.7115725210346, -122.438151583834) | ||||
| 188077 | 188077 | 69403 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33507 | 6001071.30066 | 2087381.77877 | 37.7116134968267 | -122.438117445581 | (37.7116134968267, -122.438117445581) | |
| 175523 | 175523 | 78721 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | 6008722.75942 | 2087395.11673 | 37.71208230802971 | -122.41167280256701 | (37.7120823080297, -122.411672802567) | ||
| 88374 | 88374 | 1836 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2190X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011449.2894285 | 2087454.5820611 | 37.7123981596303 | -122.402253250732 | (37.7123981596303, -122.402253250732) | |||
| 108661 | 108661 | 92790 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 242 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2009 12:00:00 AM | 3x3 | Permit Number 53007 | 5994587.0 | 2087471.0 | 37.7114875681215 | -122.460535223932 | (37.7114875681215, -122.460535223932) | ||
| 12947 | 12947 | 87653 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2180X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6011545.44829 | 2087485.71058 | 37.7124889994373 | -122.401923081412 | (37.7124889994373, -122.401923081412) | ||||
| 158814 | 158814 | 177390 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 501 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002484.29135 | 2087521.98733 | 37.71207873771 | -122.43324378918899 | (37.71207873771, -122.433243789189) | |||
| 11453 | 11453 | 1831 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011874.06348 | 2087549.91911 | 37.71268363791079 | -122.40079178733299 | (37.7126836379108, -122.400791787333) | |||
| 161835 | 161835 | 81049 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1239 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2015 12:00:00 AM | 3 | Permit Number 773468 | 6001528.59209 | 2087552.56023 | 37.7121084216401 | -122.436549143022 | (37.7121084216401, -122.436549143022) | |
| 74602 | 74602 | 44391 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 102 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 4 | Permit Number 43750 | 6001720.67463 | 2087557.55104 | 37.712133038777104 | -122.435885607952 | (37.7121330387771, -122.435885607952) | |
| 163647 | 163647 | 42734 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2155 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 24 | Permit Number 42735 | 6011889.3836199995 | 2087568.31883 | 37.7127350143717 | -122.40074012757401 | (37.7127350143717, -122.400740127574) | |
| 25412 | 25412 | 49553 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46443 | 6001403.3817 | 2087572.5099099998 | 37.71215608300871 | -122.43698333301 | (37.7121560830087, -122.43698333301) | |
| 123206 | 123206 | 49554 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 3x3 | Permit Number 46443 | 6001366.47031855 | 2087579.35452031 | 37.7121727787169 | -122.437111399043 | (37.7121727787169, -122.437111399043) | ||
| 185849 | 185849 | 177388 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1011 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002480.547069999 | 2087582.3869599998 | 37.712244369460294 | -122.433261043589 | (37.7122443694603, -122.433261043589) | |||
| 126872 | 126872 | 50828 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.46834817880101 | (37.7117332358721, -122.468348178801) | |||
| 51233 | 51233 | 177389 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1011 Munich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002499.03249 | 2087613.4887400002 | 37.7123308167966 | -122.43319937345301 | (37.7123308167966, -122.433199373453) | |||
| 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) | |||
| 1857 | 1857 | 251765 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1870 | 1870 | 251767 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1871 | 1871 | 176854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | |||
| 1876 | 1876 | 251766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 79622 | 79622 | 1827 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2142 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011820.2937054 | 2087653.754231 | 37.712965749133 | -122.400984924928 | (37.712965749133, -122.400984924928) | |||
| 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) | |||
| 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) | ||
| 69925 | 69925 | 39954 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 219 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 4 | Permit Number 41216 | 6009930.68457 | 2087811.2783400002 | 37.7132926893855 | -122.407527167157 | (37.7132926893855, -122.407527167157) | |
| 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) | |||
| 75159 | 75159 | 1819 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2108 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6011992.2021463 | 2087865.1033243 | 37.7135556595937 | -122.40040558497401 | (37.7135556595937, -122.400405584974) | |||
| 63785 | 63785 | 177323 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 110 Newton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000963.79305 | 2087874.93252 | 37.7129614726723 | -122.438524331244 | (37.7129614726723, -122.438524331244) | |||
| 71492 | 71492 | 177320 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 48 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999675.46135 | 2087889.84317 | 37.7129290440003 | -122.44297828661199 | (37.7129290440003, -122.442978286612) | |||
| 23394 | 23394 | 177322 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 110 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000954.81094 | 2087902.84558 | 37.7130376047797 | -122.438557375049 | (37.7130376047797, -122.438557375049) | |||
| 24945 | 24945 | 31011 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34782 | 6000906.10436 | 2087937.38156 | 37.713129662086395 | -122.438728194053 | (37.7131296620864, -122.438728194053) | |
| 74312 | 74312 | 49764 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 279 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46558 | 6009585.78252 | 2087937.96014 | 37.713621219820396 | -122.408728204567 | (37.7136212198204, -122.408728204567) | |
| 109441 | 109441 | 31010 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Morse St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 121601 | 121601 | 31012 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 95680 | 95680 | 49763 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 274 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 3 | Permit Number 46557 | 6009611.27991 | 2087971.1438799999 | 37.713713763653104 | -122.408642415516 | (37.7137137636531, -122.408642415516) |
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");