Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186059 | 186059 | 176678 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000029.196719999 | 2092216.34356 | 37.7248287932952 | -122.442066027838 | (37.7248287932952, -122.442066027838) | |||
134239 | 134239 | 176679 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 233 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6000035.25215 | 2092229.5208400001 | 37.7248653201629 | -122.44204604041401 | (37.7248653201629, -122.442046040414) | |||
39860 | 39860 | 42981 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42865 | 6007925.78486 | 2092082.5600700001 | 37.7249083014575 | -122.414758909799 | (37.7249083014575, -122.414758909799) | |
181861 | 181861 | 176738 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007923.10392 | 2092090.50279 | 37.7249299598378 | -122.414768739387 | (37.7249299598378, -122.414768739387) | |||
132151 | 132151 | 176730 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1533 Burrows St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6006825.48206 | 2092127.1271099998 | 37.724968788961206 | -122.41856569774299 | (37.7249687889612, -122.418565697743) | |||
75189 | 75189 | 176701 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 985 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005395.13627 | 2092229.7099400002 | 37.7251698288036 | -122.42351753851601 | (37.7251698288036, -122.423517538516) | |||
159879 | 159879 | 176598 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 156 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000311.35306 | 2092335.41636 | 37.725171815405 | -122.441099188288 | (37.725171815405, -122.441099188288) | |||
188801 | 188801 | 176786 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 623 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6004279.230330001 | 2092361.41636 | 37.725468416325 | -122.427384490226 | (37.725468416325, -122.427384490226) | |||
58477 | 58477 | 176787 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 623 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6004260.85777 | 2092373.14335 | 37.7254995769251 | -122.427448837605 | (37.7254995769251, -122.427448837605) | |||
151631 | 151631 | 176788 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 623 Avalon Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6004250.53654 | 2092379.21938 | 37.725515676593 | -122.427484949875 | (37.725515676593, -122.427484949875) | |||
159631 | 159631 | 176789 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 623 Avalon Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6004244.364569999 | 2092383.88574 | 37.725528140294706 | -122.427506618137 | (37.7255281402947, -122.427506618137) | |||
136921 | 136921 | 176717 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6004888.08 | 2092410.0187099997 | 37.7256362837854 | -122.425283206255 | (37.7256362837854, -122.425283206255) | |||
167449 | 167449 | 176718 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004890.82087 | 2092414.1622099997 | 37.7256478157716 | -122.42527402599801 | (37.7256478157716, -122.425274025998) | ||||
159523 | 159523 | 34521 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 306 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 11 | Permit Number 38231 | 6006308.04583 | 2092388.1729 | 37.725656419580496 | -122.42037294026301 | (37.7256564195805, -122.420372940263) | ||
27318 | 27318 | 176739 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 318 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007769.14827 | 2092407.95318 | 37.725792959174 | -122.41532341065 | (37.725792959174, -122.41532341065) | |||
172282 | 172282 | 176714 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 705 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005346.258230001 | 2092469.02462 | 37.7258241755184 | -122.42370351291099 | (37.7258241755184, -122.423703512911) | |||
76033 | 76033 | 176729 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 716 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6005232.66037 | 2092475.7517799998 | 37.725836233649204 | -122.424096691117 | (37.7258362336492, -122.424096691117) | |||
178993 | 178993 | 176605 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 130 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004857.577219999 | 2092487.3152599998 | 37.725846799774295 | -122.42539415022101 | (37.7258467997743, -122.425394150221) | |||
75442 | 75442 | 176715 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 705 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005335.89523 | 2092477.4819 | 37.7258468123661 | -122.42373993816099 | (37.7258468123661, -122.423739938161) | |||
151579 | 151579 | 176716 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 705 Peru Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6005325.08691 | 2092482.57544 | 37.7258601879707 | -122.42377766380501 | (37.7258601879707, -122.423777663805) | |||
137159 | 137159 | 176604 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 130 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004860.94165 | 2092492.2162799998 | 37.7258604469822 | -122.42538286823401 | (37.7258604469822, -122.425382868234) | |||
26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
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) | |||
50670 | 50670 | 176726 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1835 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005342.6627 | 2092636.32324 | 37.726283337880204 | -122.4237278324 | (37.7262833378802, -122.4237278324) | |||
43522 | 43522 | 176727 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1835 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005346.06759 | 2092637.3763400002 | 37.7262864216673 | -122.42371613669901 | (37.7262864216673, -122.423716136699) | |||
173847 | 173847 | 176705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1401 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6006823.022419999 | 2092609.75352 | 37.7262938383673 | -122.418608409274 | (37.7262938383673, -122.418608409274) | |||
41457 | 41457 | 176706 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1401 Felton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6006831.721390001 | 2092612.75382 | 37.726302566288794 | -122.41857854996799 | (37.7263025662888, -122.418578549968) | |||
29588 | 29588 | 176728 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1831 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005368.22996 | 2092645.7174900002 | 37.726310575669295 | -122.423640115208 | (37.7263105756693, -122.423640115208) | |||
170635 | 170635 | 176707 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1401 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6006843.42712 | 2092615.8795 | 37.72631180774329 | -122.418538305298 | (37.7263118077433, -122.418538305298) | |||
75626 | 75626 | 176708 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1401 Felton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6006850.40238 | 2092617.2323 | 37.7263159149285 | -122.418514287999 | (37.7263159149285, -122.418514287999) | |||
185451 | 185451 | 176846 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 211 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007213.98461 | 2092669.27766 | 37.7264792821724 | -122.417261085441 | (37.7264792821724, -122.417261085441) | |||
156529 | 156529 | 176742 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 211 Yale St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007220.84371 | 2092671.6034099997 | 37.7264860540731 | -122.41723753849399 | (37.7264860540731, -122.417237538494) | |||
131673 | 131673 | 201354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6012921.134769999 | 2092559.31371 | 37.726496777601795 | -122.39752386145099 | (37.7264967776018, -122.397523861451) | |||
70140 | 70140 | 176743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 205 Yale St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007217.079390001 | 2092679.28575 | 37.7265069363429 | -122.417251095779 | (37.7265069363429, -122.417251095779) | |||
154484 | 154484 | 201353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.39758340285101 | (37.7265081621175, -122.397583402851) | |||
168356 | 168356 | 201352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012884.58431 | 2092567.5936099999 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | |||
135032 | 135032 | 201351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012866.15074 | 2092573.2448900002 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | |||
137282 | 137282 | 176740 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1317 Felton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6007103.92835 | 2092695.04715 | 37.726543847220505 | -122.41764337194999 | (37.7265438472205, -122.41764337195) | |||
149516 | 149516 | 201350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.726546458834896 | -122.397780348078 | (37.7265464588349, -122.397780348078) | |||
74667 | 74667 | 176741 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1317 Felton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6007115.86564 | 2092698.24155 | 37.7265532900755 | -122.41760233140499 | (37.7265532900755, -122.417602331405) | |||
38919 | 38919 | 201349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774058998 | (37.7265656062986, -122.39784774059) | |||
156014 | 156014 | 176725 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Silliman St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005473.28472 | 2092736.57942 | 37.72656599212729 | -122.423283401813 | (37.7265659921273, -122.423283401813) | |||
25718 | 25718 | 176724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Silliman St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005480.83826 | 2092738.2956599998 | 37.7265711308422 | -122.423257411423 | (37.7265711308422, -122.423257411423) | |||
161697 | 161697 | 176723 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Silliman St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6005486.7046300005 | 2092740.2339299999 | 37.726576783980605 | -122.423237269297 | (37.7265767839806, -122.423237269297) | |||
177390 | 177390 | 201348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012808.60563 | 2092591.5632900002 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | |||
34438 | 34438 | 176721 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005098.35657 | 2092750.06265 | 37.7265818471717 | -122.42458047420799 | (37.7265818471717, -122.424580474208) | ||||
149203 | 149203 | 176720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6005093.440280001 | 2092751.8073 | 37.7265863599479 | -122.424597593708 | (37.7265863599479, -122.424597593708) | ||||
131124 | 131124 | 201347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012791.8631 | 2092596.6146799999 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | |||
153922 | 153922 | 176719 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | ||||
166848 | 166848 | 201346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.39803552533199 | (37.7266049372574, -122.398035525332) | |||
178662 | 178662 | 176722 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Silliman St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005525.86401 | 2092752.5309 | 37.726612758671706 | -122.42310277028099 | (37.7266127586717, -122.423102770281) | |||
66087 | 66087 | 176671 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 250 San Juan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000440.43474 | 2092860.7725400003 | 37.7266216745319 | -122.440690633469 | (37.7266216745319, -122.440690633469) | |||
44637 | 44637 | 201345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012754.450780001 | 2092609.0590599999 | 37.726624085606396 | -122.398103573427 | (37.7266240856064, -122.398103573427) | |||
173712 | 173712 | 201343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012739.9825 | 2092614.2530099999 | 37.72663754126479 | -122.39815395433399 | (37.7266375412648, -122.398153954334) | ||||
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) | |||
97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
24886 | 24886 | 219309 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998711.42236 | 2092939.4829099998 | 37.7267391799504 | -122.446673405767 | (37.7267391799504, -122.446673405767) | |||
189045 | 189045 | 219314 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998659.44994 | 2092940.88551 | 37.726740062192796 | -122.44685317305 | (37.7267400621928, -122.44685317305) | |||
150335 | 150335 | 219310 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998701.57412 | 2092940.01762 | 37.726740085570896 | -122.446707489163 | (37.7267400855709, -122.446707489163) | |||
178178 | 178178 | 219312 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998687.3784300005 | 2092940.6598099999 | 37.7267410379466 | -122.44675660923599 | (37.7267410379466, -122.446756609236) | |||
152088 | 152088 | 219313 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5998681.64729 | 2092941.0568 | 37.726741800591505 | -122.44677645009199 | (37.7267418005915, -122.446776450092) | |||
59777 | 59777 | 219311 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5998693.54289 | 2092940.83387 | 37.726741868021705 | -122.446735311483 | (37.7267418680217, -122.446735311483) | |||
70936 | 70936 | 206956 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 650 Circular Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5998927.77955 | 2092979.65354 | 37.7268618357854 | -122.445928356121 | (37.7268618357854, -122.445928356121) | |||
167158 | 167158 | 176709 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006103.2010699995 | 2092869.0729 | 37.72696532078629 | -122.421115204706 | (37.7269653207863, -122.421115204706) | |||
163480 | 163480 | 176710 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006112.2043 | 2092872.4099700002 | 37.7269749911909 | -122.42108431750401 | (37.7269749911909, -122.421084317504) | |||
177707 | 177707 | 176711 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006130.21076 | 2092879.08379 | 37.7269943310972 | -122.421022543052 | (37.7269943310972, -122.421022543052) | |||
152046 | 152046 | 176712 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006141.07074 | 2092882.19738 | 37.7270034925144 | -122.42098522120199 | (37.7270034925144, -122.420985221202) | |||
60458 | 60458 | 176713 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006152.67495 | 2092885.29568 | 37.7270126538879 | -122.420945325462 | (37.7270126538879, -122.420945325462) | |||
89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
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) | |||
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) | |||
68388 | 68388 | 176684 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 80 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6004830.04308 | 2092947.4100799998 | 37.7271085629972 | -122.4255220635 | (37.7271085629972, -122.4255220635) | |||
54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
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) | |||
58322 | 58322 | 176790 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 687 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6009034.54541 | 2092898.31012 | 37.727210413927395 | -122.410983627814 | (37.7272104139274, -122.410983627814) | |||
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) | |||
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) | |||
132612 | 132612 | 176816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 633 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6009439.97458 | 2092928.08247 | 37.727314889056395 | -122.40958415680299 | (37.7273148890564, -122.409584156803) | |||
43377 | 43377 | 176817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 633 Burrows St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6009456.4217300005 | 2092933.01773 | 37.7273293618403 | -122.40952764698099 | (37.7273293618403, -122.409527646981) | |||
43420 | 43420 | 176674 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 17 Paulding St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000269.12571 | 2093162.5981700001 | 37.7274406610436 | -122.441304488221 | (37.7274406610436, -122.441304488221) | |||
183443 | 183443 | 176685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 59 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6004983.7044 | 2093070.7345599998 | 37.72745586589 | -122.424999628452 | (37.72745586589, -122.424999628452) | |||
174096 | 174096 | 219307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 166 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998440.900769999 | 2093236.39067 | 37.727538962329604 | -122.447629950774 | (37.7275389623296, -122.447629950774) | ||||
60193 | 60193 | 219308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 166 Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998423.39601 | 2093237.9492099998 | 37.7275422412798 | -122.447690576758 | (37.7275422412798, -122.447690576758) | ||||
37929 | 37929 | 176673 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 62 Paulding St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 5999928.39495 | 2093418.54545 | 37.7281240171909 | -122.442500760096 | (37.7281240171909, -122.442500760096) | |||
42201 | 42201 | 176845 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 54 Gambier St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005715.3463 | 2093303.5013700002 | 37.728136293845104 | -122.42248686869101 | (37.7281362938451, -122.422486868691) | |||
129546 | 129546 | 176751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Gambier St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6005772.20267 | 2093310.23557 | 37.728157991789104 | -122.422290792187 | (37.7281579917891, -122.422290792187) | |||
29238 | 29238 | 176752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Gambier St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6005769.79082 | 2093316.51308 | 37.7281750924071 | -122.422299575881 | (37.7281750924071, -122.422299575881) | |||
179100 | 179100 | 176754 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 39 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007339.53346 | 2093313.71898 | 37.728255841634 | -122.416872705109 | (37.728255841634, -122.416872705109) | |||
40143 | 40143 | 176755 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 39 Amherst St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6007337.46192 | 2093318.25117 | 37.7282681695262 | -122.416880187495 | (37.7282681695262, -122.416880187495) | |||
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) | |||
37931 | 37931 | 176756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 39 Amherst St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6007334.92335 | 2093326.38526 | 37.7282903611866 | -122.416889539518 | (37.7282903611866, -122.416889539518) | |||
62906 | 62906 | 176774 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008278.14713 | 2093326.70687 | 37.7283442548741 | -122.413628786662 | (37.7283442548741, -122.413628786662) | |||
150715 | 150715 | 206952 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5998679.10262 | 2093529.64727 | 37.7283577869579 | -122.44682758104601 | (37.7283577869579, -122.446827581046) | |||
48581 | 48581 | 206949 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998662.588880001 | 2093529.9908599998 | 37.728357786969 | -122.44688469428499 | (37.728357786969, -122.446884694285) | |||
69473 | 69473 | 206953 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5998675.411230001 | 2093529.7240799998 | 37.728357786978705 | -122.44684034782301 | (37.7283577869787, -122.446840347823) | |||
34424 | 34424 | 206951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998696.40165 | 2093529.6745 | 37.7283588499644 | -122.44676777970501 | (37.7283588499644, -122.446767779705) | |||
164900 | 164900 | 206954 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998672.69937 | 2093530.16764 | 37.7283588499667 | -122.446849754714 | (37.7283588499667, -122.446849754714) | |||
52041 | 52041 | 206950 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998705.14438 | 2093529.4926099998 | 37.7283588499702 | -122.44673754272499 | (37.7283588499702, -122.446737542725) | |||
134282 | 134282 | 176775 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008275.495519999 | 2093335.02594 | 37.7283669483601 | -122.413638541588 | (37.7283669483601, -122.413638541588) |
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");