Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 26975 | 26975 | 129323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Florence St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | ||||
| 61376 | 61376 | 43140 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 42953 | 6005716.6320400005 | 2093488.3927799999 | 37.7286440375939 | -122.42249555614299 | (37.7286440375939, -122.422495556143) | ||
| 63937 | 63937 | 176847 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005714.45632 | 2093496.12065 | 37.7286651338862 | -122.422503626641 | (37.7286651338862, -122.422503626641) | |||
| 130258 | 130258 | 176848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005711.542330001 | 2093506.49571 | 37.728693457131 | -122.422514437416 | (37.728693457131, -122.422514437416) | |||
| 174196 | 174196 | 176849 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | |||
| 74388 | 74388 | 226884 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Hidalgo Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6005071.43074 | 2107486.3006599997 | 37.7670426518224 | -122.425721963013 | (37.7670426518224, -122.425721963013) | |||
| 93609 | 93609 | 124569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Jordan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996154.91779 | 2114511.96286 | 37.785825384071394 | -122.457070865676 | (37.7858253840714, -122.457070865676) | |||
| 37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
| 44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
| 65 | 65 | 226926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | |||
| 39701 | 39701 | 129113 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | ||||
| 183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
| 45644 | 45644 | 218230 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993788.79546 | 2098675.54917 | 37.7422065730654 | -122.46410687336001 | (37.7422065730654, -122.46410687336) | |||
| 62797 | 62797 | 218228 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 5993822.95601 | 2098779.1266900003 | 37.742492939687 | -122.463996274721 | (37.742492939687, -122.463996274721) | |||
| 169741 | 169741 | 218229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5993803.00449 | 2098718.65979 | 37.7423257629199 | -122.464060872135 | (37.7423257629199, -122.464060872135) | |||
| 186117 | 186117 | 218231 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993773.53157 | 2098636.1244900003 | 37.7420974430581 | -122.464156789307 | (37.7420974430581, -122.464156789307) | |||
| 188348 | 188348 | 218225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 5993843.55646 | 2098914.16079 | 37.7428648966005 | -122.463934844718 | (37.7428648966005, -122.463934844718) | |||
| 188677 | 188677 | 218227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993831.45355 | 2098825.44748 | 37.742620614658 | -122.463970254628 | (37.742620614658, -122.463970254628) | |||
| 188774 | 188774 | 218226 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5993838.37632 | 2098869.25868 | 37.7427413081634 | -122.46394949738199 | (37.7427413081634, -122.463949497382) | |||
| 30510 | 30510 | 30812 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 5 | Permit Number 34674 | 6001381.93618 | 2094967.05294 | 37.7324586091634 | -122.43758667648001 | (37.7324586091634, -122.43758667648) | |
| 153807 | 153807 | 219373 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6001373.71026 | 2094967.00776 | 37.7324580174085 | -122.437615112141 | (37.7324580174085, -122.437615112141) | |||
| 62283 | 62283 | 219329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995365.77553 | 2090599.7710099998 | 37.7201232084876 | -122.45806987824699 | (37.7201232084876, -122.458069878247) | |||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
| 62666 | 62666 | 129281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008192.28376 | 2118905.24878 | 37.798572191203704 | -122.415736009712 | (37.7985721912037, -122.415736009712) | |||
| 72385 | 72385 | 129282 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6008205.81975 | 2118906.85431 | 37.798577360503394 | -122.415689284536 | (37.7985773605034, -122.415689284536) | |||
| 155651 | 155651 | 129280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1009 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008177.93776 | 2118903.66017 | 37.798567022807795 | -122.41578553897699 | (37.7985670228078, -122.415785538977) | |||
| 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) | |||
| 133819 | 133819 | 120070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 26th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5987678.122930001 | 2115272.13774 | 37.7874221569894 | -122.48645366177401 | (37.7874221569894, -122.486453661774) | |||
| 28909 | 28909 | 176778 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6008224.08958 | 2093491.7864599999 | 37.728794492350396 | -122.41382733896499 | (37.7287944923504, -122.413827338965) | |||
| 33950 | 33950 | 176781 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008506.492819999 | 2093591.6358299998 | 37.7290845129336 | -122.41285810544399 | (37.7290845129336, -122.412858105444) | |||
| 71131 | 71131 | 176782 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008503.6919 | 2093600.7846099997 | 37.7291094763057 | -122.412868435047 | (37.7291094763057, -122.412868435047) | |||
| 129996 | 129996 | 176779 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008512.5516 | 2093571.34607 | 37.729029141679895 | -122.412835725785 | (37.7290291416799, -122.412835725785) | |||
| 147527 | 147527 | 176780 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008510.60068 | 2093581.4689 | 37.729056827298 | -122.412843185683 | (37.729056827298, -122.412843185683) | |||
| 87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
| 171560 | 171560 | 219327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995301.64396 | 2090617.7903200001 | 37.720169000171296 | -122.458292861552 | (37.7201690001713, -122.458292861552) | |||
| 172065 | 172065 | 219328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995301.79244 | 2090610.0663299998 | 37.720147800462996 | -122.458291789543 | (37.720147800463, -122.458291789543) | |||
| 187057 | 187057 | 219326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995302.40607 | 2090624.5686700002 | 37.7201876557032 | -122.45829071756701 | (37.7201876557032, -122.458290717567) | |||
| 61159 | 61159 | 129163 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5996819.747219999 | 2113790.05212 | 37.783881366273704 | -122.45471857981701 | (37.7838813662737, -122.454718579817) | |||
| 41916 | 41916 | 176824 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008431.82226 | 2094483.21435 | 37.7315284044084 | -122.413179268628 | (37.7315284044084, -122.413179268628) | |||
| 42361 | 42361 | 176822 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008425.8217 | 2094514.9756099998 | 37.7316152771105 | -122.413202258904 | (37.7316152771105, -122.413202258904) | |||
| 58648 | 58648 | 176823 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008429.95223 | 2094500.1756400003 | 37.731574871472795 | -122.41318693263901 | (37.7315748714728, -122.413186932639) | |||
| 136126 | 136126 | 176806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 102 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008418.41029 | 2094548.1649200001 | 37.7317059917167 | -122.413230227789 | (37.7317059917167, -122.413230227789) | |||
| 24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
| 173591 | 173591 | 219330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | |||
| 188529 | 188529 | 219331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | |||
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 48158 | 48158 | 176798 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6008483.53327 | 2094510.3324 | 37.7316057676803 | -122.41300240975401 | (37.7316057676803, -122.413002409754) | |||
| 56312 | 56312 | 176800 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6008479.14615 | 2094525.5991 | 37.731647440478 | -122.413018655999 | (37.731647440478, -122.413018655999) | |||
| 77062 | 77062 | 176799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008480.51195 | 2094517.85625 | 37.7316262569493 | -122.413013386875 | (37.7316262569493, -122.413013386875) | |||
| 168649 | 168649 | 176802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008473.4395 | 2094550.88435 | 37.731716547980206 | -122.41304017228201 | (37.7317165479802, -122.413040172282) | |||
| 174736 | 174736 | 176801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008476.7673 | 2094533.48941 | 37.7316689720313 | -122.413027437877 | (37.7316689720313, -122.413027437877) | |||
| 186709 | 186709 | 176797 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008485.14768 | 2094502.3312900001 | 37.731583888980104 | -122.412996262887 | (37.7315838889801, -122.412996262887) | |||
| 187619 | 187619 | 176803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008471.3844800005 | 2094562.18285 | 37.731747455866 | -122.41304807552099 | (37.731747455866, -122.413048075521) | |||
| 189128 | 189128 | 176796 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008486.43054 | 2094496.74036 | 37.7315686095034 | -122.41299143261001 | (37.7315686095034, -122.41299143261) | |||
| 132381 | 132381 | 226897 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | |||
| 26630 | 26630 | 206935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000034.8522 | 2094044.21533 | 37.7298480292542 | -122.442177629193 | (37.7298480292542, -122.442177629193) | |||
| 38096 | 38096 | 206933 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6000003.13616 | 2094038.3079799998 | 37.7298300014536 | -122.44228685095301 | (37.7298300014536, -122.442286850953) | |||
| 147711 | 147711 | 206936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6000038.50963 | 2094035.1117 | 37.7298232412405 | -122.44216433183998 | (37.7298232412405, -122.44216433184) | |||
| 170335 | 170335 | 206934 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 6000030.26557 | 2094035.00933 | 37.7298224903164 | -122.442192825064 | (37.7298224903164, -122.442192825064) | |||
| 35782 | 35782 | 190765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.751496295539106 | -122.39007361861601 | (37.7514962955391, -122.390073618616) | |||
| 90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
| 49793 | 49793 | 53948 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | ||
| 175494 | 175494 | 176807 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 106 Gaven St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6009983.095919999 | 2095237.75517 | 37.7336871802039 | -122.407869378985 | (37.7336871802039, -122.407869378985) | |||
| 181075 | 181075 | 176777 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 107 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | |||
| 63947 | 63947 | 129335 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1074 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007834.34596 | 2119269.05545 | 37.799550985448604 | -122.41700038098101 | (37.7995509854486, -122.417000380981) | |||
| 168244 | 168244 | 129334 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1074 Union St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007844.96731 | 2119270.12506 | 37.799554519795606 | -122.416963703016 | (37.7995545197956, -122.416963703016) | |||
| 34986 | 34986 | 129263 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 6009008.56152 | 2117982.3464099998 | 37.796083982049 | -122.41284613813299 | (37.796083982049, -122.412846138133) | |||
| 56672 | 56672 | 96034 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767673 | 6008986.730930001 | 2117980.65751 | 37.7960781193685 | -122.41292155709999 | (37.7960781193685, -122.4129215571) |
| 35741 | 35741 | 129306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006156.05151 | 2120698.06699 | 37.8033801368411 | -122.42290950959101 | (37.8033801368411, -122.422909509591) | |||
| 52974 | 52974 | 129305 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006148.36265 | 2120696.43143 | 37.8033752121629 | -122.422936000907 | (37.8033752121629, -122.422936000907) | |||
| 108014 | 108014 | 113985 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 109 MADRONE AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5992778.0 | 2098364.0 | 37.74129282931111 | -122.46757920887899 | (37.7412928293111, -122.467579208879) | ||||
| 32089 | 32089 | 219321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.45909980971201 | (37.7216008413857, -122.459099809712) | |||
| 32651 | 32651 | 219322 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.87033 | 2091157.1990200002 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | |||
| 37643 | 37643 | 219320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5995079.65544 | 2091128.71847 | 37.7215591281313 | -122.459097172915 | (37.7215591281313, -122.459097172915) | |||
| 42679 | 42679 | 219324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995080.31545 | 2091178.4589099998 | 37.721695741442396 | -122.459098491311 | (37.7216957414424, -122.459098491311) | |||
| 134794 | 134794 | 219325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5995080.6810800005 | 2091195.9220900002 | 37.721743712182395 | -122.459098491296 | (37.7217437121824, -122.459098491296) | |||
| 147745 | 147745 | 219323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.72755 | 2091168.59616 | 37.7216686268896 | -122.459099809715 | (37.7216686268896, -122.459099809715) | |||
| 134612 | 134612 | 190772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | |||
| 48931 | 48931 | 129211 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000911.6199199995 | 2117290.07743 | 37.793725383184295 | -122.440813405326 | (37.7937253831843, -122.440813405326) | |||
| 60802 | 60802 | 129210 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000912.13744 | 2117299.9912900003 | 37.793752633522104 | -122.440812326154 | (37.7937526335221, -122.440812326154) | |||
| 133508 | 133508 | 129212 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000913.33947 | 2117282.2310599997 | 37.793703937035104 | -122.440806892437 | (37.7937039370351, -122.440806892437) | |||
| 152129 | 152129 | 129208 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000907.377069999 | 2117323.47168 | 37.7938168334195 | -122.44083048255399 | (37.7938168334195, -122.440830482554) |
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");