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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38472 | 38472 | 129194 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001552.51444 | 2120931.86169 | 37.8037612434571 | -122.438856955397 | (37.8037612434571, -122.438856955397) | |||
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) | |||
38573 | 38573 | 176693 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 231 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6004560.89466 | 2091885.9682599998 | 37.7241788667532 | -122.426376964428 | (37.7241788667532, -122.426376964428) | |||
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) | |||
38700 | 38700 | 64762 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1988 12:00:00 AM | 8 | Permit Number 25739 | 5991956.18292 | 2111010.7557900003 | 37.7759700106605 | -122.471341981082 | (37.7759700106605, -122.471341981082) | ||
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) | |||
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) | |||
38948 | 38948 | 249603 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998819.017030001 | 2111486.76835 | 37.77767161949011 | -122.44763601580799 | (37.7776716194901, -122.447636015808) | |||
39030 | 39030 | 249749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 33 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000235.88036 | 2117238.71283 | 37.7935458425285 | -122.44314782591299 | (37.7935458425285, -122.443147825913) | |||
39031 | 39031 | 118935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.559230001 | 2109729.9345299997 | 37.7718196654774 | -122.50877787634701 | (37.7718196654774, -122.508777876347) | |||
39084 | 39084 | 250169 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 5997237.65706 | 2110666.34039 | 37.7753284349893 | -122.453047211372 | (37.7753284349893, -122.453047211372) | |||
39223 | 39223 | 226882 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2810 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.41041355295201 | (37.7605458378345, -122.410413552952) | |||
39238 | 39238 | 176826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 635 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002712.89216 | 2087452.0684200001 | 37.711899721374 | -122.432448688654 | (37.711899721374, -122.432448688654) | |||
39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
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) | |||
39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) | |||
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) | ||||
39856 | 39856 | 129108 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 155 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001855.64531 | 2121684.5263400003 | 37.805845102121296 | -122.43786189781 | (37.8058451021213, -122.43786189781) | |||
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) | |
40056 | 40056 | 219363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5990950.29751 | 2095356.30121 | 37.7329287603452 | -122.47367934265199 | (37.7329287603452, -122.473679342652) | |||
40060 | 40060 | 226881 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 1ft | 6006207.80682 | 2104080.83219 | 37.757756184028395 | -122.42154951882 | (37.7577561840284, -122.42154951882) | |||
40063 | 40063 | 190763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1901 Quint St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6012404.6522 | 2095210.16355 | 37.7337466919524 | -122.39949535794202 | (37.7337466919524, -122.399495357942) | |||
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) | |||
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) | |||
40191 | 40191 | 129271 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1369 Hyde St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007508.18673 | 2116988.14114 | 37.7932698109171 | -122.417967231327 | (37.7932698109171, -122.417967231327) | |||
40241 | 40241 | 176843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999252.47179 | 2089747.68303 | 37.718006124373105 | -122.444573717211 | (37.7180061243731, -122.444573717211) | |||
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) | |||
40364 | 40364 | 219319 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994210.91317 | 2091964.42992 | 37.7238038098934 | -122.462160735039 | (37.7238038098934, -122.462160735039) | |||
40444 | 40444 | 226940 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 9 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6003929.09347 | 2096974.1924299998 | 37.738114253060395 | -122.428923598041 | (37.7381142530604, -122.428923598041) | |||
40450 | 40450 | 219269 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5990592.20952 | 2105220.86504 | 37.7599935416893 | -122.47563739517099 | (37.7599935416893, -122.475637395171) | |||
40469 | 40469 | 249747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000233.56128 | 2117245.74106 | 37.793565007967 | -122.44315635509399 | (37.793565007967, -122.443156355094) | |||
40477 | 40477 | 219411 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5999420.52154 | 2095713.4289400002 | 37.7343962677584 | -122.444421347772 | (37.7343962677584, -122.444421347772) | |||
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) | |||
40515 | 40515 | 176771 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6007368.40948 | 2093546.0944400001 | 37.72889551860511 | -122.41678933527001 | (37.7288955186051, -122.41678933527) | |||
40551 | 40551 | 129159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5997408.66924 | 2114451.98586 | 37.785732623419 | -122.452728928703 | (37.785732623419, -122.452728928703) | |||
40690 | 40690 | 129181 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2815 Filbert St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5999478.17066 | 2118381.38967 | 37.796640096714505 | -122.445851771645 | (37.7966400967145, -122.445851771645) | |||
40696 | 40696 | 219275 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1651 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5993370.433230001 | 2104236.7588299997 | 37.7574521115395 | -122.465957429918 | (37.7574521115395, -122.465957429918) | |||
40707 | 40707 | 219318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5994210.25958 | 2091948.5213400002 | 37.7237600911452 | -122.46216184119 | (37.7237600911452, -122.46216184119) | |||
40817 | 40817 | 176682 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1998 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000630.5225599995 | 2090456.6587099999 | 37.7200313490478 | -122.43986121213301 | (37.7200313490478, -122.439861212133) | |||
40832 | 40832 | 227010 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001848.80076 | 2097475.72956 | 37.739373388466895 | -122.436152077973 | (37.7393733884669, -122.436152077973) | |||
40995 | 40995 | 176594 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 207 Theresa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6001997.82459 | 2093826.34352 | 37.72936147984579 | -122.43537583891701 | (37.7293614798458, -122.435375838917) | |||
41224 | 41224 | 227003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002088.6819 | 2098074.75757 | 37.741031805779 | -122.435365514706 | (37.741031805779, -122.435365514706) | |||
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) | |||
41354 | 41354 | 184569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3943 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981967.8868 | 2103494.6521 | 37.7547501020315 | -122.505336310147 | (37.7547501020315, -122.505336310147) | |||
41410 | 41410 | 219410 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5999420.88677 | 2095723.69435 | 37.734424474994995 | -122.444420822556 | (37.734424474995, -122.444420822556) | |||
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) | |||
41466 | 41466 | 206932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 304 Ridgewood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996826.20254 | 2095064.45784 | 37.732465983599894 | -122.453343868921 | (37.7324659835999, -122.453343868921) | |||
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) | |||
41828 | 41828 | 190809 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2109 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011813.75397 | 2103701.3128400003 | 37.7570286091033 | -122.402135040812 | (37.7570286091033, -122.402135040812) | |||
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) | |||
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) | ||||
42195 | 42195 | 129225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000598.01874 | 2117499.1088 | 37.794281463669705 | -122.441913500121 | (37.7942814636697, -122.441913500121) | |||
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) | |||
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) | |||
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) | |||
42520 | 42520 | 176665 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1787 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000762.888230001 | 2093739.1978 | 37.729051986242204 | -122.43963887275801 | (37.7290519862422, -122.439638872758) | |||
42535 | 42535 | 250173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997239.18442 | 2110648.2538799997 | 37.7752788616692 | -122.453040622039 | (37.7752788616692, -122.453040622039) | |||
42674 | 42674 | 219277 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994666.162690001 | 2100675.76794 | 37.74774920006679 | -122.46121818977501 | (37.7477492000668, -122.461218189775) | |||
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) | |||
43202 | 43202 | 118930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 875 La Playa | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980751.65283 | 2109636.5801 | 37.7715424153171 | -122.509998562861 | (37.7715424153171, -122.509998562861) | |||
43208 | 43208 | 219383 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 459 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998400.01537 | 2095223.03965 | 37.7329914952508 | -122.447914261545 | (37.7329914952508, -122.447914261545) | |||
43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) | |||
43294 | 43294 | 219284 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 201 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6000000.31433 | 2094329.62548 | 37.7306297307768 | -122.44231751154499 | (37.7306297307768, -122.442317511545) | |||
43342 | 43342 | 226971 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 220 Swiss Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6001230.712180001 | 2096666.61613 | 37.7371166162454 | -122.438231202605 | (37.7371166162454, -122.438231202605) | |||
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) | |||
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) | |||
43601 | 43601 | 226883 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2810 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6009442.873790001 | 2105030.57293 | 37.7605458378462 | -122.41042833510599 | (37.7605458378462, -122.410428335106) | |||
43606 | 43606 | 176668 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Camellia Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003228.3472 | 2094009.7333099998 | 37.7299348336038 | -122.43113489517799 | (37.7299348336038, -122.431134895178) | |||
43705 | 43705 | 190817 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.40845015844101 | (37.7645813917285, -122.408450158441) | |||
43812 | 43812 | 176599 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998280.541680001 | 2089346.8494799999 | 37.716850019794606 | -122.44790439957899 | (37.7168500197946, -122.447904399579) | |||
43911 | 43911 | 219267 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1486 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990295.40982 | 2105284.56966 | 37.7601512467979 | -122.476668525453 | (37.7601512467979, -122.476668525453) | |||
43916 | 43916 | 249625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 5997639.79528 | 2111322.31201 | 37.777152600940106 | -122.451703458765 | (37.7771526009401, -122.451703458765) | |||
43932 | 43932 | 206959 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998473.1983199995 | 2095010.9948599997 | 37.7324134532998 | -122.44764599109399 | (37.7324134532998, -122.447645991094) | ||||
44115 | 44115 | 31115 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.06252 | 2094332.58617 | 37.7305689213091 | -122.44649481749201 | (37.7305689213091, -122.446494817492) | |
44302 | 44302 | 219351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993263.35325 | 2089534.6361099998 | 37.7170775806463 | -122.46525985636002 | (37.7170775806463, -122.46525985636) | |||
44382 | 44382 | 54527 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 8 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | |
44537 | 44537 | 219348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5992970.49595 | 2090542.2168 | 37.7198272604875 | -122.466345302117 | (37.7198272604875, -122.466345302117) | |||
44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
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) | |||
44737 | 44737 | 206937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 33 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000058.45225 | 2094003.2368599998 | 37.7297368568549 | -122.442093101029 | (37.7297368568549, -122.442093101029) | |||
44824 | 44824 | 68547 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 526 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32434 | 5982567.23967 | 2112157.10709 | 37.7785699651083 | -122.50390516811599 | (37.7785699651083, -122.503905168116) | ||
45155 | 45155 | 190814 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 6010041.1190599995 | 2106539.02685 | 37.7647212291204 | -122.40846567444599 | (37.7647212291204, -122.408465674446) | |||
45160 | 45160 | 226880 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009467.77548 | 2106133.6543799997 | 37.7635760441104 | -122.41042010180901 | (37.7635760441104, -122.410420101809) | |||
45249 | 45249 | 219385 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 329 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999222.72505 | 2095218.63632 | 37.7330263961533 | -122.445069633071 | (37.7330263961533, -122.445069633071) | |||
45391 | 45391 | 129239 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2792 Fillmore St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002609.508780001 | 2117716.5979299997 | 37.794993047745 | -122.43496908546999 | (37.794993047745, -122.43496908547) | |||
45457 | 45457 | 206945 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 224 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998782.42741 | 2093648.8743 | 37.7286910586321 | -122.446478957932 | (37.7286910586321, -122.446478957932) | |||
45474 | 45474 | 219274 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992036.15334 | 2106859.17905 | 37.7645755218673 | -122.470762873609 | (37.7645755218673, -122.470762873609) | |||
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) | |||
45698 | 45698 | 219252 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 493 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998807.210109999 | 2094945.46348 | 37.7322526032772 | -122.446486525737 | (37.7322526032772, -122.446486525737) | |||
45702 | 45702 | 129197 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6001606.6144900005 | 2120894.2374 | 37.8036610149183 | -122.43866704197501 | (37.8036610149183, -122.438667041975) | |||
45751 | 45751 | 248141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 274 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6009875.37752 | 2099433.39728 | 37.745201475562794 | -122.408537657996 | (37.7452014755628, -122.408537657996) | |||
45902 | 45902 | 176783 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 745 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008508.75071 | 2093604.64822 | 37.729120368908205 | -122.41285121931999 | (37.7291203689082, -122.41285121932) | |||
46210 | 46210 | 226966 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 17 Temple St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000015.92856 | 2105901.5883400002 | 37.7624044523192 | -122.443094287484 | (37.7624044523192, -122.443094287484) | |||
46288 | 46288 | 129166 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998684.61281 | 2113379.65213 | 37.782861304856894 | -122.448237300713 | (37.7828613048569, -122.448237300713) | |||
46315 | 46315 | 206948 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5997397.5658599995 | 2093594.47343 | 37.7284624896392 | -122.451262563442 | (37.7284624896392, -122.451262563442) | |||
46357 | 46357 | 190782 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1250 20th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6014143.03501 | 2104824.3821099997 | 37.7602420504487 | -122.394158065056 | (37.7602420504487, -122.394158065056) | |||
46421 | 46421 | 246622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6009131.1615699995 | 2099436.16764 | 37.7451673750763 | -122.411111235306 | (37.7451673750763, -122.411111235306) | |||
46533 | 46533 | 129358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2431 Jones St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007962.785209999 | 2120702.9106099997 | 37.8034952158822 | -122.41665756479799 | (37.8034952158822, -122.416657564798) | |||
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) |
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");