trees
430 rows where qSpecies_id = 99 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
16487 | 19779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 | |||
27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
73351 | 142972 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2010 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6009915.1882 | 2121025.8734 | 37.8044916046862 | -122.409923973004 | (37.8044916046862, -122.409923973004) | 3 | 1 | 10 | 308 | 23 | |||
74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
76840 | 117189 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.7939609578909 | -122.415375111785 | (37.7939609578909, -122.415375111785) | 5 | 1 | 10 | 28858 | 21 | |||
112007 | 39229 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.68496 | 37.793948727108 | -122.415497826087 | (37.793948727108, -122.415497826087) | 5 | 1 | 10 | 28858 | 21 | |
117175 | 142975 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2000 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6009927.4614 | 2120951.259 | 37.8042874199173 | -122.409876230033 | (37.8042874199173, -122.409876230033) | 3 | 1 | 10 | 308 | 23 | |||
123836 | 102615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009946.866 | 2120935.8276 | 37.8042461365953 | -122.409807988636 | (37.8042461365953, -122.409807988636) | 3 | 1 | 10 | 308 | 23 | |||
146878 | 16359 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | 3 | 1 | 10 | 308 | 23 | |||
159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
160279 | 142976 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.8042521996842 | -122.409750018417 | (37.8042521996842, -122.409750018417) | 3 | 1 | 10 | 308 | 23 | |||
174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
172121 | 97504 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
38772 | 58907 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.399409385456 | (37.7108941228427, -122.399409385456) | 10 | 3 | 8 | 309 | 1 | ||
48438 | 26629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | 10 | 3 | 8 | 58 | 1 | ||
56459 | 1867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | 10 | 3 | 8 | 309 | 1 | |||
122123 | 199849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | 10 | 3 | 8 | 58 | 1 | |||
150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
153823 | 199846 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.7266229511494 | -122.393068277245 | (37.7266229511494, -122.393068277245) | 10 | 3 | 8 | 58 | 1 | |||
154944 | 199847 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | 10 | 3 | 8 | 58 | 1 | |||
155029 | 180579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | 10 | 3 | 8 | 309 | 1 | |||
5204 | 7475 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
15951 | 39175 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | 2 | 4 | 7 | 28859 | 19 | |
18105 | 99912 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | ||||
21872 | 7486 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451 | -122.414181457232 | (37.754459046451, -122.414181457232) | 2 | 4 | 7 | 28859 | 19 | |||
22161 | 7482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
31355 | 99913 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768933 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | |||
61984 | 7476 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
70264 | 7477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
75417 | 7464 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.414305992303 | (37.7557526290701, -122.414305992303) | 2 | 4 | 7 | 28859 | 19 | |||
76484 | 7472 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4X4 | 6008329.44308 | 2103061.47825 | 37.7550766717901 | -122.414139883786 | (37.7550766717901, -122.414139883786) | 2 | 4 | 7 | 28859 | 19 | |||
77661 | 7425 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | 2 | 4 | 7 | 28859 | 19 | |||
86222 | 7473 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
129130 | 7479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
132451 | 99911 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005460.7 | 2101331.3 | 37.7501644526018 | -122.423937810125 | (37.7501644526018, -122.423937810125) | 2 | 4 | 5 | 28859 | 19 | ||||
134673 | 7481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
138539 | 7474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
43276 | 215577 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | Width 3ft | 5994760.78175 | 2105295.21675 | 37.7604384740771 | -122.461225807922 | (37.7604384740771, -122.461225807922) | 15 | 5 | 4 | 56 | 12 | |||
45200 | 215576 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 5994736.06961 | 2105294.2713 | 37.7604344559039 | -122.461311206651 | (37.7604344559039, -122.461311206651) | 15 | 5 | 4 | 56 | 12 | |||
50531 | 242796 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 5997883.86583 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | 15 | 5 | 11 | 29492 | 12 | |||
137645 | 215575 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 3ft | 5994715.1652 | 2105292.66043 | 37.76042882975 | -122.461383388048 | (37.76042882975, -122.461383388048) | 15 | 5 | 4 | 56 | 12 | |||
1712 | 105883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | 11 | 6 | 1 | 54 | 31 | ||||
19727 | 1431 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5 | 5995471.94905 | 2115498.24125 | 37.7884941933869 | -122.459505186902 | (37.7884941933869, -122.459505186902) | 11 | 6 | 1 | 54 | 11 | |||
20560 | 82168 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | 11 | 6 | 1 | 54 | 31 | |||||
26096 | 123479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | 11 | 6 | 2 | 54 | 16 | ||||
27899 | 1421 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x12 | 5995527.21204 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | 11 | 6 | 1 | 54 | 31 | |||
30217 | 1529 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165 | (37.7822007565611, -122.45901358165) | 11 | 6 | 2 | 54 | 11 | |||
31067 | 123486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5995665.69022 | 2111872.76649 | 37.7785507478592 | -122.458572325088 | (37.7785507478592, -122.458572325088) | 11 | 6 | 2 | 54 | 16 | ||||
34810 | 137072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5997679.8137 | 2115460.24424 | 37.7885165665196 | -122.451863614513 | (37.7885165665196, -122.451863614513) | 11 | 6 | 1 | 54 | 31 | |||
35862 | 1540 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
43102 | 137067 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | 11 | 6 | 1 | 54 | 31 | |||
44810 | 123491 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5995674.45752 | 2111730.9534 | 37.7781618705542 | -122.458531727532 | (37.7781618705542, -122.458531727532) | 11 | 6 | 2 | 54 | 16 | ||||
46026 | 1477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995501.26357 | 2114653.66128 | 37.7861768902412 | -122.459342576538 | (37.7861768902412, -122.459342576538) | 11 | 6 | 1 | 54 | 11 | |||
47411 | 1433 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5 | 5995535.85964 | 2115388.72149 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | 11 | 6 | 1 | 54 | 31 | |||
48000 | 105881 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5997617.52659 | 2115483.20836 | 37.7885760521994 | -122.452080774722 | (37.7885760521994, -122.452080774722) | 11 | 6 | 1 | 54 | 31 | ||||
48960 | 1645 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 881 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 6X6 | 5995652.78213 | 2110475.54294 | 37.7747135991516 | -122.458515810277 | (37.7747135991516, -122.458515810277) | 11 | 6 | 2 | 54 | 11 | |||
50866 | 1622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 781 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X4 | 5995639.65253 | 2110927.44628 | 37.7759536520848 | -122.458593948432 | (37.7759536520848, -122.458593948432) | 11 | 6 | 2 | 54 | 11 | |||
53519 | 123480 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995658.30802 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | 11 | 6 | 2 | 54 | 16 | ||||
55643 | 123482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | 11 | 6 | 2 | 54 | 16 | ||||
59579 | 123469 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 772 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5995383.36925 | 2110442.32995 | 37.7746069181393 | -122.459445351917 | (37.7746069181393, -122.459445351917) | 11 | 6 | 2 | 54 | 11 | |||
60777 | 1617 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.7758765794073 | -122.458377647589 | (37.7758765794073, -122.458377647589) | 11 | 6 | 2 | 54 | 16 | |||
61047 | 1534 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
61561 | 1440 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | 11 | 6 | 1 | 54 | 31 | |||
64618 | 1441 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | 11 | 6 | 1 | 54 | 31 | |||
66794 | 1428 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.63795 | 2115574.86439 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | 11 | 6 | 1 | 54 | 11 | |||
71394 | 123487 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5995668.73883 | 2111844.87781 | 37.7784743481439 | -122.458559759476 | (37.7784743481439, -122.458559759476) | 11 | 6 | 2 | 54 | 16 | ||||
75188 | 1437 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.7880023578197 | -122.459478767425 | (37.7880023578197, -122.459478767425) | 11 | 6 | 1 | 54 | 11 | |||
80156 | 39243 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | 11 | 6 | 1 | 54 | 31 | |||
84318 | 124687 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995608.47806 | 2113376.19737 | 37.7826754805595 | -122.45887912132 | (37.7826754805595, -122.45887912132) | 11 | 6 | 1 | 54 | 31 | |||
89777 | 1533 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
89935 | 123488 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5995672.61976 | 2111816.69318 | 37.7783971836602 | -122.458544293173 | (37.7783971836602, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | ||||
90221 | 1429 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.54596 | 2115556.47361 | 37.7886537155162 | -122.45953155962 | (37.7886537155162, -122.45953155962) | 11 | 6 | 1 | 54 | 11 | |||
92226 | 137068 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997936.78651 | 2116362.08959 | 37.7910075087313 | -122.45103959183 | (37.7910075087313, -122.45103959183) | 11 | 6 | 1 | 54 | 31 | |||
93403 | 1620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.7760378719372 | -122.458604095826 | (37.7760378719372, -122.458604095826) | 11 | 6 | 2 | 54 | 11 | |||
94324 | 1471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | 11 | 6 | 1 | 54 | 11 | |||
95397 | 123958 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.465590312648 | (37.7830615134244, -122.465590312648) | 11 | 6 | 2 | 54 | 11 | |||
98869 | 1470 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5995496.39039 | 2114788.79173 | 37.7865476418723 | -122.45936922598 | (37.7865476418723, -122.45936922598) | 11 | 6 | 1 | 54 | 11 | |||
100808 | 1541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
107113 | 137069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997939.35301 | 2116349.86097 | 37.7909740791344 | -122.451029829681 | (37.7909740791344, -122.451029829681) | 11 | 6 | 1 | 54 | 31 | |||
107856 | 124694 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995618.45318 | 2113098.44712 | 37.78191342592 | -122.458824496585 | (37.78191342592, -122.458824496585) | 11 | 6 | 1 | 54 | 31 | |||
111676 | 137071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997945.51163 | 2116314.45646 | 37.7908772203684 | -122.451005967078 | (37.7908772203684, -122.451005967078) | 11 | 6 | 1 | 54 | 31 | |||
113204 | 137074 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 4ft | 5997641.85824 | 2115456.61364 | 37.7885044238892 | -122.45199467184 | (37.7885044238892, -122.45199467184) | 11 | 6 | 1 | 54 | 31 | |||
114049 | 1642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.458277318373 | (37.7744643941763, -122.458277318373) | 11 | 6 | 2 | 54 | 16 | |||
115270 | 123484 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5995663.25844 | 2111930.13675 | 37.7787081316253 | -122.458584891633 | (37.7787081316253, -122.458584891633) | 11 | 6 | 2 | 54 | 16 | ||||
126133 | 124686 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995607.11329 | 2113402.43136 | 37.7827474336358 | -122.458885742796 | (37.7827474336358, -122.458885742796) | 11 | 6 | 1 | 54 | 31 | |||
129740 | 1468 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995558.6934 | 2114767.33782 | 37.7864923171366 | -122.459152120252 | (37.7864923171366, -122.459152120252) | 11 | 6 | 1 | 54 | 31 | |||
132043 | 1514 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 4X6 | 5995592.131 | 2113860.45299 | 37.7840041772291 | -122.458970748307 | (37.7840041772291, -122.458970748307) | 11 | 6 | 1 | 54 | 31 | |||
132177 | 1423 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x5 | 5995562.14611 | 2115577.70158 | 37.7887175558035 | -122.459198877421 | (37.7887175558035, -122.459198877421) | 11 | 6 | 1 | 54 | 31 | |||
134973 | 104704 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | 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) );