trees
80 rows where qSpecies_id = 271
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4008 | 97371 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 7 | Median : Cutout | Tree | DPW 1 | 4 | 6007032.43934 | 2118047.04081 | 37.796150498594 | -122.419688519305 | (37.796150498594, -122.419688519305) | 5 | 1 | 10 | 28858 | 32 | ||||
| 11505 | 124338 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 129 Palm Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5995877.50801 | 2113523.16179 | 37.7830944660272 | -122.457959037167 | (37.7830944660272, -122.457959037167) | 11 | 6 | 1 | 54 | 31 | |||
| 14309 | 96127 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 690 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010963.14122 | 2091553.23267 | 37.7236250696118 | -122.404221823196 | (37.7236250696118, -122.404221823196) | 10 | 3 | 7 | 309 | 28 | |||
| 17603 | 75990 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.402853834756 | (37.7984395708796, -122.402853834756) | 3 | 1 | 10 | 308 | 23 | ||
| 18363 | 97361 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 2 | Median : Cutout | Tree | DPW 1 | 4 | 6007149.6499 | 2118062.64447 | 37.7961999442141 | -122.41928405374 | (37.7961999442141, -122.41928405374) | 5 | 1 | 10 | 28858 | 32 | ||||
| 20632 | 97374 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 9 | Median : Cutout | Tree | DPW 1 | 3 | 6006998.02946 | 2118043.30969 | 37.7961383154753 | -122.419807319778 | (37.7961383154753, -122.419807319778) | 5 | 1 | 10 | 28858 | 32 | ||||
| 26214 | 97384 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 8 | Median : Cutout | Tree | DPW 1 | 3 | 6006553.08454 | 2118002.88363 | 37.7960022399536 | -122.421344048901 | (37.7960022399536, -122.421344048901) | 13 | 9 | 10 | 28858 | 32 | ||||
| 26883 | 124019 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 266 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991858.13149 | 2113670.9959 | 37.7832686294366 | -122.471875089868 | (37.7832686294366, -122.471875089868) | 11 | 6 | 2 | 54 | 11 | |||
| 29001 | 203437 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 160 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6000362.84265 | 2095254.36068 | 37.7331894944821 | -122.441130519768 | (37.7331894944821, -122.441130519768) | 9 | 7 | 5 | 63 | 40 | |||
| 29560 | 143082 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 439 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010741.1828 | 2120308.1382 | 37.8025671382387 | -122.407014910269 | (37.8025671382387, -122.407014910269) | 3 | 1 | 10 | 308 | 23 | |||
| 29748 | 68127 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 660 Mississippi St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 10 | Permit Number 31877 | 6014100.64379 | 2103945.69247 | 37.7578270029193 | -122.394243157101 | (37.7578270029193, -122.394243157101) | 10 | 3 | 8 | 28856 | 29 | |
| 31517 | 97382 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3 | 6006565.23555 | 2118004.957 | 37.7960086179662 | -122.42130215128 | (37.7960086179662, -122.42130215128) | 13 | 9 | 10 | 28858 | 32 | ||||
| 31655 | 97369 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 4 | Median : Cutout | Tree | DPW 1 | 5 | 6007107.08679 | 2118057.51485 | 37.7961834623584 | -122.419430966986 | (37.7961834623584, -122.419430966986) | 5 | 1 | 10 | 28858 | 32 | ||||
| 34469 | 125414 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 2900 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000746.16024 | 2115895.0696 | 37.7898856314688 | -122.441285768832 | (37.7898856314688, -122.441285768832) | 13 | 6 | 1 | 29490 | 27 | |||
| 35377 | 220509 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 850 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006243.62087 | 2104590.39556 | 37.7591573457607 | -122.421461846614 | (37.7591573457607, -122.421461846614) | 2 | 4 | 5 | 28859 | 19 | |||
| 36553 | 97380 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3 | 6006631.83733 | 2118013.16955 | 37.7960349222286 | -122.421072279161 | (37.7960349222286, -122.421072279161) | 13 | 9 | 10 | 28858 | 32 | ||||
| 40848 | 125415 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 3014 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000214.54146 | 2116147.89897 | 37.7905495370722 | -122.443143281638 | (37.7905495370722, -122.443143281638) | 13 | 6 | 1 | 29490 | 27 | |||
| 41939 | 97362 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1263X Broadway | 1 | Median : Cutout | Tree | DPW 1 | 5 | 6007524.81802 | 2118113.46193 | 37.7963605982258 | -122.417989496739 | (37.7963605982258, -122.417989496739) | 5 | 1 | 10 | 28858 | 32 | ||||
| 42119 | 220506 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 392 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009942.5587 | 2098860.14349 | 37.7436312080086 | -122.408264931397 | (37.7436312080086, -122.408264931397) | 2 | 7 | 7 | 28859 | 2 | |||
| 42202 | 220519 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 426 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003571.1013 | 2105783.188 | 37.76228142056 | -122.43078981631 | (37.76228142056, -122.43078981631) | 15 | 4 | 5 | 28862 | 3 | |||
| 43570 | 220521 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 202 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002675.1367 | 2104694.01512 | 37.7592400114427 | -122.433810765858 | (37.7592400114427, -122.433810765858) | 2 | 4 | 5 | 28862 | 3 | |||
| 43821 | 65921 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1173 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1990 12:00:00 AM | 5 | Permit Number 28937 | 6009456.04181 | 2110921.53262 | 37.7767217897184 | -122.410798846794 | (37.7767217897184, -122.410798846794) | 8 | 2 | 9 | 28853 | 34 | ||
| 46602 | 189118 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1129 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009697.3697 | 2111155.80547 | 37.7773785762935 | -122.409980560854 | (37.7773785762935, -122.409980560854) | 8 | 2 | 9 | 28853 | 34 | |||
| 47741 | 97385 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 9 | Median : Cutout | Tree | DPW 1 | 3 | 6006527.03038 | 2118000.68045 | 37.7959947216224 | -122.42143404497 | (37.7959947216224, -122.42143404497) | 13 | 9 | 10 | 28858 | 32 | ||||
| 55497 | 97381 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6006582.71632 | 2118007.67098 | 37.7960170553922 | -122.421241857125 | (37.7960170553922, -122.421241857125) | 13 | 9 | 10 | 28858 | 32 | ||||
| 56441 | 110584 | Undocumented 4 | Acer saccharinum :: Silver Maple 271 | 1850 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x13 | 5997708 | 2108904 | 37.7705164467869 | -122.45129306486 | (37.7705164467869, -122.45129306486) | 15 | 5 | 11 | 29492 | 9 | ||||
| 59592 | 57247 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1245 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 7 | Permit Number 14536 | 6007770.10234 | 2091944.12999 | 37.7245194534815 | -122.415287292998 | (37.7245194534815, -122.415287292998) | 9 | 3 | 7 | 309 | 28 | ||
| 60803 | 203431 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6000899.9259 | 2094326.75595 | 37.7306730843802 | -122.439207219743 | (37.7306730843802, -122.439207219743) | 9 | 7 | 4 | 63 | 40 | |||
| 60997 | 57740 | Permitted Site 7 | Acer saccharinum :: Silver Maple 271 | 267 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1976 12:00:00 AM | Permit Number 16658 | 6004969.3 | 2106830.6 | 37.7652364829248 | -122.426028535165 | (37.7652364829248, -122.426028535165) | 8 | 4 | 5 | 28853 | 19 | |||
| 61412 | 220518 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 18 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003295.40043 | 2105669.58781 | 37.7619538775816 | -122.43173525019 | (37.7619538775816, -122.43173525019) | 15 | 4 | 5 | 28862 | 3 | |||
| 64959 | 97360 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 1 | Median : Cutout | Tree | DPW 1 | 4 | 6007166.97772 | 2118064.11604 | 37.796204960647 | -122.419224200263 | (37.796204960647, -122.419224200263) | 5 | 1 | 10 | 28858 | 32 | ||||
| 65917 | 203433 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6000916.87895 | 2094326.94897 | 37.7306745790528 | -122.439148624412 | (37.7306745790528, -122.439148624412) | 9 | 7 | 4 | 63 | 40 | |||
| 72895 | 125418 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401x Broadway | 4 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6006653.67621 | 2118015.97458 | 37.7960438552017 | -122.420996911482 | (37.7960438552017, -122.420996911482) | 13 | 9 | 10 | 28858 | 32 | |||
| 75852 | 203429 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6000879.97236 | 2094326.89698 | 37.7306723361569 | -122.439276212137 | (37.7306723361569, -122.439276212137) | 9 | 7 | 4 | 63 | 40 | |||
| 80267 | 97364 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 3 | Median : Cutout | Tree | DPW 1 | 4 | 6007127.58515 | 2118060.22624 | 37.7961920616707 | -122.419360230794 | (37.7961920616707, -122.419360230794) | 5 | 1 | 10 | 28858 | 32 | ||||
| 81262 | 203436 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992419.85701 | 2096912.89391 | 37.7372877743081 | -122.468711966092 | (37.7372877743081, -122.468711966092) | 1 | 8 | 4 | 59 | 40 | |||
| 84696 | 220507 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 815 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6001031.66383 | 2102578.10343 | 37.7533368345295 | -122.439343007499 | (37.7533368345295, -122.439343007499) | 2 | 4 | 5 | 28862 | 22 | |||
| 85482 | 251 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 3063 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 2 | 5990548.37754 | 2094874.72954 | 37.7315832009825 | -122.475033727947 | (37.7315832009825, -122.475033727947) | 1 | 8 | 4 | 64 | 35 | |||
| 85906 | 244225 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1850 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997719.0698 | 2108890.9391 | 37.7704812187397 | -122.451253832438 | (37.7704812187397, -122.451253832438) | 15 | 5 | 11 | 29492 | 9 | |||
| 88269 | 55763 | Permitted Site 7 | Acer saccharinum :: Silver Maple 271 | 390 FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1973 12:00:00 AM | 12 | 2x4 | Permit Number 11798 | 6009952 | 2098902 | 37.7437466655342 | -122.40823523705 | (37.7437466655342, -122.40823523705) | 2 | 7 | 7 | 28859 | 2 | |
| 88640 | 97367 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1263X Broadway | 4 | Median : Cutout | Tree | DPW 1 | 5 | 6007448.14227 | 2118102.63987 | 37.7963265678641 | -122.418254043985 | (37.7963265678641, -122.418254043985) | 5 | 1 | 10 | 28858 | 32 | ||||
| 95035 | 125417 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1265x Broadway | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 6007321.92087 | 2118086.10575 | 37.796274063647 | -122.418689624353 | (37.796274063647, -122.418689624353) | 5 | 1 | 10 | 28858 | 32 | |||
| 95069 | 97378 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3 | 6006692.04041 | 2118019.16357 | 37.7960547738532 | -122.420864390096 | (37.7960547738532, -122.420864390096) | 13 | 9 | 10 | 28858 | 32 | ||||
| 95393 | 220513 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 123 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6006193.91437 | 2102279.62332 | 37.7528096978261 | -122.421469647319 | (37.7528096978261, -122.421469647319) | 2 | 4 | 5 | 28859 | 19 | |||
| 95859 | 203435 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6000931.91363 | 2094326.90958 | 37.7306753263951 | -122.439096644513 | (37.7306753263951, -122.439096644513) | 9 | 7 | 4 | 63 | 40 | |||
| 97517 | 175148 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 684 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010957.34589 | 2091575.72858 | 37.7236865149035 | -122.404243439305 | (37.7236865149035, -122.404243439305) | 10 | 3 | 7 | 309 | 28 | |||
| 98472 | 189120 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 268 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010155.86119 | 2111026.4848 | 37.7770491780218 | -122.408385357803 | (37.7770491780218, -122.408385357803) | 8 | 2 | 9 | 28853 | 34 | |||
| 102017 | 220516 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003882.37363 | 2101221.22219 | 37.7497729723568 | -122.429387908148 | (37.7497729723568, -122.429387908148) | 2 | 4 | 5 | 28862 | 22 | |||
| 108694 | 97379 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 3 | Median : Cutout | Tree | DPW 1 | 3 | 6006673.12303 | 2118017.2022 | 37.7960483221209 | -122.420929708749 | (37.7960483221209, -122.420929708749) | 13 | 9 | 10 | 28858 | 32 | ||||
| 123053 | 566 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 2958 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 18 | 3x3 | 6009133.99064 | 2102185.59813 | 37.7527168590152 | -122.411295643982 | (37.7527168590152, -122.411295643982) | 2 | 4 | 7 | 28859 | 19 | ||
| 127203 | 5102 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 2629 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6002333.77794 | 2096391.64019 | 37.7364242713534 | -122.434397755159 | (37.7364242713534, -122.434397755159) | 2 | 7 | 5 | 63 | 7 | ||
| 127791 | 3017 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 2485X California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002494.78535 | 2115413.76809 | 37.7886635552212 | -122.435201252457 | (37.7886635552212, -122.435201252457) | 13 | 9 | 1 | 29490 | 27 | |||
| 130976 | 97383 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6006760.98709 | 2118021.53262 | 37.7960651646311 | -122.420625988822 | (37.7960651646311, -122.420625988822) | 13 | 9 | 10 | 28858 | 32 | ||||
| 131671 | 97370 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 6 | Median : Cutout | Tree | DPW 1 | 4 | 6007049.26457 | 2118049.56646 | 37.7961583811618 | -122.419630479787 | (37.7961583811618, -122.419630479787) | 5 | 1 | 10 | 28858 | 32 | ||||
| 131873 | 189119 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 268 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010146.42849 | 2111035.7799 | 37.7770741719623 | -122.408418644401 | (37.7770741719623, -122.408418644401) | 8 | 2 | 9 | 28853 | 34 | |||
| 132065 | 203434 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6000925.62299 | 2094326.76777 | 37.7306745790725 | -122.439118382011 | (37.7306745790725, -122.439118382011) | 9 | 7 | 4 | 63 | 40 | |||
| 132536 | 220504 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 425 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005905.75932 | 2107833.83424 | 37.7680440073566 | -122.42286084725 | (37.7680440073566, -122.42286084725) | 8 | 4 | 5 | 28853 | 19 | |||
| 132664 | 220512 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 123 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006192.89167 | 2102262.56952 | 37.7527628143525 | -122.421471972969 | (37.7527628143525, -122.421471972969) | 2 | 4 | 5 | 28859 | 19 | |||
| 134228 | 220522 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 253 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003573.67977 | 2106813.02685 | 37.7651092559997 | -122.43085439661 | (37.7651092559997, -122.43085439661) | 8 | 4 | 5 | 28862 | 3 | |||
| 140715 | 97368 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 5 | Median : Cutout | Tree | DPW 1 | 4 | 6007088.45417 | 2118056.33113 | 37.7961791626917 | -122.419495355745 | (37.7961791626917, -122.419495355745) | 5 | 1 | 10 | 28858 | 32 | ||||
| 143685 | 220517 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 4 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003501.06849 | 2105680.00758 | 37.7619941438348 | -122.43102466886 | (37.7619941438348, -122.43102466886) | 15 | 4 | 5 | 28862 | 3 | |||
| 146325 | 220511 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 850 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006242.28683 | 2104635.3968 | 37.7592808334555 | -122.421469656308 | (37.7592808334555, -122.421469656308) | 2 | 4 | 5 | 28859 | 19 | |||
| 149339 | 203430 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6000891.5708 | 2094326.6756 | 37.7306723883144 | -122.439236098782 | (37.7306723883144, -122.439236098782) | 9 | 7 | 4 | 63 | 40 | |||
| 149711 | 220505 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 390 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6009947.64853 | 2098867.97047 | 37.7436529841995 | -122.40824788385 | (37.7436529841995, -122.40824788385) | 2 | 7 | 7 | 28859 | 2 | |||
| 150417 | 189117 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 801 Arkansas St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013044.69991 | 2103780.15916 | 37.7573137337465 | -122.397883464349 | (37.7573137337465, -122.397883464349) | 10 | 3 | 8 | 28856 | 29 | ||||
| 154128 | 97373 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1351X Broadway | 8 | Median : Cutout | Tree | DPW 1 | 4 | 6007014.57143 | 2118044.79728 | 37.7961433318917 | -122.419750186728 | (37.7961433318917, -122.419750186728) | 5 | 1 | 10 | 28858 | 32 | ||||
| 158302 | 97363 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1263X Broadway | 2 | Median : Cutout | Tree | DPW 1 | 4 | 6007504.85482 | 2118111.0383 | 37.7963528199735 | -122.418058401889 | (37.7963528199735, -122.418058401889) | 5 | 1 | 10 | 28858 | 32 | ||||
| 159872 | 97365 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1263X Broadway | 3 | Median : Cutout | Tree | DPW 1 | 5 | 6007465.63195 | 2118105.82261 | 37.7963362913309 | -122.418193751644 | (37.7963362913309, -122.418193751644) | 5 | 1 | 10 | 28858 | 32 | ||||
| 164236 | 143081 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 439 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010727.7925 | 2120305.8296 | 37.8025600500749 | -122.407061084811 | (37.8025600500749, -122.407061084811) | 3 | 1 | 10 | 308 | 23 | |||
| 164506 | 220515 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 471 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003333.59929 | 2102700.91879 | 37.7538047859636 | -122.431391207355 | (37.7538047859636, -122.431391207355) | 2 | 4 | 5 | 28862 | 22 | |||
| 168199 | 124339 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 129 Palm Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 4ft | 5995877.44459 | 2113536.3004 | 37.7831305374996 | -122.457960207687 | (37.7831305374996, -122.457960207687) | 11 | 6 | 1 | 54 | 31 | |||
| 170341 | 203428 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6000870.12955 | 2094326.82879 | 37.7306715888014 | -122.439310235275 | (37.7306715888014, -122.439310235275) | 9 | 7 | 4 | 63 | 40 | |||
| 171548 | 220508 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 495 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001547.79633 | 2102968.24451 | 37.7544374266508 | -122.437586055063 | (37.7544374266508, -122.437586055063) | 2 | 4 | 5 | 28862 | 22 | |||
| 172668 | 125416 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1265x Broadway | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 6007342.58792 | 2118088.16107 | 37.7962808706072 | -122.418618257738 | (37.7962808706072, -122.418618257738) | 5 | 1 | 10 | 28858 | 32 | |||
| 172774 | 97377 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6006713.66086 | 2118020.16581 | 37.7960587443728 | -122.420789650134 | (37.7960587443728, -122.420789650134) | 13 | 9 | 10 | 28858 | 32 | ||||
| 177465 | 220523 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 245 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003572.38643 | 2106830.82998 | 37.7651580658134 | -122.430860140593 | (37.7651580658134, -122.430860140593) | 8 | 4 | 5 | 28862 | 3 | |||
| 179518 | 220520 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 4552 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000838.65353 | 2104661.99133 | 37.7590476986102 | -122.440159898579 | (37.7590476986102, -122.440159898579) | 2 | 4 | 5 | 28862 | 3 | |||
| 179828 | 220514 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 4048 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001567.00144 | 2102942.84147 | 37.7543687679287 | -122.4375178199 | (37.7543687679287, -122.4375178199) | 2 | 4 | 5 | 28862 | 22 | |||
| 184195 | 220510 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 850 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006244.58931 | 2104615.56079 | 37.7592264982188 | -122.421460284477 | (37.7592264982188, -122.421460284477) | 2 | 4 | 5 | 28859 | 19 | |||
| 186396 | 203432 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 15 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6000908.66994 | 2094326.57474 | 37.7306730843876 | -122.439176977342 | (37.7306730843876, -122.439176977342) | 9 | 7 | 4 | 63 | 40 |
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) );