trees
891 rows where qSpecies_id = 75 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88374 | 175142 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6009135.1326 | 2093603.39042 | 37.7291520547186 | -122.410685668905 | (37.7291520547186, -122.410685668905) | 9 | 3 | 7 | 309 | 28 | |||
180160 | 24873 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2585 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011029.3172 | 2093570.939 | 37.7291689698102 | -122.404134997931 | (37.7291689698102, -122.404134997931) | 10 | 3 | 7 | 309 | 28 | ||
152115 | 175143 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6009125.76929 | 2093634.7983 | 37.7292377690915 | -122.41072025595 | (37.7292377690915, -122.41072025595) | 9 | 3 | 7 | 309 | 28 | |||
63101 | 175144 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009113.082 | 2093674.90836 | 37.7293471914122 | -122.41076694875 | (37.7293471914122, -122.41076694875) | 9 | 3 | 7 | 309 | 28 | |||
156890 | 25513 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2575 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1996 12:00:00 AM | 6 | 3X4 | 6011006.0969088 | 2093637.3368888 | 37.7293499870717 | -122.404219944137 | (37.7293499870717, -122.404219944137) | 10 | 3 | 7 | 309 | 28 | ||
82230 | 53151 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.386313991736 | (37.7293905172533, -122.386313991736) | 10 | 3 | 8 | 58 | 1 | ||
118713 | 175145 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6009104.5146 | 2093704.47338 | 37.7294278902847 | -122.410798654332 | (37.7294278902847, -122.410798654332) | 9 | 3 | 7 | 309 | 28 | |||
191487 | 53153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.7294326204666 | -122.386379154297 | (37.7294326204666, -122.386379154297) | 10 | 3 | 8 | 58 | 1 | ||
39259 | 24875 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2559 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | 3 | 3x3 | 6010991.1509093 | 2093686.6170284 | 37.7294844648724 | -122.404275081222 | (37.7294844648724, -122.404275081222) | 10 | 3 | 7 | 309 | 28 | ||
25455 | 175146 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009095.72656 | 2093731.386 | 37.7295012938507 | -122.410830935508 | (37.7295012938507, -122.410830935508) | 9 | 3 | 7 | 309 | 28 | |||
80657 | 175147 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009085.10423 | 2093766.47253 | 37.7295970383684 | -122.410870135171 | (37.7295970383684, -122.410870135171) | 9 | 3 | 7 | 309 | 28 | |||
46040 | 82635 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | 10 | 3 | 8 | 58 | 1 | |
84311 | 199868 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016299.0692 | 2093761.868 | 37.7299862626754 | -122.385930158914 | (37.7299862626754, -122.385930158914) | 10 | 3 | 8 | 58 | 1 | |||
24019 | 921 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1252 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 6002917.86629 | 2094183.94733 | 37.730395586884 | -122.432220700641 | (37.730395586884, -122.432220700641) | 9 | 7 | 5 | 28861 | 25 | ||
116252 | 175133 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003358.89864 | 2094334.77609 | 37.7308347249396 | -122.430706749511 | (37.7308347249396, -122.430706749511) | 9 | 7 | 5 | 28861 | 25 | |||
84531 | 903 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 6003354.20402 | 2094344.7552 | 37.7308618593504 | -122.430723691407 | (37.7308618593504, -122.430723691407) | 9 | 7 | 5 | 28861 | 25 | ||
62526 | 24880 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.7308959524537 | -122.404855607729 | (37.7308959524537, -122.404855607729) | 10 | 3 | 7 | 309 | 28 | ||
82452 | 28702 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2459X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6010812.8584984 | 2094273.6948872 | 37.7310864930061 | -122.404932777122 | (37.7310864930061, -122.404932777122) | 10 | 3 | 7 | 309 | 28 | |||
67546 | 887 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1132 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2016 12:00:00 AM | 3 | 3x4 | 6003641.7751 | 2094429.98958 | 37.7311121819822 | -122.429735588731 | (37.7311121819822, -122.429735588731) | 9 | 7 | 5 | 28861 | 25 | ||
153458 | 175139 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 433 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6005888.96871 | 2094415.712 | 37.7311999729009 | -122.421965624336 | (37.7311999729009, -122.421965624336) | 9 | 7 | 6 | 28861 | 5 | |||
179049 | 24854 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2442 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6010724.9783872 | 2094386.6708818 | 37.7313917885461 | -122.405244548084 | (37.7313917885461, -122.405244548084) | 10 | 3 | 7 | 309 | 28 | ||
73926 | 24853 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2434 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2009 12:00:00 AM | 5 | 3x3 | 6010702.6993234 | 2094455.8290061 | 37.7315804365911 | -122.405326439819 | (37.7315804365911, -122.405326439819) | 10 | 3 | 7 | 309 | 28 | ||
7657 | 261508 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2415X San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 01/15/2020 12:00:00 AM | 3 | 3x3 | 6010698 | 2094549 | 37.7318360017619 | -122.405349245342 | (37.7318360017619, -122.405349245342) | 10 | 3 | 7 | 309 | 28 | ||
55314 | 87432 | - 12 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
58024 | 87433 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
152280 | 87429 | - 12 | Acer rubrum :: Red Maple 75 | 500X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006724.46969 | 2094782.06277 | 37.7322529772765 | -122.419103118684 | (37.7322529772765, -122.419103118684) | 2 | 7 | 7 | 28861 | 2 | ||
85799 | 87431 | - 12 | Acer rubrum :: Red Maple 75 | 522X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.7322783147803 | -122.419586279513 | (37.7322783147803, -122.419586279513) | 2 | 7 | 7 | 28861 | 2 | ||
129540 | 87430 | - 12 | Acer rubrum :: Red Maple 75 | 522X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.7322783147803 | -122.419586279513 | (37.7322783147803, -122.419586279513) | 2 | 7 | 7 | 28861 | 2 | ||
164311 | 862 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6008011.36344 | 2095005.68806 | 37.732939390338 | -122.414669840947 | (37.732939390338, -122.414669840947) | 2 | 7 | 7 | 28859 | 2 | |||
182793 | 861 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.414585408098 | (37.7329747750588, -122.414585408098) | 2 | 7 | 7 | 28859 | 2 | ||
1240 | 860 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902 | 2095033.66744 | 37.7330190549875 | -122.414497094675 | (37.7330190549875, -122.414497094675) | 2 | 7 | 7 | 28859 | 2 | ||
59756 | 24849 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2354 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2011 12:00:00 AM | 3 | 2x2 | 6010506.72758 | 2094990.75244 | 37.7330382644924 | -122.40604162653 | (37.7330382644924, -122.40604162653) | 10 | 3 | 7 | 309 | 28 | ||
69441 | 24848 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2354 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/2013 12:00:00 AM | 3 | 3x3 | 6010497.60503 | 2095014.35127 | 37.7331025516429 | -122.406074827698 | (37.7331025516429, -122.406074827698) | 10 | 3 | 7 | 309 | 28 | ||
47573 | 854 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008336.69687 | 2095197.29776 | 37.7334837823442 | -122.413558622435 | (37.7334837823442, -122.413558622435) | 10 | 7 | 7 | 28859 | 2 | ||
166034 | 853 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 370 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008364.22406 | 2095210.30794 | 37.7335210511394 | -122.4134643726 | (37.7335210511394, -122.4134643726) | 10 | 7 | 7 | 28859 | 2 | ||
140653 | 852 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 366 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008391.48003 | 2095227.15251 | 37.7335688330362 | -122.413371331432 | (37.7335688330362, -122.413371331432) | 10 | 7 | 7 | 28859 | 2 | ||
121975 | 256175 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 1493 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015764 | 2095228 | 37.7339823414442 | -122.387882237671 | (37.7339823414442, -122.387882237671) | 10 | 3 | 8 | 58 | 1 | ||||
101528 | 24842 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 200X Alemany Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/12/1996 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 | ||
145085 | 24838 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 200X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/12/1996 12:00:00 AM | 6 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 | ||
154722 | 24846 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 200X Alemany Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/29/1998 12:00:00 AM | 3 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 | ||
62245 | 220472 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 100 Alemany Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009413.9185 | 2095926.46105 | 37.7355463369948 | -122.409885800206 | (37.7355463369948, -122.409885800206) | 10 | 7 | 7 | 28859 | 2 | |||
192151 | 220471 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 100 Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009494.82238 | 2095997.42417 | 37.7357457202871 | -122.4096110906 | (37.7357457202871, -122.4096110906) | 10 | 7 | 7 | 28859 | 2 | |||
127762 | 220486 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 80 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005005.11226 | 2096160.19532 | 37.7359400466934 | -122.425145357279 | (37.7359400466934, -122.425145357279) | 2 | 7 | 5 | 28859 | 2 | |||
95440 | 220470 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009551.6866 | 2096070.24779 | 37.7359488645495 | -122.409419625821 | (37.7359488645495, -122.409419625821) | 10 | 7 | 7 | 28859 | 2 | |||
39683 | 203406 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994466.0383 | 2096440.37443 | 37.7361083476053 | -122.461603176966 | (37.7361083476053, -122.461603176966) | 9 | 8 | 4 | 59 | 40 | |||
37037 | 203405 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.7361875994652 | -122.461723432511 | (37.7361875994652, -122.461723432511) | 9 | 8 | 4 | 59 | 40 | |||
181942 | 203404 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994396.0657 | 2096501.56524 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | 9 | 8 | 4 | 59 | 40 | |||
190387 | 203403 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779897 | -122.461902813967 | (37.736316779897, -122.461902813967) | 9 | 8 | 4 | 59 | 40 | |||
111084 | 203424 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994267.45762 | 2096626.89262 | 37.7366090478713 | -122.462303269505 | (37.7366090478713, -122.462303269505) | 9 | 8 | 4 | 59 | 40 | |||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
158024 | 203425 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.462374467911 | (37.7366518402943, -122.462374467911) | 9 | 8 | 4 | 59 | 40 | |||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
123391 | 27172 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2240 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012891.71047 | 2096272.40031 | 37.7366905093537 | -122.397885929388 | (37.7366905093537, -122.397885929388) | 10 | 3 | 8 | 58 | 1 | ||
28189 | 203426 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | 9 | 8 | 4 | 59 | 40 | |||
118016 | 187901 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2240 Silver Ave | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6012923.64855 | 2096289.98894 | 37.7367405826988 | -122.397776738211 | (37.7367405826988, -122.397776738211) | 10 | 3 | 8 | 58 | 1 | |||
114925 | 203427 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 101 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994083.74487 | 2096763.21793 | 37.7369727831569 | -122.462948326201 | (37.7369727831569, -122.462948326201) | 9 | 8 | 4 | 59 | 40 | |||
183750 | 203414 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993945.56402 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | 1 | 8 | 4 | 59 | 40 | |||
136974 | 203415 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 95 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993910.70196 | 2096889.90147 | 37.7373106557719 | -122.463555799377 | (37.7373106557719, -122.463555799377) | 1 | 8 | 4 | 59 | 40 | |||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
42705 | 203416 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993822.50089 | 2096951.15994 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | 1 | 8 | 4 | 59 | 40 | |||
139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
54765 | 203417 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993769.49059 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | 1 | 8 | 4 | 59 | 40 | |||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
13427 | 208966 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 44 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 6ft | Permit Number 781880 | 5993637 | 2097007 | 37.7376164050624 | -122.464510605988 | (37.7376164050624, -122.464510605988) | 1 | 8 | 4 | 59 | 40 | |
109537 | 203418 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993705.93526 | 2097033.15738 | 37.7376922003421 | -122.464274164331 | (37.7376922003421, -122.464274164331) | 1 | 8 | 4 | 59 | 40 | |||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
149763 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584 | 2097045 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | 1 | 8 | 4 | 59 | 40 | |
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
177290 | 203400 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993596.06359 | 2097068.49274 | 37.7377828888614 | -122.464656605522 | (37.7377828888614, -122.464656605522) | 1 | 8 | 4 | 59 | 40 | |||
79164 | 52149 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1566 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48340 | 6015439.23849 | 2096619.2496 | 37.737784433907 | -122.389102155646 | (37.737784433907, -122.389102155646) | 10 | 3 | 8 | 58 | 1 |
19089 | 203401 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.7379196595754 | -122.464927448042 | (37.7379196595754, -122.464927448042) | 1 | 8 | 4 | 59 | 40 | |||
153741 | 203419 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 35 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993568.7451 | 2097128.90388 | 37.7379471878035 | -122.464755443717 | (37.7379471878035, -122.464755443717) | 1 | 8 | 4 | 59 | 40 | |||
146528 | 203402 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | 1 | 8 | 4 | 59 | 40 | |||
6716 | 208999 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5993404.32279 | 2097201.32336 | 37.7381365526709 | -122.465329186907 | (37.7381365526709, -122.465329186907) | 1 | 8 | 4 | 59 | 40 | |||
158008 | 203420 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993455.07316 | 2097218.01136 | 37.7381853004145 | -122.465154930655 | (37.7381853004145, -122.465154930655) | 1 | 8 | 4 | 59 | 40 | |||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
168258 | 203423 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | 1 | 8 | 4 | 59 | 40 | |||
107226 | 203421 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.465343412368 | (37.738293106632, -122.465343412368) | 1 | 8 | 4 | 59 | 40 | |||
77903 | 203422 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993354.86667 | 2097295.22775 | 37.738391538344 | -122.465506999949 | (37.738391538344, -122.465506999949) | 1 | 8 | 4 | 59 | 40 | |||
53535 | 8240 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
61532 | 8222 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
67673 | 8236 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
68723 | 8233 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2008 12:00:00 AM | 4 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
69882 | 8246 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
92237 | 8241 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
109576 | 8245 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
113026 | 8243 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
127164 | 8231 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2008 12:00:00 AM | 2 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
132753 | 8224 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
133963 | 8237 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
139969 | 8239 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
153480 | 8244 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
179722 | 8242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
2867 | 8251 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1515 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2014 12:00:00 AM | 3 | 3x3 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | ||
31808 | 8249 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1515 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 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) );