trees
62 rows where qSpecies_id = 238
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2580 | 222021 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 499X Ogden Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008284.08114 | 2096093.57167 | 37.7359418012563 | -122.413803907119 | (37.7359418012563, -122.413803907119) | 2 | 7 | 7 | 28859 | 2 | |||
| 4378 | 264740 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002718 | 2114518 | 37.7862166771353 | -122.434364894821 | (37.7862166771353, -122.434364894821) | 13 | 9 | 11 | 29490 | 27 | ||||
| 5683 | 222022 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 499X Ogden Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008277.82449 | 2096093.47725 | 37.7359411906319 | -122.413825532246 | (37.7359411906319, -122.413825532246) | 2 | 7 | 7 | 28859 | 2 | |||
| 8573 | 264725 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 136 Addison St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002996 | 2096937 | 37.7379592717499 | -122.432147110586 | (37.7379592717499, -122.432147110586) | 2 | 7 | 5 | 63 | 7 | ||||
| 11191 | 204763 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 15 Mesa Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5993655.2243 | 2100726.83229 | 37.7478311786791 | -122.464717641619 | (37.7478311786791, -122.464717641619) | 1 | 8 | 4 | 29491 | 40 | |||
| 11470 | 222020 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 499X Ogden Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008297.46428 | 2096092.63045 | 37.7359399684425 | -122.413757569564 | (37.7359399684425, -122.413757569564) | 2 | 7 | 7 | 28859 | 2 | |||
| 13873 | 19810 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 100 STAIRWAY24 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 17197 | 19812 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 100 STAIRWAY24 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 21936 | 204760 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2 Mesa Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5993716.16346 | 2100737.36398 | 37.7478636091272 | -122.464507683208 | (37.7478636091272, -122.464507683208) | 1 | 8 | 4 | 29491 | 40 | |||
| 24033 | 183953 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2100 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985069.1522 | 2100584.5154 | 37.7469416676011 | -122.49439693858 | (37.7469416676011, -122.49439693858) | 1 | 8 | 3 | 29491 | 35 | |||
| 25545 | 204762 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 514 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992759.51953 | 2090548.27442 | 37.7198317175461 | -122.467075007517 | (37.7198317175461, -122.467075007517) | 9 | 8 | 6 | 64 | 24 | |||
| 29152 | 258066 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1000X Jamestown Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014011 | 2089680 | 37.7186513820216 | -122.393554786163 | (37.7186513820216, -122.393554786163) | 10 | 3 | 8 | 58 | 1 | ||||
| 30271 | 181429 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1500 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.5007 | 2104844.5838 | 37.7586307029356 | -122.495180100301 | (37.7586307029356, -122.495180100301) | 1 | 8 | 3 | 56 | 35 | |||
| 31211 | 222028 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 190 Storrie St | 9 | Front Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6000755.51268 | 2105304.82476 | 37.7608080280015 | -122.440493543449 | (37.7608080280015, -122.440493543449) | 15 | 4 | 5 | 28862 | 3 | |||
| 32670 | 85929 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1706 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988139.8339 | 2103656.0542 | 37.7555545188612 | -122.484004126341 | (37.7555545188612, -122.484004126341) | 1 | 8 | 3 | 56 | 35 | ||
| 33122 | 184085 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1600 Sunset Blvd | 86 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984928.3026 | 2104071.5069 | 37.7565077440746 | -122.495141070042 | (37.7565077440746, -122.495141070042) | 1 | 8 | 3 | 56 | 35 | |||
| 34717 | 105836 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2100X SLOAT BLVD | 1 | Median : Yard | Tree | DPW 1 | 2 | 5984309 | 2095832 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | 1 | 8 | 3 | 64 | 35 | ||||
| 35984 | 97396 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1203X Sunset Blvd | 15 | Median : Yard | Tree | DPW 1 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.481026569546 | (37.7690686805765, -122.481026569546) | 11 | 6 | 2 | 55 | 8 | |||||
| 36567 | 222029 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 144 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002834.60405 | 2107464.25398 | 37.7668554642406 | -122.433457218072 | (37.7668554642406, -122.433457218072) | 15 | 5 | 5 | 28862 | 3 | |||
| 42149 | 186313 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1800 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984992.9477 | 2102798.4858 | 37.7530161640862 | -122.494823651515 | (37.7530161640862, -122.494823651515) | 1 | 8 | 3 | 56 | 35 | |||
| 44567 | 204764 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 281 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6000236.12204 | 2094924.05091 | 37.73227532195 | -122.441544930949 | (37.73227532195, -122.441544930949) | 9 | 7 | 4 | 63 | 40 | |||
| 45430 | 30424 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 225 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1972 12:00:00 AM | 25 | Permit Number 10489 | 6012257.47083 | 2087577.3317 | 37.7127802853635 | -122.399468524874 | (37.7127802853635, -122.399468524874) | 10 | 3 | 8 | 309 | 1 | ||
| 47275 | 44101 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2900 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2000 12:00:00 AM | 33 | Permit Number 43613 | 5999651.42803 | 2117418.51494 | 37.794006189279 | -122.445183003418 | (37.794006189279, -122.445183003418) | 13 | 9 | 1 | 57 | 27 | ||
| 54033 | 187150 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2301 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.2414 | 2099450.3955 | 37.7438205471232 | -122.494734888113 | (37.7438205471232, -122.494734888113) | 1 | 8 | 3 | 29491 | 35 | |||
| 58949 | 222027 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 310 Liberty St | 60 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003716.89096 | 2103932.15667 | 37.7572071892775 | -122.430153527076 | (37.7572071892775, -122.430153527076) | 2 | 4 | 5 | 28862 | 3 | |||
| 59097 | 186314 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1800 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984957.5078 | 2102814.9976 | 37.7530594263796 | -122.494947425095 | (37.7530594263796, -122.494947425095) | 1 | 8 | 3 | 56 | 35 | |||
| 59630 | 222030 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 35 Mars St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5999601.42077 | 2105598.42745 | 37.7615484047597 | -122.444506122353 | (37.7615484047597, -122.444506122353) | 15 | 5 | 5 | 28862 | 3 | |||
| 60310 | 125575 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1931 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999445.84158 | 2115532.33491 | 37.7888154993698 | -122.445758639673 | (37.7888154993698, -122.445758639673) | 13 | 6 | 1 | 29490 | 31 | |||
| 63525 | 204761 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 179 Ashton Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5994134.44181 | 2091130.30428 | 37.7215090988363 | -122.462364611361 | (37.7215090988363, -122.462364611361) | 9 | 8 | 6 | 28861 | 24 | ||||
| 73989 | 186280 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1800 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985011.8758 | 2102500.8713 | 37.7522001044765 | -122.494736255211 | (37.7522001044765, -122.494736255211) | 1 | 8 | 3 | 56 | 35 | |||
| 80419 | 110144 | Undocumented 4 | Araucaria heterophylla :: Norfolk Island Pine 238 | 129 DE SOTO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 10x10 | 5993256.9 | 2092045.6 | 37.7239717071557 | -122.465464466989 | (37.7239717071557, -122.465464466989) | 9 | 8 | 4 | 59 | 40 | |||
| 82227 | 222019 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 241 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006672.98133 | 2095813.6352 | 37.7350825485248 | -122.419354279976 | (37.7350825485248, -122.419354279976) | 2 | 7 | 7 | 28859 | 2 | |||
| 84168 | 222026 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 47 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000832.93244 | 2104328.85596 | 37.7581326645179 | -122.440155795856 | (37.7581326645179, -122.440155795856) | 2 | 4 | 5 | 28862 | 38 | |||
| 84595 | 185893 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2000 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985001.2813 | 2101166.1106 | 37.7485345971557 | -122.494674497174 | (37.7485345971557, -122.494674497174) | 1 | 8 | 3 | 29491 | 35 | |||
| 91567 | 186279 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1800 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984978.0469 | 2102499.6631 | 37.752194806922 | -122.494853149984 | (37.752194806922, -122.494853149984) | 1 | 8 | 3 | 56 | 35 | |||
| 92586 | 233897 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1021 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003182.00508 | 2102290.73647 | 37.7526699296738 | -122.431886168108 | (37.7526699296738, -122.431886168108) | 2 | 4 | 5 | 28862 | 22 | |||
| 101243 | 222025 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 562 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007847.71054 | 2104641.63316 | 37.7593883456249 | -122.415917749222 | (37.7593883456249, -122.415917749222) | 2 | 4 | 7 | 28859 | 19 | |||
| 108443 | 121475 | Undocumented 4 | Araucaria heterophylla :: Norfolk Island Pine 238 | 705 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5993498 | 2091842 | 37.7234265734559 | -122.464616252006 | (37.7234265734559, -122.464616252006) | 9 | 8 | 4 | 59 | 40 | ||||
| 113758 | 204758 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1696 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5993741.97321 | 2103977.3015 | 37.7567611354409 | -122.464653666529 | (37.7567611354409, -122.464653666529) | 1 | 8 | 4 | 56 | 12 | |||
| 116305 | 117535 | Undocumented 4 | Araucaria heterophylla :: Norfolk Island Pine 238 | 278 JUANITA WAY | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6x3 | 5995559 | 2097690 | 37.7396023643565 | -122.457914790839 | (37.7396023643565, -122.457914790839) | 9 | 7 | 4 | 59 | 40 | |||
| 119364 | 187161 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2301 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984952.2414 | 2099389.4695 | 37.7436535534966 | -122.494713108664 | (37.7436535534966, -122.494713108664) | 1 | 8 | 3 | 29491 | 35 | |||
| 120792 | 184014 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1600 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984965.7137 | 2103757.8086 | 37.7556486055443 | -122.494988561115 | (37.7556486055443, -122.494988561115) | 1 | 8 | 3 | 56 | 35 | |||
| 124365 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 299 Tara St | 1 | Front Yard : Yard | Tree | Private 2 | 5997754 | 2090179.6 | 37.7191064490611 | -122.449784366221 | (37.7191064490611, -122.449784366221) | 9 | 8 | 6 | 28861 | 24 | |||||
| 125509 | 254393 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 150 Granville Way | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994538 | 2098550 | 37.7419049979895 | -122.461507275162 | (37.7419049979895, -122.461507275162) | 1 | 8 | 4 | 59 | 40 | ||||
| 127422 | 86830 | Permitted Site 7 | Araucaria heterophylla :: Norfolk Island Pine 238 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | unpermitted private planting on DPW-maintained street | 6002845 | 2107418 | 37.7667290519071 | -122.43341795454 | (37.7667290519071, -122.43341795454) | 15 | 5 | 5 | 28862 | 3 | ||
| 127643 | 222024 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1000 Jarboe Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009378.65021 | 2096845.36529 | 37.7380674730247 | -122.410072588498 | (37.7380674730247, -122.410072588498) | 10 | 7 | 7 | 28859 | 2 | |||
| 132771 | 112955 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 121X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991652.84779157 | 2095347.0788302 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | 9 | 8 | 4 | 59 | 40 | |||||
| 134637 | 186176 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1700 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984967.0954 | 2103538.8321 | 37.755047437501 | -122.49496763736 | (37.755047437501, -122.49496763736) | 1 | 8 | 3 | 56 | 35 | |||
| 139325 | 185395 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2300 Sunset Blvd | 7 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985077.1425 | 2098975.4486 | 37.7425240740104 | -122.494250726815 | (37.7425240740104, -122.494250726815) | 1 | 8 | 3 | 29491 | 35 | |||
| 146489 | 111205 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 46 COOK ST | Back Yard : Yard | Tree | Private 2 | 36 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514 | 2113392 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | 15 | 6 | 1 | 54 | 31 | ||||
| 148896 | 204759 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2 Mesa Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5993698.72815 | 2100745.29899 | 37.7478843915522 | -122.4645685493 | (37.7478843915522, -122.4645685493) | 1 | 8 | 4 | 29491 | 40 | |||
| 152725 | 187142 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2301 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984897.1125 | 2099461.8744 | 37.7438491307401 | -122.494909065698 | (37.7438491307401, -122.494909065698) | 1 | 8 | 3 | 29491 | 35 | |||
| 152873 | 185423 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2300 Sunset Blvd | 39 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985071.644 | 2099284.3632 | 37.7433719482454 | -122.494292503743 | (37.7433719482454, -122.494292503743) | 1 | 8 | 3 | 29491 | 35 | |||
| 154526 | 183954 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2100 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985054.4746 | 2100602.91 | 37.7469913151738 | -122.494449047407 | (37.7469913151738, -122.494449047407) | 1 | 8 | 3 | 29491 | 35 | |||
| 156330 | 222023 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1000 Jarboe Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009382.55591 | 2096845.28557 | 37.7380674730416 | -122.410059078869 | (37.7380674730416, -122.410059078869) | 10 | 7 | 7 | 28859 | 2 | |||
| 158147 | 185895 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2000 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985036.6346 | 2101201.464 | 37.7486337371523 | -122.494554853688 | (37.7486337371523, -122.494554853688) | 1 | 8 | 3 | 29491 | 35 | |||
| 171942 | 183955 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2100 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985033.6446 | 2100586.6805 | 37.746945534293 | -122.494519878447 | (37.746945534293, -122.494519878447) | 1 | 8 | 3 | 29491 | 35 | |||
| 172915 | 248932 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 46 Cook St | 1 | Front Yard : Yard | Tree | Private 2 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514 | 2113392 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | 15 | 6 | 1 | 54 | 31 | ||||
| 175192 | 187153 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2301 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984906.5006 | 2099427.4325 | 37.7437551121762 | -122.494874065391 | (37.7437551121762, -122.494874065391) | 1 | 8 | 3 | 29491 | 35 | |||
| 178229 | 181401 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1500 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984931.8298 | 2104672.7619 | 37.758158829946 | -122.495173208442 | (37.758158829946, -122.495173208442) | 1 | 8 | 3 | 56 | 35 | |||
| 182090 | 97395 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1203X Sunset Blvd | 14 | Median : Yard | Tree | DPW 1 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.481026569546 | (37.7690686805765, -122.481026569546) | 11 | 6 | 2 | 55 | 8 | |||||
| 189484 | 186055 | DPW Maintained 1 | Araucaria heterophylla :: Norfolk Island Pine 238 | 1901 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984800.4513 | 2102206.1385 | 37.751378471683 | -122.495445647673 | (37.751378471683, -122.495445647673) | 1 | 8 | 3 | 29491 | 35 |
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) );