trees
6,344 rows where qSpecies_id = 19 sorted by YCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62636 | 31011 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34782 | 6000906.10436 | 2087937.38156 | 37.7131296620864 | -122.438728194053 | (37.7131296620864, -122.438728194053) | 9 | 7 | 6 | 28861 | 5 | |
77769 | 49764 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 279 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 8 | Permit Number 46558 | 6009585.78252 | 2087937.96014 | 37.7136212198204 | -122.408728204567 | (37.7136212198204, -122.408728204567) | 9 | 7 | 8 | 309 | 39 | |
117880 | 31010 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
163801 | 31012 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
106461 | 49763 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 274 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 3 | Permit Number 46557 | 6009611.27991 | 2087971.14388 | 37.7137137636531 | -122.408642415516 | (37.7137137636531, -122.408642415516) | 9 | 7 | 8 | 309 | 39 | |
121402 | 69393 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 13 | Permit Number 33497 | 6001235.31343 | 2088039.6013 | 37.7134290580849 | -122.437597654505 | (37.7134290580849, -122.437597654505) | 9 | 7 | 6 | 28861 | 5 | |
21720 | 122796 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 306 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | 6009497.08014 | 2088289.51504 | 37.7145815488228 | -122.4090595839 | (37.7145815488228, -122.4090595839) | 9 | 7 | 8 | 309 | 39 | ||
88964 | 253991 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 534 Leland Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781039 | 6007916 | 2088302 | 37.7145271314419 | -122.414525337386 | (37.7145271314419, -122.414525337386) | 9 | 7 | 8 | 309 | 39 | |||
161196 | 253990 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 534 Leland Ave | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781039 | 6007916 | 2088302 | 37.7145271314419 | -122.414525337386 | (37.7145271314419, -122.414525337386) | 9 | 7 | 8 | 309 | 39 | |||
188161 | 53132 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | Permit Number 49068 | 5992156.9 | 2088377.1 | 37.713835397146 | -122.469000108736 | (37.713835397146, -122.469000108736) | 9 | 8 | 6 | 64 | 24 | ||
174782 | 208683 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 225 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994722.91107 | 2088379.99356 | 37.7139912683593 | -122.460131295242 | (37.7139912683593, -122.460131295242) | 9 | 8 | 6 | 28861 | 24 | |||
28492 | 208698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992075.90201 | 2088383.47737 | 37.713848227595 | -122.469280529167 | (37.713848227595, -122.469280529167) | 9 | 8 | 6 | 64 | 24 | |||
99099 | 177324 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2002 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012319.9971 | 2088385.30181 | 37.7150022952082 | -122.399309096654 | (37.7150022952082, -122.399309096654) | 10 | 7 | 8 | 309 | 39 | |||
192168 | 177357 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 Naglee Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5997754.17366 | 2088444.49591 | 37.7143422638536 | -122.449658800639 | (37.7143422638536, -122.449658800639) | 9 | 7 | 6 | 28861 | 25 | |||
84480 | 26975 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90X Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/1998 12:00:00 AM | 3 | 3X3 | 6000472.3403084 | 2088665.1392899 | 37.715103235305 | -122.440279583354 | (37.715103235305, -122.440279583354) | 9 | 7 | 6 | 28861 | 5 | ||
178859 | 49777 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 378 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 7 | Permit Number 46563 | 6009152.53696 | 2088691.98045 | 37.7156673285474 | -122.410278868691 | (37.7156673285474, -122.410278868691) | 9 | 7 | 8 | 309 | 39 | |
68550 | 208682 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 297 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994099.32504 | 2088701.64293 | 37.7148385538346 | -122.462309942464 | (37.7148385538346, -122.462309942464) | 9 | 8 | 6 | 28861 | 24 | |||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
129284 | 49753 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 608 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46549 | 6009626.76549 | 2088794.62044 | 37.7159757285702 | -122.408646948116 | (37.7159757285702, -122.408646948116) | 9 | 7 | 8 | 309 | 39 | |
67131 | 34794 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1670 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | 7 | Permit Number 38430 | 5998285.82951 | 2088873.34006 | 37.7155501738779 | -122.447852051851 | (37.7155501738779, -122.447852051851) | 9 | 7 | 6 | 28861 | 25 | |
192238 | 47242 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 834 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 2 | Permit Number 45191 | 6014909.7818 | 2088960.9452 | 37.7167268979054 | -122.390397822681 | (37.7167268979054, -122.390397822681) | 10 | 3 | 8 | 58 | 1 | |
180176 | 121485 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 381 Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010824.71506 | 2089147.73678 | 37.7170123357236 | -122.404531091934 | (37.7170123357236, -122.404531091934) | 9 | 7 | 8 | 309 | 39 | |||
43072 | 47243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 874 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45192 | 6014744.2406 | 2089184.4725 | 37.7173314758058 | -122.390985635281 | (37.7173314758058, -122.390985635281) | 10 | 3 | 8 | 58 | 1 | |
57156 | 254766 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776608 | 5997440.77634 | 2089380.40278 | 37.7168941131095 | -122.450809461106 | (37.7168941131095, -122.450809461106) | 9 | 8 | 6 | 28861 | 24 | |
62051 | 254764 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 77 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776607 | 5997448.21567 | 2089391.00345 | 37.7169236459528 | -122.450784510991 | (37.7169236459528, -122.450784510991) | 9 | 8 | 6 | 28861 | 24 | |
28618 | 208686 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 207 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997054.66762 | 2089435.45045 | 37.7170231509855 | -122.452148013432 | (37.7170231509855, -122.452148013432) | 9 | 8 | 6 | 28861 | 24 | |||
7123 | 99440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.393079032245 | (37.7182229956809, -122.393079032245) | 10 | 3 | 8 | 58 | 1 | |
20198 | 99442 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990X Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.393079032245 | (37.7182229956809, -122.393079032245) | 10 | 3 | 8 | 58 | 1 | |
118232 | 208690 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 266 Vernon St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992479.67005 | 2089630.07877 | 37.7172944179741 | -122.467975588622 | (37.7172944179741, -122.467975588622) | 9 | 8 | 6 | 64 | 24 | |||
175864 | 208695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 575 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993481.53031 | 2089678.1348 | 37.7174841731343 | -122.464516142224 | (37.7174841731343, -122.464516142224) | 9 | 8 | 6 | 64 | 24 | |||
129107 | 46432 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 3 | 3x3 | Permit Number 44652 | 6011085.82067 | 2089727.08588 | 37.7186176993268 | -122.403669311209 | (37.7186176993268, -122.403669311209) | 10 | 7 | 8 | 309 | 28 | |
7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
46971 | 110398 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011080.03742 | 2089739.99739 | 37.7186528286367 | -122.403690209641 | (37.7186528286367, -122.403690209641) | 10 | 7 | 8 | 309 | 28 | |||
153322 | 106144 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1060 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6015253.7423 | 2089770.1057 | 37.7189677690784 | -122.38926538172 | (37.7189677690784, -122.38926538172) | 10 | 3 | 8 | 58 | 1 | |||
135473 | 106143 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1060 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6015242.1699 | 2089781.069 | 37.7189972305878 | -122.389306148483 | (37.7189972305878, -122.389306148483) | 10 | 3 | 8 | 58 | 1 | |||
11765 | 65228 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 736 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 28015 | 6003178.33467 | 2089873.36869 | 37.7185744644174 | -122.431012691703 | (37.7185744644174, -122.431012691703) | 9 | 7 | 6 | 28861 | 5 | |
178965 | 200160 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1090 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 6015110.001 | 2089874.8663 | 37.7192474512505 | -122.38976955672 | (37.7192474512505, -122.38976955672) | 10 | 3 | 8 | 58 | 1 | |||
97147 | 177305 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 185 Bertita St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000394.68708 | 2089878.0186 | 37.7184291069833 | -122.440634930357 | (37.7184291069833, -122.440634930357) | 9 | 7 | 6 | 28861 | 25 | |||
110088 | 53163 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1094 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 4 | 3x9 | Permit Number 49084 | 6015091.1198 | 2089891.9203 | 37.7192932311407 | -122.389836013025 | (37.7192932311407, -122.389836013025) | 10 | 3 | 8 | 58 | 1 |
81124 | 65227 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 718 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | 7 | Permit Number 30208 | 6003101.24442 | 2089922.07439 | 37.718703830998 | -122.43128263579 | (37.718703830998, -122.43128263579) | 9 | 7 | 6 | 28861 | 5 | |
6736 | 53162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1123@ HAWES Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 1 | Permit Number 49083 | 6014891.3438 | 2089966.2272 | 37.71948618255 | -122.390531758785 | (37.71948618255, -122.390531758785) | 10 | 3 | 8 | 58 | 1 | |
42443 | 177310 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 8 Seminole Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5999325.72656 | 2089990.15999 | 37.7186760905062 | -122.444337923973 | (37.7186760905062, -122.444337923973) | 9 | 7 | 6 | 28861 | 25 | |||
124511 | 13371 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 910 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2007 12:00:00 AM | 3 | 3X10 | 6009145.59882 | 2090004.2145 | 37.7192700621295 | -122.410395452309 | (37.7192700621295, -122.410395452309) | 9 | 3 | 7 | 309 | 28 | ||
188556 | 177335 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009682.00524 | 2090045.89023 | 37.7194145508166 | -122.408544227551 | (37.7194145508166, -122.408544227551) | 9 | 3 | 8 | 309 | 18 | |||
177918 | 13362 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 735 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/2006 12:00:00 AM | 3 | 3X3 | 6009726.88008 | 2090058.85722 | 37.7194526685803 | -122.408390025292 | (37.7194526685803, -122.408390025292) | 9 | 3 | 8 | 309 | 18 | ||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
96226 | 103029 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.7185909063027 | -122.463407787149 | (37.7185909063027, -122.463407787149) | 9 | 8 | 6 | 64 | 24 | |||
68917 | 13364 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 830 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X6 | 6009414.26867 | 2090086.5826 | 37.7195112854978 | -122.409472568024 | (37.7195112854978, -122.409472568024) | 9 | 3 | 7 | 309 | 28 | ||
133048 | 52973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 238 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48954 | 5991975.4138169 | 2090110.54331743 | 37.7185845236626 | -122.46975350981 | (37.7185845236626, -122.46975350981) | 9 | 8 | 6 | 64 | 24 | ||
152096 | 177311 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 631 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6001193.12387 | 2090116.89755 | 37.7191304504876 | -122.437892172604 | (37.7191304504876, -122.437892172604) | 9 | 7 | 6 | 28861 | 5 | ||||
70104 | 22510 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6424 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013033.12026 | 2090130.55062 | 37.7198341196365 | -122.396966515609 | (37.7198341196365, -122.396966515609) | 10 | 3 | 8 | 58 | 1 | |||
174308 | 22509 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6424 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013042.81206 | 2090152.4553 | 37.7198948049847 | -122.396934549194 | (37.7198948049847, -122.396934549194) | 10 | 3 | 8 | 58 | 1 | |||
80137 | 200219 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015214.1526 | 2090169.0486 | 37.7200609932548 | -122.389430074058 | (37.7200609932548, -122.389430074058) | 10 | 3 | 8 | 58 | 1 | |||
139169 | 52509 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 780 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50488 | 5998908.92762 | 2090169.10936 | 37.7191436552289 | -122.445791486497 | (37.7191436552289, -122.445791486497) | 9 | 7 | 6 | 28861 | 25 | |
121211 | 200215 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1104 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015183.0898 | 2090173.9212 | 37.7200726501708 | -122.389537788628 | (37.7200726501708, -122.389537788628) | 10 | 3 | 8 | 58 | 1 | |||
19797 | 200218 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015220.8524 | 2090180.0119 | 37.7200914677866 | -122.389407680138 | (37.7200914677866, -122.389407680138) | 10 | 3 | 8 | 58 | 1 | |||
134994 | 193285 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6404 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013054.96871 | 2090181.90765 | 37.7199763519128 | -122.396894591426 | (37.7199763519128, -122.396894591426) | 10 | 3 | 8 | 58 | 1 | |||
143897 | 97219 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1166 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x7 | 6014695.2222 | 2090186.7117 | 37.72008070753 | -122.391225088659 | (37.72008070753, -122.391225088659) | 10 | 3 | 8 | 58 | 1 | |||
181990 | 200217 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015228.1612 | 2090189.148 | 37.7201169589456 | -122.389383053542 | (37.7201169589456, -122.389383053542) | 10 | 3 | 8 | 58 | 1 | |||
90197 | 52508 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 774 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50489 | 5998922.27907 | 2090193.88515 | 37.7192124461846 | -122.445747116637 | (37.7192124461846, -122.445747116637) | 9 | 7 | 6 | 28861 | 25 | |
49287 | 193284 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6404 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013063.29248 | 2090204.76107 | 37.7200395661428 | -122.396867420218 | (37.7200395661428, -122.396867420218) | 10 | 3 | 8 | 58 | 1 | |||
55331 | 200216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015239.1246 | 2090204.9839 | 37.7201610490527 | -122.38934626171 | (37.7201610490527, -122.38934626171) | 10 | 3 | 8 | 58 | 1 | |||
89462 | 200195 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1124 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015078.3292 | 2090251.2735 | 37.7202792351812 | -122.389905313918 | (37.7202792351812, -122.389905313918) | 10 | 3 | 8 | 58 | 1 | |||
41122 | 22500 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6400 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013113.36636 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | 10 | 3 | 8 | 58 | 1 | |||
188477 | 22499 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6400 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6013113.36636 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | 10 | 3 | 8 | 58 | 1 | ||
58189 | 121145 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 962 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5995080 | 2090346 | 37.7194099895512 | -122.459039336024 | (37.7194099895512, -122.459039336024) | 9 | 8 | 6 | 28861 | 24 | ||
29951 | 177309 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 75 Junior Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000450.14627 | 2090377.33986 | 37.7198032881811 | -122.440479023892 | (37.7198032881811, -122.440479023892) | 9 | 7 | 6 | 28861 | 25 | |||
173269 | 177308 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 75 Junior Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000462.09883 | 2090389.70941 | 37.7198379327522 | -122.44043859488 | (37.7198379327522, -122.44043859488) | 9 | 7 | 6 | 28861 | 25 | |||
135961 | 177307 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 75 Junior Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000486.97114 | 2090414.10488 | 37.7199063333918 | -122.440354368881 | (37.7199063333918, -122.440354368881) | 9 | 7 | 6 | 28861 | 25 | |||
41877 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
107452 | 177306 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 74 Junior Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000548.92485 | 2090440.6429 | 37.7199827281029 | -122.44014211897 | (37.7199827281029, -122.44014211897) | 9 | 7 | 6 | 28861 | 25 | |||
158695 | 177316 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002617.49399 | 2090441.19194 | 37.7201017857494 | -122.432991832412 | (37.7201017857494, -122.432991832412) | 9 | 7 | 6 | 28861 | 5 | |||
55233 | 208680 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 285 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994719.66445 | 2090445.46968 | 37.7196623886813 | -122.460292076915 | (37.7196623886813, -122.460292076915) | 9 | 8 | 6 | 28861 | 24 | |||
104536 | 208679 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994719.17438 | 2090455.63308 | 37.7196902667614 | -122.460294506883 | (37.7196902667614, -122.460294506883) | 9 | 8 | 6 | 28861 | 24 | |||
83194 | 208697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Garfield St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993327.08056 | 2090460.08559 | 37.7196223166853 | -122.465106762081 | (37.7196223166853, -122.465106762081) | 9 | 8 | 6 | 64 | 24 | |||
7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
29741 | 48723 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45984 | 5994715.98123116 | 2090468.92851584 | 37.7197265891744 | -122.460306507178 | (37.7197265891744, -122.460306507178) | 9 | 8 | 6 | 28861 | 24 | ||
80830 | 9312 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 201 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/1996 12:00:00 AM | 18 | 3X3 | 6011150.91065 | 2090494.63416 | 37.7207288659168 | -122.403498291618 | (37.7207288659168, -122.403498291618) | 10 | 7 | 8 | 309 | 28 | ||
21000 | 177315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002661.25858 | 2090511.24379 | 37.7202966148776 | -122.432845554988 | (37.7202966148776, -122.432845554988) | 9 | 7 | 6 | 28861 | 5 | |||
10345 | 177314 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002705.04854 | 2090582.53455 | 37.7204948470285 | -122.432699277554 | (37.7204948470285, -122.432699277554) | 9 | 7 | 6 | 28861 | 5 | |||
19533 | 259217 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996177 | 2090586 | 37.7201319742324 | -122.455264770625 | (37.7201319742324, -122.455264770625) | 9 | 8 | 6 | 28861 | 24 | |
179030 | 177334 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 260 Mansell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6011049.62415 | 2090588.12821 | 37.7209799233761 | -122.403854985233 | (37.7209799233761, -122.403854985233) | 10 | 3 | 7 | 309 | 28 | |||
93257 | 177333 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 260 Mansell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011067.50677 | 2090593.33724 | 37.7209952253363 | -122.403793536344 | (37.7209952253363, -122.403793536344) | 10 | 3 | 7 | 309 | 28 | |||
187974 | 177332 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 260 Mansell St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011082.08526 | 2090597.9578 | 37.721008726866 | -122.403743467507 | (37.721008726866, -122.403743467507) | 10 | 3 | 7 | 309 | 28 | |||
109283 | 177336 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011548.32008 | 2090616.8066 | 37.7210865164126 | -122.402133146848 | (37.7210865164126, -122.402133146848) | 10 | 7 | 8 | 309 | 28 | |||
39333 | 177331 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 230 Mansell St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011147.98766 | 2090617.26897 | 37.7210654327147 | -122.403517019111 | (37.7210654327147, -122.403517019111) | 10 | 3 | 7 | 309 | 28 | |||
73116 | 177313 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6002728.18448 | 2090617.99941 | 37.7205935377418 | -122.432621836053 | (37.7205935377418, -122.432621836053) | 9 | 7 | 6 | 28861 | 5 | |||
180691 | 208681 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 111 Harold Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996787.03156 | 2090623.34401 | 37.7202694940342 | -122.453158802843 | (37.7202694940342, -122.453158802843) | 9 | 8 | 6 | 28861 | 24 | |||
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4243 | 162646 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
189545 | 9307 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 240X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2011 12:00:00 AM | 3 | 3x100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
21546 | 177330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Mansell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011195.69203 | 2090632.03362 | 37.7211086379305 | -122.403353156335 | (37.7211086379305, -122.403353156335) | 10 | 3 | 7 | 309 | 28 | |||
153534 | 193021 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1751 Bay Shore Blvd | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6012257.08311 | 2090663.05138 | 37.7212530303834 | -122.39968639011 | (37.7212530303834, -122.39968639011) | 10 | 3 | 8 | 58 | 1 | |||
148487 | 26585 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1799X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6012261.69091 | 2090666.23953 | 37.7212620412563 | -122.399670685893 | (37.7212620412563, -122.399670685893) | 10 | 3 | 8 | 58 | 1 | ||
156440 | 208694 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 528 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993272.92946 | 2090693.81146 | 37.7202609486599 | -122.465310909985 | (37.7202609486599, -122.465310909985) | 9 | 8 | 6 | 64 | 24 | |||
104304 | 47377 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 528 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45294 | 5993282.7857759 | 2090700.56531767 | 37.7202800615282 | -122.465277330566 | (37.7202800615282, -122.465277330566) | 9 | 8 | 6 | 64 | 24 | ||
124418 | 177312 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004345.08897 | 2090703.55214 | 37.7209200105305 | -122.427038795317 | (37.7209200105305, -122.427038795317) | 9 | 7 | 6 | 28861 | 5 | |||
120341 | 115022 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 1 | Permit Number 774504 | 6004332.02589 | 2090712.53114 | 37.7209439262085 | -122.427084589693 | (37.7209439262085, -122.427084589693) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );