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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
32459 | 32459 | 249756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 40 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6000240.43697 | 2117209.2145 | 37.7934651076862 | -122.443129940195 | (37.7934651076862, -122.443129940195) | |||
37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
46543 | 46543 | 249746 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 30 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6000233.18821 | 2117249.22853 | 37.7935745623699 | -122.44315789653 | (37.7935745623699, -122.44315789653) | |||
49386 | 49386 | 249751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 35 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000236.78022 | 2117230.8297200003 | 37.793524248891295 | -122.443144145909 | (37.7935242488913, -122.443144145909) | |||
51537 | 51537 | 190761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6013218.562419999 | 2105774.14575 | 37.762798465109995 | -122.397422010521 | (37.76279846511, -122.397422010521) | |||
52094 | 52094 | 249755 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 39 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000239.615259999 | 2117214.478 | 37.79347951302 | -122.443133161562 | (37.79347951302, -122.443133161562) | |||
52600 | 52600 | 190813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 870 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013034.16138 | 2103011.82985 | 37.755203481775105 | -122.39786601663 | (37.7552034817751, -122.39786601663) | |||
52652 | 52652 | 226879 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009465.88714 | 2106164.02417 | 37.7636593267514 | -122.41042877757201 | (37.7636593267514, -122.410428777572) | |||
57199 | 57199 | 190807 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1950 22nd St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6012259.17788 | 2103783.2795599997 | 37.7572785235114 | -122.400600344128 | (37.7572785235114, -122.400600344128) | |||
58583 | 58583 | 226874 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009580.43955 | 2105432.84678 | 37.7616581013669 | -122.409980954769 | (37.7616581013669, -122.409980954769) | |||
59064 | 59064 | 129190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6000610.9168300005 | 2121141.44631 | 37.8042830912635 | -122.44213045078699 | (37.8042830912635, -122.442130450787) | |||
59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
59790 | 59790 | 129202 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1425 Jefferson St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6002378.47119 | 2121561.31201 | 37.8055365042628 | -122.436043759126 | (37.8055365042628, -122.436043759126) | |||
62997 | 62997 | 249752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 36 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.44314321778299 | (37.7935141252181, -122.443143217783) | |||
65018 | 65018 | 249759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 43 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000241.634269999 | 2117194.01368 | 37.7934234385005 | -122.443124705245 | (37.7934234385005, -122.443124705245) | |||
65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
66764 | 66764 | 226871 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6009582.6933699995 | 2105397.44165 | 37.761561013249 | -122.409970660215 | (37.761561013249, -122.409970660215) | |||
67332 | 67332 | 249758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 42 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.94884 | 2117198.36774 | 37.793435354521996 | -122.44312738972602 | (37.793435354522, -122.443127389726) | |||
67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
68529 | 68529 | 176622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 28 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009222.269090001 | 2086479.6741900002 | 37.7095966978914 | -122.409881764928 | (37.7095966978914, -122.409881764928) | |||
70038 | 70038 | 249762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 46 | : 4 | Tree 1 | Private 1 | 20 | Width 1ft | 6000243.900669999 | 2117182.35848 | 37.7933915656126 | -122.443116025908 | (37.7933915656126, -122.443116025908) | |||
70401 | 70401 | 250324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.8518 | 2114775.1083299997 | 37.7860410575969 | -122.487390266267 | (37.7860410575969, -122.487390266267) | |||
75263 | 75263 | 202046 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Exeter St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012581.44921 | 2090990.21223 | 37.722169424252 | -122.398588087695 | (37.722169424252, -122.398588087695) | |||
130192 | 130192 | 249743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 27 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.793612148632704 | -122.443168120916 | (37.7936121486327, -122.443168120916) | |||
130684 | 130684 | 190802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011842.77301 | 2105367.13187 | 37.7616041987086 | -122.402151793375 | (37.7616041987086, -122.402151793375) | |||
135341 | 135341 | 129188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5999731.06738 | 2120400.48948 | 37.80219844206879 | -122.44512192772899 | (37.8021984420688, -122.445121927729) | |||
136197 | 136197 | 249748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 32 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6000234.88856 | 2117241.71857 | 37.7935540389482 | -122.443151473582 | (37.7935540389482, -122.443151473582) | |||
136796 | 136796 | 176621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 20 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009241.33314 | 2086520.9311099998 | 37.7097110493951 | -122.40981878630801 | (37.7097110493951, -122.409818786308) | |||
138184 | 138184 | 249761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 45 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000243.02333 | 2117185.9818700003 | 37.793401464464395 | -122.443119321906 | (37.7934014644644, -122.443119321906) | |||
148834 | 148834 | 249750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 34 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000235.93718 | 2117235.57911 | 37.7935372413976 | -122.443147404144 | (37.7935372413976, -122.443147404144) | |||
149561 | 149561 | 249609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2310 Golden Gate Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 5998473.33255 | 2111438.47015 | 37.7775192428532 | -122.448828371134 | (37.7775192428532, -122.448828371134) | |||
150183 | 150183 | 226872 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6009582.03352 | 2105410.0194900003 | 37.76159551215571 | -122.40997383032499 | (37.7615955121557, -122.409973830325) | |||
151827 | 151827 | 129189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.44214075790701 | (37.8043326933704, -122.442140757907) | |||
153878 | 153878 | 249760 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 44 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000241.7862599995 | 2117189.5298599997 | 37.7934111357761 | -122.44312385717699 | (37.7934111357761, -122.443123857177) | |||
154750 | 154750 | 226839 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6006174.93663 | 2104077.42455 | 37.7577449739746 | -122.421662955682 | (37.7577449739746, -122.421662955682) | |||
159125 | 159125 | 190803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011852.27614 | 2103926.33475 | 37.757648619711496 | -122.402017634333 | (37.7576486197115, -122.402017634333) | |||
159833 | 159833 | 246621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6009124.596609999 | 2099436.39802 | 37.745167639486 | -122.41113395216499 | (37.745167639486, -122.411133952165) | |||
160956 | 160956 | 190804 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6011852.706069999 | 2103917.67826 | 37.7576248748965 | -122.402015538912 | (37.7576248748965, -122.402015538912) | |||
164147 | 164147 | 129198 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3537 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002132.11244 | 2120360.66499 | 37.8022258462139 | -122.436810313348 | (37.8022258462139, -122.436810313348) | |||
166326 | 166326 | 226838 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6006187.259459999 | 2104078.53237 | 37.757748710656706 | -122.42162041686001 | (37.7577487106567, -122.42162041686) | |||
167115 | 167115 | 226854 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1306 York St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010039.207119999 | 2101569.82479 | 37.7510768094609 | -122.40812180518 | (37.7510768094609, -122.40812180518) | |||
167156 | 167156 | 190805 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012299.62421 | 2103787.4473 | 37.7572922228659 | -122.400460756771 | (37.7572922228659, -122.400460756771) | |||
167799 | 167799 | 226873 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009581.91025 | 2105420.85963 | 37.7616252698063 | -122.409975021942 | (37.7616252698063, -122.409975021942) | |||
171067 | 171067 | 226876 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.28938 | 2105442.85727 | 37.7616865882978 | -122.409919925863 | (37.7616865882978, -122.409919925863) | |||
171556 | 171556 | 226869 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009583.3453 | 2105371.1765099997 | 37.761488931684 | -122.40996655123101 | (37.761488931684, -122.409966551231) | |||
173393 | 173393 | 249754 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 38 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000238.64594 | 2117219.3423599997 | 37.7934928140037 | -122.443136864991 | (37.7934928140037, -122.443136864991) | |||
174994 | 174994 | 249763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 47 | : 4 | Tree 1 | Private 1 | 21 | Width 1ft | 6000244.96871 | 2117178.7308099996 | 37.7933816658824 | -122.443112069768 | (37.7933816658824, -122.443112069768) | |||
176649 | 176649 | 129200 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6002139.18705 | 2121127.02263 | 37.8043304639385 | -122.436840724815 | (37.8043304639385, -122.436840724815) | |||
178683 | 178683 | 226877 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009607.1639 | 2105442.92865 | 37.761687281655604 | -122.409889237391 | (37.7616872816556, -122.409889237391) | |||
180297 | 180297 | 226868 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6009583.77796 | 2105356.60211 | 37.7614489379435 | -122.40996402594 | (37.7614489379435, -122.40996402594) | |||
181444 | 181444 | 190801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6011843.82819 | 2105357.07787 | 37.761576651560205 | -122.402147437048 | (37.7615766515602, -122.402147437048) | |||
182870 | 182870 | 249757 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 41 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.78319 | 2117204.07092 | 37.7934510045092 | -122.443128372672 | (37.7934510045092, -122.443128372672) | |||
183490 | 183490 | 226870 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009582.96211 | 2105385.4738 | 37.7615281673157 | -122.409968885865 | (37.7615281673157, -122.409968885865) | |||
183940 | 183940 | 226878 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6009615.15158 | 2105443.0181400003 | 37.7616879750304 | -122.409861617432 | (37.7616879750304, -122.409861617432) | |||
184505 | 184505 | 249764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 48 | : 4 | Tree 1 | Private 1 | 23 | Width 1ft | 6000246.04856 | 2117175.67215 | 37.7933733291772 | -122.44310811365101 | (37.7933733291772, -122.443108113651) | |||
186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
186808 | 186808 | 249745 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 29 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000232.829030001 | 2117254.6491400003 | 37.793589425458606 | -122.44315952880899 | (37.7935894254586, -122.443159528809) | |||
187761 | 187761 | 226875 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009589.19178 | 2105442.78683 | 37.7616858850104 | -122.409951385948 | (37.7616858850104, -122.409951385948) | |||
49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
66804 | 66804 | 115308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007523.230690001 | 2116877.91301 | 37.792967998429 | -122.417907360732 | (37.792967998429, -122.417907360732) | |||
66823 | 66823 | 87246 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 22 | 3x3 | Permit Number 50274 | 6006702.92902 | 2119345.02683 | 37.7996958743116 | -122.420920894495 | (37.7996958743116, -122.420920894495) | |
70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
77664 | 77664 | 96104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
80181 | 80181 | 109321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3699 MARKET ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000396.5 | 2103077.7 | 37.7546724390671 | -122.441575379015 | (37.7546724390671, -122.441575379015) | ||||
80890 | 80890 | 108255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
84330 | 84330 | 111073 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991201.0 | 2106639.0 | 37.7639226370674 | -122.473635352969 | (37.7639226370674, -122.473635352969) | ||||
85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
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) | |||||
91752 | 91752 | 96831 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
92163 | 92163 | 108259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
96170 | 96170 | 113366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 799X ORTEGA WAY | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991631.0 | 2102457.0 | 37.7524648607614 | -122.47184332039 | (37.7524648607614, -122.47184332039) | ||||
97359 | 97359 | 119672 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2090x 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6011896.0 | 2104722.0 | 37.7598357807336 | -122.40192234981501 | (37.7598357807336, -122.401922349815) | |||||
98097 | 98097 | 108256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
99837 | 99837 | 99918 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
103370 | 103370 | 96098 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1999 Bryant St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | |||
104233 | 104233 | 106802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x2 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
104644 | 104644 | 106801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 2x3 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
105668 | 105668 | 108258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
107709 | 107709 | 99917 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
107724 | 107724 | 99916 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
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) | ||||
111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
112041 | 112041 | 121326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 25th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5987896.0 | 2115988.0 | 37.7894004070969 | -122.48575242171101 | (37.7894004070969, -122.485752421711) |
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");