trees
286 rows where qSpecies_id = 74 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 210 | 1023 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.438827310136 | (37.7210805620079, -122.438827310136) | 9 | 7 | 6 | 28861 | 25 | |||
| 3254 | 242351 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 387 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005504.19236 | 2101491.23714 | 37.7506060584433 | -122.423798781707 | (37.7506060584433, -122.423798781707) | 2 | 4 | 5 | 28859 | 19 | |||
| 7578 | 136957 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2411 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002488.64673 | 2117068.27748 | 37.7932060642605 | -122.435340887694 | (37.7932060642605, -122.435340887694) | 13 | 9 | 1 | 29490 | 27 | |||
| 9533 | 219459 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992643.39064 | 2095794.64887 | 37.7342302645957 | -122.467857804419 | (37.7342302645957, -122.467857804419) | 9 | 8 | 4 | 59 | 40 | |||
| 13068 | 1286 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3928 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x5 | 5992480.71384 | 2087450.61333 | 37.7113101914743 | -122.467813554168 | (37.7113101914743, -122.467813554168) | 9 | 8 | 4 | 64 | 24 | |||
| 14006 | 19096 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 265 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5994373.4122 | 2087391.66656 | 37.7112574471572 | -122.46126768668 | (37.7112574471572, -122.46126768668) | 9 | 8 | 6 | 28861 | 24 | |||
| 18429 | 219466 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 157 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992652.07452 | 2095558.46871 | 37.7335822742946 | -122.46781060978 | (37.7335822742946, -122.46781060978) | 9 | 8 | 4 | 59 | 40 | |||
| 20327 | 109501 | Private 9 | Ulmus americana :: American Elm 74 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard | Tree | Private 2 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.8021053817179 | -122.404424889694 | (37.8021053817179, -122.404424889694) | 3 | 1 | 10 | 308 | 23 | ||||
| 20422 | 219563 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 468 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993412.01695 | 2099476.55803 | 37.7443842184582 | -122.465467821877 | (37.7443842184582, -122.465467821877) | 1 | 8 | 4 | 29491 | 40 | |||
| 21091 | 242363 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4530 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000946.15042 | 2104663.40742 | 37.7590577062546 | -122.439788225849 | (37.7590577062546, -122.439788225849) | 2 | 4 | 5 | 28862 | 3 | |||
| 22199 | 219513 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992615.42573 | 2096597.10847 | 37.7364320028189 | -122.468012837633 | (37.7364320028189, -122.468012837633) | 1 | 8 | 4 | 59 | 40 | |||
| 22369 | 242359 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 537 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007481.39138 | 2096395.00518 | 37.7367243607425 | -122.41660047944 | (37.7367243607425, -122.41660047944) | 2 | 7 | 7 | 28859 | 2 | |||
| 24193 | 180501 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2019 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6000600.83666 | 2090287.11698 | 37.7195641359612 | -122.439951675834 | (37.7195641359612, -122.439951675834) | 9 | 7 | 6 | 28861 | 25 | |||
| 24542 | 248413 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997910.6761 | 2108085.9087 | 37.7682817800738 | -122.450533022459 | (37.7682817800738, -122.450533022459) | 15 | 5 | 11 | 29492 | 9 | |||
| 26625 | 219522 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 5 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992593.39724 | 2096877.28948 | 37.7372000373399 | -122.468109373561 | (37.7372000373399, -122.468109373561) | 1 | 8 | 4 | 59 | 40 | |||
| 27031 | 219479 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 40 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992572.27413 | 2096608.73557 | 37.7364614358501 | -122.468162875133 | (37.7364614358501, -122.468162875133) | 1 | 8 | 4 | 59 | 40 | |||
| 27534 | 180487 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2079 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000343.28213 | 2090036.11194 | 37.7188602680644 | -122.440823949885 | (37.7188602680644, -122.440823949885) | 9 | 7 | 6 | 28861 | 25 | |||
| 28936 | 219534 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3780 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990464.73851 | 2090861.23093 | 37.7205582924235 | -122.47503001192 | (37.7205582924235, -122.47503001192) | 9 | 8 | 4 | 64 | 40 | |||
| 29168 | 242362 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003143.14835 | 2102033.69016 | 37.7519619384111 | -122.432002187867 | (37.7519619384111, -122.432002187867) | 2 | 4 | 5 | 28862 | 22 | |||
| 31024 | 219567 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 440 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5993560.04517 | 2099487.34762 | 37.7444223802853 | -122.464956758761 | (37.7444223802853, -122.464956758761) | 1 | 8 | 4 | 29491 | 40 | |||
| 32705 | 25438 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2445 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2000 12:00:00 AM | 3 | 3X3 | 6010976.31597 | 2086829.29062 | 37.7106548222305 | -122.403844026987 | (37.7106548222305, -122.403844026987) | 10 | 3 | 8 | 309 | 1 | ||
| 34866 | 242356 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 205 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006761.93151 | 2098429.31569 | 37.7422696353456 | -122.419232232979 | (37.7422696353456, -122.419232232979) | 2 | 7 | 7 | 28859 | 2 | |||
| 34902 | 1084 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2155 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000026.48644 | 2089733.60344 | 37.7180116012293 | -122.441897283559 | (37.7180116012293, -122.441897283559) | 9 | 7 | 6 | 28861 | 25 | |||
| 36726 | 19098 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 277 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994301.47387 | 2087394.14332 | 37.7112601073303 | -122.461516501212 | (37.7112601073303, -122.461516501212) | 9 | 8 | 6 | 28861 | 24 | |||
| 36845 | 219549 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 598 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992707.78967 | 2099421.22358 | 37.7441916430378 | -122.467898847667 | (37.7441916430378, -122.467898847667) | 1 | 8 | 4 | 29491 | 40 | |||
| 37423 | 219564 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 460 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993432.10903 | 2099478.98685 | 37.7443920461633 | -122.465398524625 | (37.7443920461633, -122.465398524625) | 1 | 8 | 4 | 29491 | 40 | |||
| 37886 | 219475 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 20 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992563.48801 | 2096782.78152 | 37.7369388148738 | -122.468205909482 | (37.7369388148738, -122.468205909482) | 1 | 8 | 4 | 59 | 40 | |||
| 38855 | 139051 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2669 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999827.1373 | 2113991.9623 | 37.7846078002996 | -122.444328673472 | (37.7846078002996, -122.444328673472) | 15 | 6 | 11 | 29490 | 31 | |||
| 39345 | 180496 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2067 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000450.00528 | 2090141.8929 | 37.7191567961292 | -122.440462633746 | (37.7191567961292, -122.440462633746) | 9 | 7 | 6 | 28861 | 25 | |||
| 40046 | 215471 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5994846.246 | 2100781.0539 | 37.7480486509235 | -122.460603103871 | (37.7480486509235, -122.460603103871) | 1 | 8 | 4 | 29491 | 40 | |||
| 40895 | 215456 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 170 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992607.47204 | 2095602.74615 | 37.7337012734937 | -122.467968031596 | (37.7337012734937, -122.467968031596) | 9 | 8 | 4 | 59 | 40 | |||
| 40986 | 180508 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2500 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010763.65816 | 2086463.16447 | 37.7096376305352 | -122.404553267433 | (37.7096376305352, -122.404553267433) | 10 | 3 | 8 | 309 | 1 | |||
| 42845 | 19076 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 212 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5994913.18282 | 2087466.94262 | 37.711495187435 | -122.459407564904 | (37.711495187435, -122.459407564904) | 9 | 8 | 6 | 28861 | 24 | |||
| 42941 | 247 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3040 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990628.1224 | 2094940.11862 | 37.7317673641661 | -122.474762808054 | (37.7317673641661, -122.474762808054) | 1 | 8 | 4 | 64 | 40 | |||
| 43891 | 219540 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3020 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5990625.96048 | 2094991.11327 | 37.7319072572925 | -122.47477400284 | (37.7319072572925, -122.47477400284) | 1 | 8 | 4 | 64 | 40 | |||
| 44877 | 215454 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992606.05096 | 2095656.49757 | 37.7338487794048 | -122.467976853054 | (37.7338487794048, -122.467976853054) | 9 | 8 | 4 | 59 | 40 | |||
| 45041 | 219508 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 45 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992618.0664 | 2096466.7402 | 37.7360741967519 | -122.467994227949 | (37.7360741967519, -122.467994227949) | 1 | 8 | 4 | 59 | 40 | |||
| 45245 | 219551 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 570 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992805.02333 | 2099425.24605 | 37.7442083020749 | -122.467562930206 | (37.7442083020749, -122.467562930206) | 1 | 8 | 4 | 29491 | 40 | |||
| 46039 | 1017 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1863 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001211.31639 | 2091358.64779 | 37.7225410511223 | -122.437918182794 | (37.7225410511223, -122.437918182794) | 9 | 7 | 6 | 28861 | 25 | |||
| 47130 | 219492 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 90 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992588.10178 | 2096193.67809 | 37.7353227061853 | -122.468077970135 | (37.7353227061853, -122.468077970135) | 1 | 8 | 4 | 59 | 40 | |||
| 51001 | 180495 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3135 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5996019.45689 | 2086971.09551 | 37.7101972516624 | -122.45554819901 | (37.7101972516624, -122.45554819901) | 9 | 7 | 6 | 28861 | 25 | |||
| 53558 | 19092 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 253 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994541.9924055 | 2087407.5063683 | 37.7113106401579 | -122.46068618252 | (37.7113106401579, -122.46068618252) | 9 | 8 | 6 | 28861 | 24 | |||
| 53584 | 242352 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 63 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005248.95219 | 2104563.63657 | 37.7590277390471 | -122.424899986267 | (37.7590277390471, -122.424899986267) | 2 | 4 | 5 | 28859 | 19 | |||
| 53718 | 219574 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 5993666.81553 | 2099677.65694 | 37.7449510773443 | -122.464601388053 | (37.7449510773443, -122.464601388053) | 1 | 8 | 4 | 29491 | 40 | |||
| 53897 | 219572 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5993729.40272 | 2099508.38123 | 37.7444898968847 | -122.46437268687 | (37.7444898968847, -122.46437268687) | 1 | 8 | 4 | 29491 | 40 | |||
| 53932 | 23637 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 116 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1998 12:00:00 AM | 10 | 3X3 | 6006587.56141 | 2098481.46204 | 37.7424029958148 | -122.419838851803 | (37.7424029958148, -122.419838851803) | 2 | 7 | 7 | 28859 | 2 | ||
| 54037 | 219576 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 215 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5993565.89872 | 2099706.47118 | 37.7450243756816 | -122.464952429427 | (37.7450243756816, -122.464952429427) | 1 | 8 | 4 | 29491 | 40 | |||
| 57205 | 1207 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3141 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5995985.58699 | 2086962.17792 | 37.710170822386 | -122.455664615342 | (37.710170822386, -122.455664615342) | 9 | 7 | 6 | 28861 | 25 | |||
| 60049 | 219560 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 490 Cortes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993227.69053 | 2099492.54719 | 37.7444174879844 | -122.466106340543 | (37.7444174879844, -122.466106340543) | 1 | 8 | 4 | 29491 | 40 | |||
| 60075 | 408 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3830 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2x3 | 5990724.80287 | 2090303.65489 | 37.7190423951686 | -122.474090399377 | (37.7190423951686, -122.474090399377) | 9 | 8 | 4 | 64 | 40 | |||
| 64904 | 19087 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 237 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5994597.47912 | 2087391.16897 | 37.7112689737487 | -122.460493224683 | (37.7112689737487, -122.460493224683) | 9 | 8 | 6 | 28861 | 24 | |||
| 67019 | 219517 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992610.84668 | 2096683.29768 | 37.7366683923157 | -122.468034936661 | (37.7366683923157, -122.468034936661) | 1 | 8 | 4 | 59 | 40 | |||
| 67987 | 219525 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 251 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994459.68695 | 2087392.44193 | 37.7112645410103 | -122.46096955782 | (37.7112645410103, -122.46096955782) | 9 | 8 | 6 | 28861 | 24 | |||
| 70434 | 1210 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5995849.95134 | 2086935.52226 | 37.7100898474467 | -122.456131470508 | (37.7100898474467, -122.456131470508) | 9 | 7 | 6 | 28861 | 25 | |||
| 71098 | 1020 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1871 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6001188.68996 | 2091314.66638 | 37.7224190014148 | -122.437993248302 | (37.7224190014148, -122.437993248302) | 9 | 7 | 6 | 28861 | 25 | |||
| 71750 | 219489 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 72 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992583.96831 | 2096317.04431 | 37.7356612001976 | -122.468101231991 | (37.7356612001976, -122.468101231991) | 1 | 8 | 4 | 59 | 40 | |||
| 74416 | 215464 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 155 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995075.02131 | 2100739.26228 | 37.7479470608168 | -122.459808986296 | (37.7479470608168, -122.459808986296) | 1 | 8 | 4 | 29491 | 40 | |||
| 74552 | 19089 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 245 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994528.08002 | 2087391.0087 | 37.7112645409908 | -122.460733072089 | (37.7112645409908, -122.460733072089) | 9 | 8 | 6 | 28861 | 24 | |||
| 76459 | 219568 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 432 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993595.89147 | 2099490.15845 | 37.7444321649285 | -122.464833014754 | (37.7444321649285, -122.464833014754) | 1 | 8 | 4 | 29491 | 40 | |||
| 76935 | 64409 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 215 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25255 | 6006726.83577731 | 2098456.71661789 | 37.7423428955731 | -122.419355526894 | (37.7423428955731, -122.419355526894) | 2 | 7 | 7 | 28859 | 2 | |
| 77444 | 219580 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 320 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994238.61211 | 2099950.79183 | 37.7457339839424 | -122.462644044196 | (37.7457339839424, -122.462644044196) | 1 | 8 | 4 | 29491 | 40 | |||
| 79202 | 1022 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1909 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000975.40411 | 2090904.61398 | 37.7212809588173 | -122.438701158651 | (37.7212809588173, -122.438701158651) | 9 | 7 | 6 | 28861 | 25 | |||
| 79410 | 215451 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992603.36881 | 2095771.61937 | 37.7341647202147 | -122.467994496876 | (37.7341647202147, -122.467994496876) | 9 | 8 | 4 | 59 | 40 | |||
| 82287 | 1077 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2125 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6000118.83057 | 2089820.59476 | 37.7182557213131 | -122.44158433025 | (37.7182557213131, -122.44158433025) | 9 | 7 | 6 | 28861 | 25 | |||
| 83350 | 215466 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5995052.95095 | 2100968.80441 | 37.7485760565417 | -122.459901929455 | (37.7485760565417, -122.459901929455) | 1 | 8 | 4 | 29491 | 40 | |||
| 83668 | 219470 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 195 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992655.36284 | 2095444.36492 | 37.7332691636304 | -122.467790945215 | (37.7332691636304, -122.467790945215) | 9 | 8 | 4 | 59 | 40 | |||
| 87045 | 1018 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1867 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6001202.49586 | 2091340.5101 | 37.7224907475345 | -122.437947374798 | (37.7224907475345, -122.437947374798) | 9 | 7 | 6 | 28861 | 25 | |||
| 87202 | 219583 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 201 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5993863.59028 | 2099405.60943 | 37.7442154454004 | -122.463901238844 | (37.7442154454004, -122.463901238844) | 1 | 8 | 4 | 29491 | 40 | |||
| 88060 | 219529 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3798 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990509.31034 | 2090609.6806 | 37.7198701806571 | -122.474857591227 | (37.7198701806571, -122.474857591227) | 9 | 8 | 4 | 64 | 40 | |||
| 88369 | 219504 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992624.10653 | 2096354.05467 | 37.7357651393451 | -122.467965151081 | (37.7357651393451, -122.467965151081) | 1 | 8 | 4 | 59 | 40 | |||
| 89582 | 180498 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2059 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000514.10075 | 2090205.66552 | 37.7193355507714 | -122.440245651613 | (37.7193355507714, -122.440245651613) | 9 | 7 | 6 | 28861 | 25 | |||
| 90049 | 19079 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 219 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5994761.18216 | 2087388.38548 | 37.7112707472265 | -122.459927228278 | (37.7112707472265, -122.459927228278) | 9 | 8 | 6 | 28861 | 24 | |||
| 90137 | 219501 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 75 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992625.26831 | 2096281.33572 | 37.7355655384208 | -122.467955846711 | (37.7355655384208, -122.467955846711) | 1 | 8 | 4 | 59 | 40 | |||
| 90190 | 219539 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3774 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990471.08973 | 2090949.21154 | 37.7208002334236 | -122.475014477034 | (37.7208002334236, -122.475014477034) | 9 | 8 | 4 | 64 | 40 | |||
| 91277 | 219497 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 89 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992628.80524 | 2096145.58724 | 37.7351930113401 | -122.46793374764 | (37.7351930113401, -122.46793374764) | 1 | 8 | 4 | 59 | 40 | |||
| 92153 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 74 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.463318866351 | (37.7394838741894, -122.463318866351) | 1 | 8 | 4 | 59 | 40 | ||
| 92510 | 242357 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 619 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007454.61895 | 2096052.89461 | 37.7357834945126 | -122.416668815323 | (37.7357834945126, -122.416668815323) | 2 | 7 | 7 | 28859 | 2 | |||
| 94899 | 407 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3826 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2X3 | 5990704.40844 | 2090329.91237 | 37.7191133102994 | -122.47416280918 | (37.7191133102994, -122.47416280918) | 9 | 8 | 4 | 64 | 40 | |||
| 97722 | 1082 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6000045.94187 | 2089750.00425 | 37.7180577427488 | -122.44183121126 | (37.7180577427488, -122.44183121126) | 9 | 7 | 6 | 28861 | 25 | |||
| 98169 | 1012 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1845 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001257.97709 | 2091441.77631 | 37.7227719565453 | -122.437762838379 | (37.7227719565453, -122.437762838379) | 9 | 7 | 6 | 28861 | 25 | |||
| 98921 | 219557 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993193.55184 | 2099470.33756 | 37.7443545363406 | -122.466222770361 | (37.7443545363406, -122.466222770361) | 1 | 8 | 4 | 29491 | 40 | |||
| 99216 | 1310 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4035 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X6 | 5991848.72186 | 2087031.07112 | 37.7101217158162 | -122.469967330646 | (37.7101217158162, -122.469967330646) | 9 | 8 | 4 | 64 | 24 | |||
| 99530 | 215449 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 120 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992601.94776 | 2095825.37047 | 37.7343122252356 | -122.468003318313 | (37.7343122252356, -122.468003318313) | 9 | 8 | 4 | 59 | 40 | |||
| 102654 | 219550 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 584 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992742.68217 | 2099422.51229 | 37.7441971963417 | -122.467778291755 | (37.7441971963417, -122.467778291755) | 1 | 8 | 4 | 29491 | 40 | |||
| 104999 | 405 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3818 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X5 | 5990665.10533 | 2090381.89852 | 37.719253774519 | -122.474302455007 | (37.719253774519, -122.474302455007) | 9 | 8 | 4 | 64 | 40 | |||
| 105688 | 219511 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 41 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992616.80765 | 2096550.85016 | 37.736305068912 | -122.468004696059 | (37.736305068912, -122.468004696059) | 1 | 8 | 4 | 59 | 40 | |||
| 105716 | 84297 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1369-1369 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52440 | 6008956.5592 | 2109575.0604 | 37.772996675036 | -122.41243151374 | (37.772996675036, -122.41243151374) | 8 | 2 | 9 | 28853 | 34 | |
| 106423 | 219471 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992545.99069 | 2096862.54215 | 37.7371568069404 | -122.468272205699 | (37.7371568069404, -122.468272205699) | 1 | 8 | 4 | 59 | 40 | |||
| 109330 | 242355 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 215 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006802.79352 | 2098409.45176 | 37.7422173946201 | -122.419089535751 | (37.7422173946201, -122.419089535751) | 2 | 7 | 7 | 28859 | 2 | |||
| 115165 | 19054 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 147 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995468.13357 | 2087379.87793 | 37.7112880204961 | -122.457483227074 | (37.7112880204961, -122.457483227074) | 9 | 8 | 6 | 28861 | 24 | |||
| 116673 | 219520 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 15 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992608.23435 | 2096751.02117 | 37.7368541931494 | -122.468048893267 | (37.7368541931494, -122.468048893267) | 1 | 8 | 4 | 59 | 40 | |||
| 116989 | 1313 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X6 | 5991770.79861 | 2086968.57426 | 37.7099456096734 | -122.470232098246 | (37.7099456096734, -122.470232098246) | 9 | 8 | 4 | 64 | 24 | |||
| 119775 | 233 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 5990616.42168 | 2095336.99138 | 37.7328563982031 | -122.474832216845 | (37.7328563982031, -122.474832216845) | 1 | 8 | 4 | 64 | 40 | |||
| 120298 | 1233 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5993343.79351 | 2087539.5057 | 37.7116040683488 | -122.464837007716 | (37.7116040683488, -122.464837007716) | 9 | 8 | 4 | 64 | 24 | |||
| 121628 | 1070 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3X3 | 6000193.5332 | 2089890.50062 | 37.7184519227936 | -122.441331128839 | (37.7184519227936, -122.441331128839) | 9 | 7 | 6 | 28861 | 25 | |||
| 122136 | 1192 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3047 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 1X2 | 5996542.59797 | 2087158.26518 | 37.710741182331 | -122.453753635137 | (37.710741182331, -122.453753635137) | 9 | 7 | 6 | 28861 | 25 | |||
| 122629 | 390 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3790X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2 | 5990465.39673 | 2090774.00996 | 37.7203188434295 | -122.475021373044 | (37.7203188434295, -122.475021373044) | 9 | 8 | 4 | 64 | 40 | |||
| 125573 | 219565 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 456 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993467.92544 | 2099480.37304 | 37.7443979178455 | -122.465274780618 | (37.7443979178455, -122.465274780618) | 1 | 8 | 4 | 29491 | 40 | |||
| 126701 | 180499 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000543.56528 | 2090231.5563 | 37.7194083185059 | -122.440145659613 | (37.7194083185059, -122.440145659613) | 9 | 7 | 6 | 28861 | 25 | |||
| 127045 | 117053 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 5997209.5044 | 2116053.97345 | 37.7901198401005 | -122.453533689754 | (37.7901198401005, -122.453533689754) | 11 | 6 | 1 | 54 | 31 |
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) );