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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 140452 | 140452 | 53132 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4130 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2006 12:00:00 AM | Permit Number 49068 | 5992156.9 | 2088377.1 | 37.713835397146 | -122.469000108736 | (37.713835397146, -122.469000108736) | ||
| 50773 | 50773 | 208698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4130 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5992075.90201 | 2088383.47737 | 37.713848227595 | -122.46928052916701 | (37.713848227595, -122.469280529167) | |||
| 135946 | 135946 | 208683 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 225 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994722.911069999 | 2088379.9935599999 | 37.7139912683593 | -122.46013129524201 | (37.7139912683593, -122.460131295242) | |||
| 152043 | 152043 | 177357 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 301 Naglee Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5997754.17366 | 2088444.4959099998 | 37.7143422638536 | -122.449658800639 | (37.7143422638536, -122.449658800639) | |||
| 125501 | 125501 | 122796 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 306 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | 6009497.08014 | 2088289.5150400002 | 37.7145815488228 | -122.40905958389999 | (37.7145815488228, -122.4090595839) | ||
| 178565 | 178565 | 208682 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 297 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994099.3250400005 | 2088701.6429299999 | 37.7148385538346 | -122.462309942464 | (37.7148385538346, -122.462309942464) | |||
| 179753 | 179753 | 177324 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2002 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012319.9971 | 2088385.3018099999 | 37.7150022952082 | -122.399309096654 | (37.7150022952082, -122.399309096654) | |||
| 53305 | 53305 | 208696 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993735.7088 | 2088773.5229599997 | 37.7150149747485 | -122.46357195568399 | (37.7150149747485, -122.463571955684) | |||
| 96448 | 96448 | 26975 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 90X Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1998 12:00:00 AM | 3 | 3X3 | 6000472.340308401 | 2088665.1392898997 | 37.715103235305 | -122.440279583354 | (37.715103235305, -122.440279583354) | ||
| 68786 | 68786 | 34794 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1670 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38430 | 5998285.82951 | 2088873.3400599998 | 37.715550173877894 | -122.447852051851 | (37.7155501738779, -122.447852051851) | |
| 33503 | 33503 | 49777 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 378 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 7 | Permit Number 46563 | 6009152.53696 | 2088691.98045 | 37.7156673285474 | -122.41027886869101 | (37.7156673285474, -122.410278868691) | |
| 157047 | 157047 | 49753 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 608 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 2 | Permit Number 46549 | 6009626.76549 | 2088794.6204400002 | 37.71597572857021 | -122.408646948116 | (37.7159757285702, -122.408646948116) | |
| 75171 | 75171 | 47242 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 834 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 2 | Permit Number 45191 | 6014909.7818 | 2088960.9452 | 37.716726897905396 | -122.39039782268101 | (37.7167268979054, -122.390397822681) | |
| 68821 | 68821 | 121485 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 381 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010824.71506 | 2089147.73678 | 37.7170123357236 | -122.40453109193399 | (37.7170123357236, -122.404531091934) | |||
| 27799 | 27799 | 208686 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997054.6676199995 | 2089435.45045 | 37.7170231509855 | -122.45214801343201 | (37.7170231509855, -122.452148013432) | |||
| 54858 | 54858 | 208690 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 266 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992479.67005 | 2089630.07877 | 37.7172944179741 | -122.467975588622 | (37.7172944179741, -122.467975588622) | |||
| 130343 | 130343 | 47243 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 874 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45192 | 6014744.2406 | 2089184.4725 | 37.7173314758058 | -122.39098563528098 | (37.7173314758058, -122.390985635281) | |
| 51865 | 51865 | 208695 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 575 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5993481.53031 | 2089678.1348 | 37.717484173134295 | -122.46451614222401 | (37.7174841731343, -122.464516142224) | |||
| 169023 | 169023 | 208685 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 61 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.45218587579201 | (37.7178525273547, -122.452185875792) | |||
| 83089 | 83089 | 99442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 990X Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.39307903224501 | (37.7182229956809, -122.393079032245) | |
| 145398 | 145398 | 99440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 990X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.39307903224501 | (37.7182229956809, -122.393079032245) | |
| 75450 | 75450 | 177305 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 185 Bertita St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000394.6870800005 | 2089878.0186 | 37.7184291069833 | -122.44063493035699 | (37.7184291069833, -122.440634930357) | |||
| 163120 | 163120 | 65228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 736 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 10 | Permit Number 28015 | 6003178.33467 | 2089873.3686900001 | 37.7185744644174 | -122.43101269170299 | (37.7185744644174, -122.431012691703) | |
| 114931 | 114931 | 52973 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 238 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48954 | 5991975.413816901 | 2090110.54331743 | 37.7185845236626 | -122.46975350981 | (37.7185845236626, -122.46975350981) | ||
| 98232 | 98232 | 103029 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 434 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.71859090630271 | -122.463407787149 | (37.7185909063027, -122.463407787149) | |||
| 46265 | 46265 | 46432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2St. Ankeny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | 3 | 3x3 | Permit Number 44652 | 6011085.820669999 | 2089727.08588 | 37.7186176993268 | -122.40366931120899 | (37.7186176993268, -122.403669311209) | |
| 165850 | 165850 | 110398 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2St. Ankeny St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011080.03742 | 2089739.9973900001 | 37.718652828636706 | -122.403690209641 | (37.7186528286367, -122.403690209641) | |||
| 37292 | 37292 | 177310 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 8 Seminole Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5999325.726559999 | 2089990.15999 | 37.7186760905062 | -122.44433792397301 | (37.7186760905062, -122.444337923973) | |||
| 177961 | 177961 | 65227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 718 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | 7 | Permit Number 30208 | 6003101.244419999 | 2089922.0743900002 | 37.718703830998 | -122.43128263578998 | (37.718703830998, -122.43128263579) | |
| 15684 | 15684 | 106144 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1060 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6015253.7423 | 2089770.1057 | 37.7189677690784 | -122.38926538172 | (37.7189677690784, -122.38926538172) | |||
| 16264 | 16264 | 106143 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1060 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6015242.1699 | 2089781.0690000001 | 37.718997230587796 | -122.38930614848302 | (37.7189972305878, -122.389306148483) | |||
| 34192 | 34192 | 177311 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 631 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6001193.123869999 | 2090116.89755 | 37.7191304504876 | -122.43789217260401 | (37.7191304504876, -122.437892172604) | ||||
| 36326 | 36326 | 52509 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 780 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50488 | 5998908.927619999 | 2090169.10936 | 37.7191436552289 | -122.445791486497 | (37.7191436552289, -122.445791486497) | |
| 84582 | 84582 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 163791 | 163791 | 52508 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 774 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50489 | 5998922.279069999 | 2090193.88515 | 37.7192124461846 | -122.445747116637 | (37.7192124461846, -122.445747116637) | |
| 46037 | 46037 | 200160 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1090 Gilman Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 6015110.001 | 2089874.8663 | 37.7192474512505 | -122.38976955671998 | (37.7192474512505, -122.38976955672) | |||
| 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) | ||
| 15728 | 15728 | 53163 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1094 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 4 | 3x9 | Permit Number 49084 | 6015091.1198 | 2089891.9203 | 37.7192932311407 | -122.389836013025 | (37.7192932311407, -122.389836013025) |
| 84622 | 84622 | 121145 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 962 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5995080.0 | 2090346.0 | 37.7194099895512 | -122.45903933602399 | (37.7194099895512, -122.459039336024) | ||
| 59486 | 59486 | 177335 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 795 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009682.00524 | 2090045.89023 | 37.7194145508166 | -122.408544227551 | (37.7194145508166, -122.408544227551) | |||
| 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) | ||
| 181408 | 181408 | 53162 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1123@ HAWES Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 1 | Permit Number 49083 | 6014891.3438 | 2089966.2272 | 37.71948618255 | -122.390531758785 | (37.71948618255, -122.390531758785) | |
| 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) | ||
| 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) | |
| 47527 | 47527 | 208697 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993327.08056 | 2090460.0855900003 | 37.719622316685296 | -122.46510676208099 | (37.7196223166853, -122.465106762081) | |||
| 34112 | 34112 | 208680 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 285 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994719.66445 | 2090445.4696799999 | 37.7196623886813 | -122.460292076915 | (37.7196623886813, -122.460292076915) | |||
| 166601 | 166601 | 208679 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994719.174380001 | 2090455.6330799998 | 37.7196902667614 | -122.46029450688299 | (37.7196902667614, -122.460294506883) | |||
| 127183 | 127183 | 48723 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45984 | 5994715.98123116 | 2090468.92851584 | 37.7197265891744 | -122.460306507178 | (37.7197265891744, -122.460306507178) | ||
| 26521 | 26521 | 177309 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 75 Junior Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 6000450.146269999 | 2090377.33986 | 37.7198032881811 | -122.440479023892 | (37.7198032881811, -122.440479023892) | |||
| 14439 | 14439 | 22510 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 6424 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013033.12026 | 2090130.55062 | 37.7198341196365 | -122.396966515609 | (37.7198341196365, -122.396966515609) | |||
| 174905 | 174905 | 177308 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 75 Junior Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 6000462.0988300005 | 2090389.70941 | 37.719837932752206 | -122.44043859488 | (37.7198379327522, -122.44043859488) | |||
| 16470 | 16470 | 22509 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 6424 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013042.812059999 | 2090152.4553 | 37.719894804984705 | -122.39693454919399 | (37.7198948049847, -122.396934549194) | |||
| 158825 | 158825 | 177307 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 75 Junior Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 6000486.97114 | 2090414.10488 | 37.7199063333918 | -122.440354368881 | (37.7199063333918, -122.440354368881) | |||
| 35102 | 35102 | 193285 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 6404 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6013054.96871 | 2090181.90765 | 37.7199763519128 | -122.39689459142599 | (37.7199763519128, -122.396894591426) | |||
| 158340 | 158340 | 177306 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 74 Junior Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000548.92485 | 2090440.6429 | 37.7199827281029 | -122.44014211896999 | (37.7199827281029, -122.44014211897) | |||
| 147036 | 147036 | 193284 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 6404 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013063.29248 | 2090204.76107 | 37.720039566142795 | -122.39686742021799 | (37.7200395661428, -122.396867420218) | |||
| 70315 | 70315 | 200219 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2524 Hawes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015214.1526 | 2090169.0486 | 37.7200609932548 | -122.389430074058 | (37.7200609932548, -122.389430074058) | |||
| 61418 | 61418 | 200215 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1104 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015183.0898 | 2090173.9212 | 37.7200726501708 | -122.389537788628 | (37.7200726501708, -122.389537788628) | |||
| 41696 | 41696 | 97219 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1166 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5x7 | 6014695.2222 | 2090186.7117 | 37.720080707529995 | -122.391225088659 | (37.72008070753, -122.391225088659) | |||
| 167929 | 167929 | 200218 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2524 Hawes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015220.8524 | 2090180.0119 | 37.7200914677866 | -122.38940768013799 | (37.7200914677866, -122.389407680138) | |||
| 183379 | 183379 | 177316 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Edinburgh St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6002617.49399 | 2090441.19194 | 37.7201017857494 | -122.432991832412 | (37.7201017857494, -122.432991832412) | |||
| 132857 | 132857 | 200217 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2524 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015228.1612 | 2090189.148 | 37.7201169589456 | -122.389383053542 | (37.7201169589456, -122.389383053542) | |||
| 48156 | 48156 | 200216 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2524 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015239.1246 | 2090204.9839 | 37.7201610490527 | -122.38934626171002 | (37.7201610490527, -122.38934626171) | |||
| 148819 | 148819 | 208694 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 528 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993272.92946 | 2090693.8114599998 | 37.7202609486599 | -122.465310909985 | (37.7202609486599, -122.465310909985) | |||
| 81842 | 81842 | 22500 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 6400 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013113.366359999 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | |||
| 140634 | 140634 | 22499 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 6400 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6013113.366359999 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | ||
| 158581 | 158581 | 208681 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 111 Harold Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5996787.03156 | 2090623.34401 | 37.720269494034206 | -122.45315880284299 | (37.7202694940342, -122.453158802843) | |||
| 156765 | 156765 | 200195 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1124 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015078.3292 | 2090251.2735 | 37.7202792351812 | -122.38990531391799 | (37.7202792351812, -122.389905313918) | |||
| 99329 | 99329 | 47377 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 528 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45294 | 5993282.7857759 | 2090700.56531767 | 37.7202800615282 | -122.46527733056601 | (37.7202800615282, -122.465277330566) | ||
| 157040 | 157040 | 177315 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Edinburgh St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6002661.25858 | 2090511.2437900002 | 37.720296614877604 | -122.432845554988 | (37.7202966148776, -122.432845554988) | |||
| 74154 | 74154 | 177314 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Edinburgh St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6002705.04854 | 2090582.53455 | 37.7204948470285 | -122.432699277554 | (37.7204948470285, -122.432699277554) | |||
| 155177 | 155177 | 177313 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Edinburgh St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6002728.18448 | 2090617.99941 | 37.72059353774179 | -122.432621836053 | (37.7205935377418, -122.432621836053) | |||
| 55049 | 55049 | 208689 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 455 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992461.84626 | 2090851.0446 | 37.720645863902504 | -122.468125963363 | (37.7206458639025, -122.468125963363) | |||
| 160838 | 160838 | 208688 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 455 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992460.8318300005 | 2090875.38614 | 37.7207126412465 | -122.46813123966601 | (37.7207126412465, -122.468131239666) | |||
| 11505 | 11505 | 9312 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 201 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/19/1996 12:00:00 AM | 18 | 3X3 | 6011150.91065 | 2090494.63416 | 37.7207288659168 | -122.403498291618 | (37.7207288659168, -122.403498291618) | ||
| 88553 | 88553 | 45350 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 455 Vernon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2001 12:00:00 AM | Permit Number 44178 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821001 | (37.7207553141827, -122.46815485821) | |||
| 139677 | 139677 | 45352 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 455 Vernon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2001 12:00:00 AM | Permit Number 44178 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821001 | (37.7207553141827, -122.46815485821) | |||
| 135237 | 135237 | 177319 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 550 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002481.4693599995 | 2090712.7834700001 | 37.7208397991014 | -122.43348142155001 | (37.7208397991014, -122.43348142155) | |||
| 62133 | 62133 | 177312 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 990 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004345.08897 | 2090703.55214 | 37.7209200105305 | -122.427038795317 | (37.7209200105305, -122.427038795317) | |||
| 148160 | 148160 | 115022 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 990 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 774504 | 6004332.02589 | 2090712.53114 | 37.7209439262085 | -122.427084589693 | (37.7209439262085, -122.427084589693) | ||
| 122549 | 122549 | 177334 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Mansell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6011049.62415 | 2090588.1282099998 | 37.7209799233761 | -122.403854985233 | (37.7209799233761, -122.403854985233) | |||
| 179622 | 179622 | 177333 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Mansell St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6011067.50677 | 2090593.3372400003 | 37.720995225336296 | -122.403793536344 | (37.7209952253363, -122.403793536344) | |||
| 183559 | 183559 | 177332 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Mansell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6011082.08526 | 2090597.9578 | 37.721008726866 | -122.403743467507 | (37.721008726866, -122.403743467507) | |||
| 24365 | 24365 | 177331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 230 Mansell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6011147.98766 | 2090617.26897 | 37.7210654327147 | -122.403517019111 | (37.7210654327147, -122.403517019111) | |||
| 34230 | 34230 | 177336 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011548.32008 | 2090616.8066 | 37.721086516412605 | -122.40213314684799 | (37.7210865164126, -122.402133146848) | |||
| 138755 | 138755 | 9307 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 240X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | 3 | 3x100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | ||
| 137180 | 137180 | 177330 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Mansell St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6011195.6920300005 | 2090632.0336200001 | 37.7211086379305 | -122.40335315633499 | (37.7211086379305, -122.403353156335) | |||
| 61949 | 61949 | 208684 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 585 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993765.24366 | 2091036.8987099999 | 37.7212313630082 | -122.463634043094 | (37.7212313630082, -122.463634043094) | |||
| 56720 | 56720 | 193021 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1751 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012257.08311 | 2090663.0513799998 | 37.721253030383394 | -122.39968639011002 | (37.7212530303834, -122.39968639011) | |||
| 113981 | 113981 | 26585 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1799X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6012261.690909999 | 2090666.23953 | 37.721262041256296 | -122.399670685893 | (37.7212620412563, -122.399670685893) | ||
| 59595 | 59595 | 177318 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 518 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002586.887999999 | 2090878.3713900002 | 37.721300447139896 | -122.433128846816 | (37.7213004471399, -122.433128846816) | |||
| 43372 | 43372 | 208693 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Arch St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992715.7483 | 2091102.3080400003 | 37.7213504323647 | -122.46726657121201 | (37.7213504323647, -122.467266571212) | |||
| 44793 | 44793 | 208692 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Arch St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992715.181469999 | 2091115.28005 | 37.7213860176206 | -122.46726947330099 | (37.7213860176206, -122.467269473301) | |||
| 141684 | 141684 | 47328 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 585 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45258 | 5993756.61747977 | 2091094.97603539 | 37.7213903322657 | -122.46366807410801 | (37.7213903322657, -122.463668074108) | ||
| 123308 | 123308 | 208691 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Arch St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992715.41868 | 2091126.56279 | 37.7214170109678 | -122.467269473306 | (37.7214170109678, -122.467269473306) | |||
| 57986 | 57986 | 208687 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 395 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991938.37587 | 2091181.6413599998 | 37.7215233557961 | -122.469959478655 | (37.7215233557961, -122.469959478655) | |||
| 12296 | 12296 | 19104 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.4617400002 | 37.721569360619604 | -122.40160216911 | (37.7215693606196, -122.40160216911) | ||
| 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) | ||
| 110294 | 110294 | 46834 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 358 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44907 | 6004295.96661006 | 2091077.05799407 | 37.7219427978316 | -122.42723518848999 | (37.7219427978316, -122.42723518849) |
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");