Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175786 | 175786 | 129207 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000907.81607 | 2117333.5843599997 | 37.7938446251929 | -122.440829689342 | (37.7938446251929, -122.440829689342) | |||
176585 | 176585 | 129209 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000909.22566 | 2117310.8698 | 37.793782337235 | -122.440823181871 | (37.793782337235, -122.440823181871) | |||
187969 | 187969 | 129213 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000915.059280001 | 2117274.38469 | 37.793682490900295 | -122.440800378652 | (37.7936824909003, -122.440800378652) | |||
175383 | 175383 | 226978 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Thor Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 2ft | 6002261.072480001 | 2096075.82305 | 37.735552982986604 | -122.43462655258499 | (37.7355529829866, -122.434626552585) | |||
77087 | 77087 | 219288 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6000650.92821 | 2094383.0916900001 | 37.730813597150394 | -122.44007207888399 | (37.7308135971504, -122.440072078884) | |||
130697 | 130697 | 176632 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.713012287961604 | -122.43857351247499 | (37.7130122879616, -122.438573512475) | |||
148159 | 148159 | 176631 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000945.59643 | 2087907.6965599998 | 37.7130504003174 | -122.438589570763 | (37.7130504003174, -122.438589570763) | |||
183779 | 183779 | 176633 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000954.59421 | 2087879.4605599998 | 37.7129733823892 | -122.43855644963399 | (37.7129733823892, -122.438556449634) | |||
41521 | 41521 | 176750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007642.23896 | 2092919.3671799998 | 37.7271900586719 | -122.415798324654 | (37.7271900586719, -122.415798324654) | |||
47542 | 47542 | 176748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007695.086519999 | 2092935.46015 | 37.7272372173175 | -122.4156167695 | (37.7272372173175, -122.4156167695) | |||
157465 | 157465 | 176747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007704.15527 | 2092938.2985599998 | 37.727245520749996 | -122.415585619676 | (37.72724552075, -122.415585619676) | |||
181535 | 181535 | 176749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007680.78535 | 2092930.6972 | 37.7272233353724 | -122.415665871602 | (37.7272233353724, -122.415665871602) | |||
35777 | 35777 | 226865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004824.42349 | 2096711.0552700001 | 37.7374423749661 | -122.425809268297 | (37.7374423749661, -122.425809268297) | ||||
160249 | 160249 | 176746 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007710.95347 | 2092879.86068 | 37.727085445019 | -122.41555798262199 | (37.727085445019, -122.415557982622) | |||
167033 | 167033 | 176745 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Felton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007704.97473 | 2092878.5606200001 | 37.7270815392649 | -122.415578559099 | (37.7270815392649, -122.415578559099) | |||
65642 | 65642 | 129304 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005981.054409999 | 2120675.3317400003 | 37.8033078358583 | -122.423513477178 | (37.8033078358583, -122.423513477178) | |||
145227 | 145227 | 129303 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005974.10733 | 2120674.6115 | 37.8033054661475 | -122.423537466584 | (37.8033054661475, -122.423537466584) | |||
31573 | 31573 | 129332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007563.684280001 | 2119863.77685 | 37.8011687120311 | -122.417979152724 | (37.8011687120311, -122.417979152724) | ||||
52800 | 52800 | 129325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007543.5223900005 | 2119858.96336 | 37.801154360655 | -122.41804858037399 | (37.801154360655, -122.418048580374) | ||||
60902 | 60902 | 129330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007557.40785 | 2119862.6523599997 | 37.8011652712212 | -122.41800079219601 | (37.8011652712212, -122.418000792196) | ||||
65360 | 65360 | 129326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007546.3898 | 2119859.39883 | 37.801155717731 | -122.41803868875401 | (37.801155717731, -122.418038688754) | ||||
74501 | 74501 | 129333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007566.1830400005 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | ||||
169303 | 169303 | 129327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007552.17158 | 2119860.88653 | 37.801160127991295 | -122.41801878675899 | (37.8011601279913, -122.418018786759) | ||||
170842 | 170842 | 129329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007555.7240699995 | 2119861.47467 | 37.8011619428155 | -122.41800653528601 | (37.8011619428155, -122.418006535286) | ||||
171563 | 171563 | 129328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007553.95221 | 2119861.40094 | 37.8011616406485 | -122.418012661478 | (37.8011616406485, -122.418012661478) | ||||
179802 | 179802 | 129331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.41798625015899 | (37.8011675015458, -122.417986250159) | ||||
80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
38742 | 38742 | 219285 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 111 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6001314.21471 | 2094602.6455299999 | 37.7314541797466 | -122.437794714872 | (37.7314541797466, -122.437794714872) | |||
66556 | 66556 | 219287 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 111 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6001326.643759999 | 2094602.07863 | 37.731453329911 | -122.437751704786 | (37.731453329911, -122.437751704786) | |||
180198 | 180198 | 219286 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 111 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001317.511390001 | 2094602.44592 | 37.731453819121 | -122.437783303355 | (37.731453819121, -122.437783303355) | |||
185547 | 185547 | 176629 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1111 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 1ft | 6000425.60449 | 2090663.4815 | 37.7205875707281 | -122.440584368684 | (37.7205875707281, -122.440584368684) | |||
32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
66377 | 66377 | 129111 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1119 Mason St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6009422.93827 | 2117173.65707 | 37.793886769202 | -122.411355148517 | (37.793886769202, -122.411355148517) | |||
66991 | 66991 | 129110 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1119 Mason St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6009422.36839 | 2117185.06321 | 37.7939180557165 | -122.41135792653 | (37.7939180557165, -122.41135792653) | |||
174326 | 174326 | 226846 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 112 Hoffman Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6000578.445069999 | 2102408.38472 | 37.7528450258792 | -122.44089815384 | (37.7528450258792, -122.44089815384) | |||
132689 | 132689 | 176620 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Desmond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010562.66148 | 2086802.426 | 37.710557939180795 | -122.405271825739 | (37.7105579391808, -122.405271825739) | |||
169737 | 169737 | 176835 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999510.24603 | 2089471.7936200001 | 37.717263300525396 | -122.443662898245 | (37.7172633005254, -122.443662898245) | |||
38642 | 38642 | 176865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001491.17517 | 2087075.7451099998 | 37.7107970662038 | -122.436644357861 | (37.7107970662038, -122.436644357861) | |||
46536 | 46536 | 176864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001508.44833 | 2087074.49051 | 37.710794602952106 | -122.436584568222 | (37.7107946029521, -122.436584568222) | |||
53975 | 53975 | 176753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Silliman St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007374.6218 | 2093318.56752 | 37.7282711282942 | -122.41675174631 | (37.7282711282942, -122.41675174631) | |||
135363 | 135363 | 226899 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1145 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6001369.22419 | 2100311.07223 | 37.7471313127615 | -122.438013280695 | (37.7471313127615, -122.438013280695) | |||
152120 | 152120 | 226900 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1145 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001366.6978400005 | 2100346.1710200002 | 37.747227542030394 | -122.43802453033399 | (37.7472275420304, -122.438024530334) | |||
153438 | 153438 | 129309 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1148 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 6008108.57977 | 2118262.33824 | 37.796802213007105 | -122.41598010012699 | (37.7968022130071, -122.415980100127) | |||
157695 | 157695 | 226982 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 115 Farnum St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002429.92017 | 2097402.7184900003 | 37.739205915807204 | -122.43413760826901 | (37.7392059158072, -122.434137608269) | |||
179914 | 179914 | 226983 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 115 Farnum St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002427.40541 | 2097410.1517 | 37.7392261829547 | -122.434146834405 | (37.7392261829547, -122.434146834405) | |||
35096 | 35096 | 103483 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 116 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770307 | 6009546.84586 | 2094694.0586599999 | 37.73216987282029 | -122.409339274108 | (37.7321698728203, -122.409339274108) | |
69438 | 69438 | 176704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 116 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6004724.80903 | 2092778.7442400001 | 37.726639497300205 | -122.425873855805 | (37.7266394973002, -122.425873855805) | |||
38511 | 38511 | 245190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1165 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000954.6073 | 2109297.4919 | 37.7717822376068 | -122.440091274084 | (37.7717822376068, -122.440091274084) | |||
151778 | 151778 | 245189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1175 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000936.7356 | 2109295.3643 | 37.77177537830379 | -122.440152940733 | (37.7717753783038, -122.440152940733) | |||
67509 | 67509 | 129357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1181 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006225.24006 | 2120361.15088 | 37.8024589549865 | -122.422646123319 | (37.8024589549865, -122.422646123319) | |||
174140 | 174140 | 49714 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | |
149049 | 149049 | 245188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1185 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000914.1833 | 2109291.5347 | 37.7717635792199 | -122.440230675759 | (37.7717635792199, -122.440230675759) | |||
167059 | 167059 | 176607 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1186 Munich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6001048.8202 | 2087208.00194 | 37.7111350656127 | -122.438182703088 | (37.7111350656127, -122.438182703088) | |||
11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
61910 | 61910 | 245187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1195 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000895.0351 | 2109289.4071 | 37.7717566471657 | -122.44029675786501 | (37.7717566471657, -122.440296757865) | |||
182348 | 182348 | 176744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1198 Burrows St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6007607.863919999 | 2092530.8977400002 | 37.7261214725101 | -122.415889662482 | (37.7261214725101, -122.415889662482) | |||
183016 | 183016 | 190770 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1199 Indiana St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6015070.85795 | 2103044.75282 | 37.7554070963733 | -122.390824762063 | (37.7554070963733, -122.390824762063) | |||
187948 | 187948 | 190769 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1199 Indiana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6015071.47128 | 2103030.97705 | 37.75536930507379 | -122.39082167827499 | (37.7553693050738, -122.390821678275) | |||
41994 | 41994 | 129117 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6007264.16981 | 2119273.41538 | 37.7995308667162 | -122.418973709394 | (37.7995308667162, -122.418973709394) | ||||
60332 | 60332 | 129310 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007284.92251 | 2119276.14262 | 37.7995395235904 | -122.418902090975 | (37.7995395235904, -122.418902090975) | ||||
64780 | 64780 | 129114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007312.730219999 | 2119281.87279 | 37.79955682294621 | -122.41880627269899 | (37.7995568229462, -122.418806272699) | ||||
149094 | 149094 | 129115 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007304.145280001 | 2119280.40626 | 37.7995523128455 | -122.418835875684 | (37.7995523128455, -122.418835875684) | ||||
155571 | 155571 | 129116 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007272.57871 | 2119275.5487599997 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | ||||
35316 | 35316 | 219317 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5995097.23073 | 2091960.8022599998 | 37.7238448414569 | -122.45909664051001 | (37.7238448414569, -122.45909664051) | |||
147427 | 147427 | 219316 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 1ft | 5995097.3414 | 2091954.20903 | 37.7238267443906 | -122.45909578075899 | (37.7238267443906, -122.459095780759) | |||
153552 | 153552 | 219315 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 5995096.96866 | 2091948.28525 | 37.7238104576833 | -122.459096640518 | (37.7238104576833, -122.459096640518) | |||
37694 | 37694 | 176737 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1201 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007977.54478 | 2091998.9809400002 | 37.7246817190783 | -122.414574069464 | (37.7246817190783, -122.414574069464) | |||
148789 | 148789 | 176736 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1201 Bacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007970.1933699995 | 2091996.7692200001 | 37.724675233151004 | -122.41459932600701 | (37.724675233151, -122.414599326007) | |||
133611 | 133611 | 227022 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 121 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008279.64625 | 2099237.50243 | 37.7445740950309 | -122.41404158626999 | (37.7445740950309, -122.41404158627) | |||
52562 | 52562 | 219270 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1220 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5991777.52525 | 2107074.159 | 37.7651508397576 | -122.47167305767701 | (37.7651508397576, -122.471673057677) | |||
40280 | 40280 | 227021 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008281.58077 | 2099209.78469 | 37.7444980969188 | -122.414032936584 | (37.7444980969188, -122.414032936584) | |||
53740 | 53740 | 176618 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Seneca Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000040.875469999 | 2090086.0119900003 | 37.7189800550644 | -122.441872826471 | (37.7189800550644, -122.441872826471) | |||
29100 | 29100 | 129254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008749.8874699995 | 2117004.3190200003 | 37.7933840364978 | -122.413671993685 | (37.7933840364978, -122.413671993685) | |||
39518 | 39518 | 129245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008845.28336 | 2117017.82608 | 37.79342648000571 | -122.41334287149401 | (37.7934264800057, -122.413342871494) | |||
41273 | 41273 | 129250 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008770.61192 | 2117008.3352099997 | 37.7933962277169 | -122.413600569531 | (37.7933962277169, -122.413600569531) | |||
42298 | 42298 | 129251 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008764.64924 | 2117007.4706200003 | 37.7933935189451 | -122.41362113973 | (37.7933935189451, -122.41362113973) | |||
68725 | 68725 | 129258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008692.2550800005 | 2116996.28885 | 37.7933587511439 | -122.413870838295 | (37.7933587511439, -122.413870838295) | |||
75311 | 75311 | 129260 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6008685.62861 | 2116995.27312 | 37.7933555900526 | -122.413893694545 | (37.7933555900526, -122.413893694545) | |||
76592 | 76592 | 129247 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008814.48296 | 2117013.68703 | 37.7934133858622 | -122.413449150677 | (37.7934133858622, -122.413449150677) | |||
134450 | 134450 | 129249 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008800.58358 | 2117012.32673 | 37.7934088703826 | -122.413497147472 | (37.7934088703826, -122.413497147472) | |||
148301 | 148301 | 129259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6008689.11536 | 2116996.18865 | 37.7933582996916 | -122.413881694895 | (37.7933582996916, -122.413881694895) | |||
148928 | 148928 | 129252 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008758.83473 | 2117005.78057 | 37.793388551979106 | -122.41364113883499 | (37.7933885519791, -122.413641138835) | |||
150065 | 150065 | 129248 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008805.87601 | 2117012.71209 | 37.793410225651 | -122.413478862478 | (37.793410225651, -122.413478862478) | |||
153761 | 153761 | 129246 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6008836.329390001 | 2117016.03579 | 37.7934210615862 | -122.413373726336 | (37.7934210615862, -122.413373726336) | |||
165846 | 165846 | 129253 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008753.35741 | 2117004.41248 | 37.7933844879676 | -122.413659994014 | (37.7933844879676, -122.413659994014) | |||
173163 | 173163 | 129257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008696.73194 | 2116997.18381 | 37.793361459904794 | -122.413855411325 | (37.7933614599048, -122.413855411325) | |||
175954 | 175954 | 129256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008702.68791 | 2116997.72001 | 37.793363266662205 | -122.413834841121 | (37.7933632666622, -122.413834841121) | |||
184651 | 184651 | 129255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008722.7354 | 2117000.9275700003 | 37.7933731996641 | -122.41376570212799 | (37.7933731996641, -122.413765702128) | |||
132065 | 132065 | 226896 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1243 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006432.373930001 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | |||
40509 | 40509 | 176735 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.41523534004101 | (37.7245113883837, -122.415235340041) | |||
131766 | 131766 | 176734 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.41525670432699 | (37.7245056282085, -122.415256704327) | |||
25043 | 25043 | 190777 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1250 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6014189.92463 | 2104827.29978 | 37.760252667849706 | -122.393996098953 | (37.7602526678497, -122.393996098953) | |||
40088 | 40088 | 190778 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1250 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6014183.521930001 | 2104826.5276900004 | 37.760250192011 | -122.394018188999 | (37.760250192011, -122.394018188999) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");