trees
254 rows where qSpecies_id = 78
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67441 | 136291 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | 7 | 9 | 9 | 28852 | 36 | |||
68533 | 14977 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 495X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016593.75941 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | 10 | 3 | 8 | 58 | 1 | ||
68597 | 23583 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005493.5455 | 2121226.72691 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | 5 | 1 | 1 | 28858 | 32 | |||
69328 | 1227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/2004 12:00:00 AM | 8 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
69653 | 14961 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.7411853074635 | -122.384350479174 | (37.7411853074635, -122.384350479174) | 10 | 3 | 8 | 58 | 1 | |||
70193 | 10851 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1220X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | ||
70692 | 240357 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 20 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.428154122837 | (37.7601182299832, -122.428154122837) | 2 | 4 | 5 | 28862 | 3 | |||
70732 | 201670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6010207.48998 | 2109776.17317 | 37.7736190045563 | -122.408118556848 | (37.7736190045563, -122.408118556848) | 14 | 2 | 9 | 28853 | 34 | ||||
70792 | 23332 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
71515 | 197261 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017380.57172 | 2095099.80246 | 37.7337197590624 | -122.382284280115 | (37.7337197590624, -122.382284280115) | 10 | 3 | 8 | 58 | 1 | |||
71707 | 104600 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1945 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007230.70015 | 2119043.68461 | 37.7988981990374 | -122.419073222948 | (37.7988981990374, -122.419073222948) | 5 | 1 | 10 | 28858 | 32 | |
71826 | 27553 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
72255 | 240350 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4746 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998436.06596 | 2105691.7221 | 37.7617380052332 | -122.448543308522 | (37.7617380052332, -122.448543308522) | 15 | 5 | 11 | 29492 | 9 | |||
72754 | 23582 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | 5 | 1 | 1 | 28858 | 32 | ||
74325 | 10777 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
74430 | 23333 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
75037 | 214008 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 222 Sadowa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994773.56041 | 2087779.1496 | 37.7123444055547 | -122.459912734779 | (37.7123444055547, -122.459912734779) | 9 | 8 | 6 | 28861 | 24 | |||
75684 | 197245 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016656.39457 | 2097572.22784 | 37.7404685163083 | -122.38496019216 | (37.7404685163083, -122.38496019216) | 10 | 3 | 8 | 58 | 1 | |||
75830 | 197264 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 55 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017243.9601 | 2095358.62855 | 37.734422897596 | -122.382774596779 | (37.734422897596, -122.382774596779) | 10 | 3 | 8 | 58 | 1 | |||
76183 | 27589 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
77034 | 23354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
77040 | 240349 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.7617425503974 | -122.448442119502 | (37.7617425503974, -122.448442119502) | 15 | 5 | 11 | 29492 | 9 | |||
77159 | 240356 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 19 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589 | -122.428136192158 | (37.760130042589, -122.428136192158) | 2 | 4 | 5 | 28862 | 3 | |||
77492 | 197255 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | 10 | 3 | 8 | 58 | 1 | |||
77807 | 13296 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2770 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2016 12:00:00 AM | 2 | 3X3 | Permit Number 770074 | 5999335.52143 | 2119120.50059 | 37.7986613518083 | -122.446398566642 | (37.7986613518083, -122.446398566642) | 13 | 9 | 1 | 57 | 17 | |
78512 | 12132 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.99502 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | 10 | 3 | 8 | 58 | 1 | ||
79040 | 14988 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.385670780678 | (37.7400006988631, -122.385670780678) | 10 | 3 | 8 | 58 | 1 | ||
79318 | 11430 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 810X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3x3 | 6016021.05885 | 2096802.45168 | 37.7383197051187 | -122.387103277147 | (37.7383197051187, -122.387103277147) | 10 | 3 | 8 | 58 | 1 | ||
80580 | 29655 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 15 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015616.5769 | 2096101.5164 | 37.7363726727082 | -122.388452878787 | (37.7363726727082, -122.388452878787) | 10 | 3 | 8 | 58 | 1 | ||
81664 | 197243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016629.41985 | 2097534.84725 | 37.7403643847096 | -122.385050857321 | (37.7403643847096, -122.385050857321) | 10 | 3 | 8 | 58 | 1 | |||
81829 | 49974 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/2003 12:00:00 AM | 10 | 3x6 | Permit Number 46725 | 6003736.17026094 | 2097556.1914573 | 37.739701367535 | -122.429632126542 | (37.739701367535, -122.429632126542) | 2 | 7 | 5 | 63 | 7 |
82383 | 197225 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015963.59101 | 2106011.38061 | 37.7636023160031 | -122.387944392722 | (37.7636023160031, -122.387944392722) | 14 | 3 | 8 | 28856 | 29 | |||
83689 | 14891 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 3 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | 10 | 3 | 8 | 58 | 1 | ||
85764 | 98130 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 4 | 3x4 | 6017903.8 | 2094987 | 37.733438911814 | -122.380467469044 | (37.733438911814, -122.380467469044) | 10 | 3 | 8 | 58 | 1 | ||
87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
87659 | 21043 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
88124 | 27588 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
89094 | 14884 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
90584 | 197232 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015969.52981 | 2105893.92675 | 37.7632801419786 | -122.38791565581 | (37.7632801419786, -122.38791565581) | 14 | 3 | 8 | 28856 | 29 | |||
91055 | 249487 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 13 | 6006262.64335 | 2115713.01946 | 37.7896984663527 | -122.422186268479 | (37.7896984663527, -122.422186268479) | 13 | 9 | 1 | 28858 | 21 | ||||
91583 | 10820 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017736.87901 | 2094664.32601 | 37.7325437003489 | -122.381022142119 | (37.7325437003489, -122.381022142119) | 10 | 3 | 8 | 58 | 1 | ||
92011 | 179362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010207.20881 | 2095669.3235 | 37.7348847192535 | -122.407124961546 | (37.7348847192535, -122.407124961546) | 10 | 3 | 7 | 309 | 28 | |||
92029 | 197235 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016151.23089 | 2103629.88261 | 37.7570736237573 | -122.387129280509 | (37.7570736237573, -122.387129280509) | 10 | 3 | 8 | 28856 | 29 | |||
92608 | 136294 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 6 | Median : Yard | Tree | DPW 1 | 14 | 6006242.09436 | 2115852.50489 | 37.7900802996014 | -122.422267280337 | (37.7900802996014, -122.422267280337) | 13 | 9 | 1 | 28858 | 21 | ||||
93791 | 10823 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.24301 | 2094650.00301 | 37.7325066000949 | -122.380881597251 | (37.7325066000949, -122.380881597251) | 10 | 3 | 8 | 58 | 1 | ||
94362 | 179342 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 700x Mansell St | 45 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6009054.2584 | 2089931.43239 | 37.7190650967554 | -122.410706045769 | (37.7190650967554, -122.410706045769) | 9 | 3 | 8 | 309 | 18 | |||
95650 | 240351 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090 20th St | 1 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | 2 | 4 | 5 | 28862 | 3 | |||
96482 | 29653 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015651.7407 | 2096073.8877 | 37.7362987584373 | -122.388329374012 | (37.7362987584373, -122.388329374012) | 10 | 3 | 8 | 58 | 1 | ||
96726 | 197266 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 818 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015992.31531 | 2096760.75352 | 37.738203618709 | -122.387199751367 | (37.738203618709, -122.387199751367) | 10 | 3 | 8 | 58 | 1 | |||
97214 | 136295 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.8001222024312 | -122.424305148569 | (37.8001222024312, -122.424305148569) | 13 | 9 | 1 | 28858 | 32 | |||
97907 | 136292 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006812.66695 | 2111768.16026 | 37.7788978558793 | -122.420003176823 | (37.7788978558793, -122.420003176823) | 7 | 9 | 9 | 28852 | 36 | |||
98474 | 27536 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016135.46193 | 2102904.74697 | 37.7550816812001 | -122.387133239331 | (37.7550816812001, -122.387133239331) | 10 | 3 | 8 | 28856 | 29 | ||
99331 | 10749 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
100005 | 179370 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010321.94566 | 2095411.61629 | 37.7341835304417 | -122.406710118682 | (37.7341835304417, -122.406710118682) | 10 | 3 | 7 | 309 | 28 | |||
101457 | 23180 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
102906 | 29780 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2000X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2006 12:00:00 AM | 4 | 5x5 | 6006071.7874482 | 2117255.4874462 | 37.7939229310388 | -122.422956286012 | (37.7939229310388, -122.422956286012) | 13 | 9 | 10 | 28858 | 32 | ||
103279 | 113196 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090X 20th St | 1 | Median : Yard | Tree | DPW 1 | 6003325.96697 | 2104184.75857 | 37.7578786248615 | -122.431523525971 | (37.7578786248615, -122.431523525971) | 2 | 4 | 5 | 28862 | 3 | |||||
103538 | 197252 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017782.90663 | 2094656.28102 | 37.7325241508658 | -122.38086245284 | (37.7325241508658, -122.38086245284) | 10 | 3 | 8 | 58 | 1 | |||
104712 | 201665 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6010317.6274 | 2109676.05195 | 37.7733502610444 | -122.407730511973 | (37.7733502610444, -122.407730511973) | 14 | 2 | 9 | 28853 | 34 | ||||
106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
108620 | 23339 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
109059 | 197227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015965.05283 | 2105966.21151 | 37.7634783723591 | -122.38793618463 | (37.7634783723591, -122.38793618463) | 14 | 3 | 8 | 28856 | 29 | |||
109788 | 197230 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015968.5174 | 2105926.2015 | 37.7633687054139 | -122.387921409661 | (37.7633687054139, -122.387921409661) | 14 | 3 | 8 | 28856 | 29 | |||
110186 | 10775 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
110571 | 240362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003721.38231 | 2097581.21775 | 37.7397692466514 | -122.429685041427 | (37.7397692466514, -122.429685041427) | 2 | 7 | 5 | 63 | 7 | |||
111813 | 249489 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | 13 | 9 | 1 | 28858 | 21 | ||||
111989 | 65579 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1990 12:00:00 AM | 4 | Permit Number 28479 | 6016251.26211 | 2097105.49291 | 37.739164539819 | -122.386328462099 | (37.739164539819, -122.386328462099) | 10 | 3 | 8 | 58 | 1 | ||
112325 | 27595 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 8 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
115113 | 10782 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 09:31:00 AM | 3 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | ||
115457 | 197257 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.381742986272 | (37.733193723116, -122.381742986272) | 10 | 3 | 8 | 58 | 1 | |||
116226 | 3658 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 94 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3x3 | 6017265.72601 | 2098814.03291 | 37.7439119466908 | -122.382939742901 | (37.7439119466908, -122.382939742901) | 10 | 3 | 8 | 58 | 1 | |||
116959 | 14878 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
118523 | 251277 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/26/2011 12:00:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
119078 | 23581 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005553.2513401 | 2120985.4040713 | 37.8041350589608 | -122.425015980687 | (37.8041350589608, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | ||
119990 | 179367 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010293.44641 | 2095472.02067 | 37.7343477934225 | -122.406812905791 | (37.7343477934225, -122.406812905791) | 10 | 3 | 7 | 309 | 28 | |||
120167 | 10829 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2006 12:00:00 AM | 3 | 3X4 | 6017900.94101 | 2094609.63801 | 37.7324025921986 | -122.380451134764 | (37.7324025921986, -122.380451134764) | 10 | 3 | 8 | 58 | 1 | ||
121021 | 14957 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 275 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2007 12:00:00 AM | 3 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.383922171933 | (37.7417352694795, -122.383922171933) | 10 | 3 | 8 | 58 | 1 | ||
122943 | 14893 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2008 12:00:00 AM | 3 | 3x3 | 6017107.5762 | 2098575.41356 | 37.7432480069006 | -122.38346998587 | (37.7432480069006, -122.38346998587) | 10 | 3 | 8 | 58 | 1 | ||
125089 | 197271 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016522.12387 | 2097389.36221 | 37.7399589766173 | -122.385411712102 | (37.7399589766173, -122.385411712102) | 10 | 3 | 8 | 58 | 1 | |||
127157 | 15003 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | ||
127393 | 3578 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
129947 | 240359 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 24 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.7602458051206 | -122.428203429952 | (37.7602458051206, -122.428203429952) | 2 | 4 | 5 | 28862 | 3 | |||
131145 | 197237 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016149.20682 | 2103671.84274 | 37.7571887253073 | -122.387139207224 | (37.7571887253073, -122.387139207224) | 10 | 3 | 8 | 28856 | 29 | |||
131442 | 197258 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017525.05376 | 2094913.62104 | 37.7332165209287 | -122.381771813133 | (37.7332165209287, -122.381771813133) | 10 | 3 | 8 | 58 | 1 | |||
132053 | 179369 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010313.94209 | 2095431.38029 | 37.7342373503731 | -122.406739182082 | (37.7342373503731, -122.406739182082) | 10 | 3 | 7 | 309 | 28 | |||
135367 | 251278 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 01/27/2016 09:31:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
135622 | 14987 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | 10 | 3 | 8 | 58 | 1 | ||
135673 | 197272 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016550.5665 | 2097428.77687 | 37.7400687748538 | -122.385316114164 | (37.7400687748538, -122.385316114164) | 10 | 3 | 8 | 58 | 1 | |||
137610 | 23355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/10/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
138232 | 27542 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1390 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | 10 | 3 | 8 | 28856 | 29 | ||
139219 | 15047 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1115 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 6015512.6554 | 2096045.3172 | 37.7362126017611 | -122.388808259867 | (37.7362126017611, -122.388808259867) | 10 | 3 | 8 | 58 | 1 | ||
139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
141560 | 197253 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017800.41079 | 2094649.24699 | 37.7325058028811 | -122.380801447334 | (37.7325058028811, -122.380801447334) | 10 | 3 | 8 | 58 | 1 | |||
144179 | 249478 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | 13 | 9 | 1 | 28858 | 21 | ||||
144344 | 29654 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 13 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015636.0426 | 2096086.4462 | 37.7363323716667 | -122.388384525603 | (37.7363323716667, -122.388384525603) | 10 | 3 | 8 | 58 | 1 | ||
144852 | 179366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010245.15068 | 2095586.70884 | 37.7346600002662 | -122.406987961537 | (37.7346600002662, -122.406987961537) | 10 | 3 | 7 | 309 | 28 | |||
146620 | 197228 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015966.4036 | 2105950.82285 | 37.7634361932415 | -122.387930438833 | (37.7634361932415, -122.387930438833) | 14 | 3 | 8 | 28856 | 29 | |||
147723 | 197229 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015967.79725 | 2105937.55997 | 37.7633998534335 | -122.387924693077 | (37.7633998534335, -122.387924693077) | 14 | 3 | 8 | 28856 | 29 | |||
147785 | 197260 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6017393.35703 | 2095090.62772 | 37.7336952732179 | -122.382239439017 | (37.7336952732179, -122.382239439017) | 10 | 3 | 8 | 58 | 1 |
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) );