trees
156 rows where qCaretaker_id = 1 and qSpecies_id = 100 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3507 | 91430 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 15419 | 23925 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700X Webster St | 7 | Median : Cutout | Tree | DPW 1 | 60 | 12x1 | 6003454.8844904 | 2114845.825423 | 37.7871586020093 | -122.431838884639 | (37.7871586020093, -122.431838884639) | 13 | 9 | 11 | 29490 | 27 | |||
| 35177 | 13405 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 362 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999656.8275613 | 2097385.3812268 | 37.7390005339934 | -122.443724438614 | (37.7390005339934, -122.443724438614) | 9 | 7 | 4 | 59 | 40 | |||
| 52821 | 91428 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 3 | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | ||
| 57396 | 106550 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 81 MINERVA ST | Median : Cutout | Tree | DPW 1 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 57780 | 12503 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
| 68559 | 91429 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 90168 | 91487 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 750x Brotherhood Way | 21 | Median : Cutout | Tree | DPW 1 | 03/15/2007 12:00:00 AM | 3 | 5991053.474445 | 2088092.036965 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | 1 | 8 | 4 | 64 | 14 | |||
| 101304 | 24281 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 19 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
| 112548 | 3763 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
| 113538 | 11196 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
| 124810 | 107321 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 400X JUNIPERO SERRA BLVD | 4 | Median : Cutout | Tree | DPW 1 | 14 | 5991395 | 2094254 | 37.7299278633008 | -122.47206158935 | (37.7299278633008, -122.47206158935) | 9 | 8 | 4 | 64 | 40 | ||||
| 137658 | 91427 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 146890 | 815 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 600X 39th Ave | 13 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 148969 | 23882 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500X Webster St | 5 | Median : Cutout | Tree | DPW 1 | 20 | 12 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
| 151588 | 11197 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
| 157910 | 16689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 620 Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 2 | 5992122.8128645 | 2103567.9103998 | 37.7555435761415 | -122.470223454796 | (37.7555435761415, -122.470223454796) | 1 | 8 | 4 | 56 | 12 | |||
| 167924 | 23578 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 3100X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005553.2513401 | 2120985.4040713 | 37.8041350589608 | -122.425015980687 | (37.8041350589608, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | |||
| 167995 | 3761 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012458 | 2102979 | 37.7550812343514 | -122.399856259894 | (37.7550812343514, -122.399856259894) | 10 | 3 | 8 | 28856 | 29 | |||
| 173188 | 29631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1110X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | |||
| 174020 | 12499 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
| 176168 | 3760 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1062X Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 20 | 6012453.5755993 | 2103020.9691678 | 37.7551962258659 | -122.399874507795 | (37.7551962258659, -122.399874507795) | 10 | 3 | 8 | 28856 | 29 | ||||
| 182791 | 13404 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 360 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 40 | 5x1000 | 5999647.998558 | 2097391.335153 | 37.7390163784819 | -122.44375539278 | (37.7390163784819, -122.44375539278) | 9 | 7 | 4 | 59 | 40 | |||
| 192591 | 808 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 600X 39th Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 192604 | 24284 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 22 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
| 140163 | 194432 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 900x Carolina St | 64 | Median : Yard | Tree | DPW 1 | 17 | 6012507.9331 | 2102881.18314 | 37.754815434199 | -122.399676708016 | (37.754815434199, -122.399676708016) | 10 | 3 | 8 | 28856 | 29 | ||||
| 169924 | 187279 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 62 | Median : Yard | Tree | DPW 1 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | 1 | 8 | 3 | 29491 | 35 | |||
| 193767 | 251050 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 5800x Geary Blvd | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 5988878.2157 | 2112618.8979 | 37.7802069893248 | -122.482107186669 | (37.7802069893248, -122.482107186669) | 11 | 6 | 2 | 55 | 26 | |||
| 668 | 19865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 798 | 19725 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 874 | 19715 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 1363 | 19612 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 1785 | 19984 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
| 2429 | 19676 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 75 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 2687 | 19642 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 2883 | 19735 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 3041 | 19585 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY4 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 3211 | 19860 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
| 3448 | 19730 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 3770 | 19669 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 68 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 3883 | 19686 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 85 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 4043 | 19724 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 4365 | 19748 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 4379 | 19728 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 4582 | 19867 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 4763 | 19993 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 4839 | 19757 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 4845 | 20011 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 4956 | 19859 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
| 5085 | 19999 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 5469 | 19685 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 84 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 5502 | 19723 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 5560 | 19687 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 86 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 5857 | 19992 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 6036 | 19632 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 6212 | 19719 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 6279 | 19737 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 6354 | 19722 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 6570 | 19989 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
| 6577 | 19937 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY38 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 6893 | 19997 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 6896 | 19756 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 7006 | 19814 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY24 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 7083 | 19857 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
| 7118 | 19620 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30 | |||||||||||||
| 7129 | 19726 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 7444 | 19914 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY35 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
| 7456 | 19682 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 81 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60ST | |||||||||||||
| 7696 | 19727 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 7846 | 19732 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 7883 | 19613 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 7921 | 19736 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 8062 | 19638 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 8572 | 19744 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | -7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
| 8767 | 19662 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 61 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 8828 | 19606 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 8957 | 19624 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 9155 | 19858 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
| 9280 | 19702 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY12 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 9396 | 19915 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY35 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
| 9459 | 19610 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 9917 | 19611 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 10352 | 19743 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | -8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
| 10384 | 19679 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 78 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 10472 | 19659 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 58 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
| 10714 | 19791 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY19 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 20ST | |||||||||||||
| 11089 | 19690 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 89 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 11194 | 19644 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 43 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 11434 | 19648 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 11608 | 20009 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 13138 | 19607 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 13154 | 19625 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 13490 | 19614 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 13544 | 19716 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 14227 | 19634 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 14700 | 19670 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 69 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 14796 | 19621 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 15132 | 19718 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 15362 | 20010 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 15491 | 19647 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST |
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) );