trees

1,408 rows where qSpecies_id = 113 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
5623 226838 DPW Maintained 1 Juniperus chinensis :: Juniper 113 14 Liberty St 2 : Tree Private 2     7 Width 1ft   6006187.25946 2104078.53237 37.7577487106567 -122.42162041686 (37.7577487106567, -122.42162041686) 2 4 5 28859 19
8677 249743 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 27 : Tree Private 2     8 Width 1ft   6000230.51867 2117262.97292 37.7936121486327 -122.443168120916 (37.7936121486327, -122.443168120916) 13 9 1 57 27
13280 226873 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 6 : Tree Private 2     7 Width 3ft   6009581.91025 2105420.85963 37.7616252698063 -122.409975021942 (37.7616252698063, -122.409975021942) 2 4 8 28859 19
15110 249752 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 36 : Tree Private 2     8 Width 1ft   6000236.97181 2117227.13869 37.7935141252181 -122.443143217783 (37.7935141252181, -122.443143217783) 13 9 1 57 27
19628 129197 DPW Maintained 1 Juniperus chinensis :: Juniper 113 75 Cervantes Blvd 2 : Tree Private 2     5 Width 2ft   6001606.61449 2120894.2374 37.8036610149183 -122.438667041975 (37.8036610149183, -122.438667041975) 13 9 1 57 17
21430 249750 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 34 : Tree Private 2     11 Width 1ft   6000235.93718 2117235.57911 37.7935372413976 -122.443147404144 (37.7935372413976, -122.443147404144) 13 9 1 57 27
26549 226881 DPW Maintained 1 Juniperus chinensis :: Juniper 113 14 Liberty St 1 : Tree Private 2     19 Width 1ft   6006207.80682 2104080.83219 37.7577561840284 -122.42154951882 (37.7577561840284, -122.42154951882) 2 4 5 28859 19
26756 249757 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 41 : Tree Private 2     11 Width 1ft   6000240.78319 2117204.07092 37.7934510045092 -122.443128372672 (37.7934510045092, -122.443128372672) 13 9 1 57 27
35060 249744 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 28 : Tree Private 2     10 Width 1ft   6000231.5353 2117259.02304 37.7936013612694 -122.443164319488 (37.7936013612694, -122.443164319488) 13 9 1 57 27
36245 129190 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3725 Scott St 2 : Tree Private 2     11 Width 2ft   6000610.91683 2121141.44631 37.8042830912635 -122.442130450787 (37.8042830912635, -122.442130450787) 13 9 1 57 17
44047 129189 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3725 Scott St 1 : Tree Private 2     17 Width 2ft   6000608.31446 2121159.56549 37.8043326933704 -122.442140757907 (37.8043326933704, -122.442140757907) 13 9 1 57 17
44592 176622 DPW Maintained 1 Juniperus chinensis :: Juniper 113 28 Tomaso Ct 1 : Tree Private 2     5 Width 2ft   6009222.26909 2086479.67419 37.7095966978914 -122.409881764928 (37.7095966978914, -122.409881764928) 9 7 8 309 39
46685 129196 DPW Maintained 1 Juniperus chinensis :: Juniper 113 75 Cervantes Blvd 1 : Tree Private 2     10 Width 2ft   6001591.38038 2120905.5251 37.8036911413025 -122.438720569603 (37.8036911413025, -122.438720569603) 13 9 1 57 17
53563 190806 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1924 22nd St 3 : Tree Private 2     8 Width 2ft   6012287.44957 2103786.76177 37.7572896615996 -122.400502813555 (37.7572896615996, -122.400502813555) 10 3 8 28856 29
58121 190761 DPW Maintained 1 Juniperus chinensis :: Juniper 113 285 Connecticut St 1 : Tree Private 2     21 Width 3ft   6013218.56242 2105774.14575 37.76279846511 -122.397422010521 (37.76279846511, -122.397422010521) 14 3 8 28856 29
60575 249762 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 46 : Tree Private 2     20 Width 1ft   6000243.90067 2117182.35848 37.7933915656126 -122.443116025908 (37.7933915656126, -122.443116025908) 13 9 1 57 27
62725 246622 DPW Maintained 1 Juniperus chinensis :: Juniper 113 37 Norwich St 2 : Tree Private 2     5 Width 4ft   6009131.16157 2099436.16764 37.7451673750763 -122.411111235306 (37.7451673750763, -122.411111235306) 2 7 7 28859 2
65020 249764 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 48 : Tree Private 2     23 Width 1ft   6000246.04856 2117175.67215 37.7933733291772 -122.443108113651 (37.7933733291772, -122.443108113651) 13 9 1 57 27
65424 249759 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 43 : Tree Private 2     11 Width 1ft   6000241.63427 2117194.01368 37.7934234385005 -122.443124705245 (37.7934234385005, -122.443124705245) 13 9 1 57 27
67323 129120 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3632 Fillmore St 3 : Tree Private 2     3 Width 3ft   6002190.78069 2120762.93266 37.8033337012543 -122.436636103882 (37.8033337012543, -122.436636103882) 13 9 1 57 17
68112 249751 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 35 : Tree Private 2     9 Width 1ft   6000236.78022 2117230.82972 37.7935242488913 -122.443144145909 (37.7935242488913, -122.443144145909) 13 9 1 57 27
74317 249755 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 39 : Tree Private 2     9 Width 1ft   6000239.61526 2117214.478 37.79347951302 -122.443133161562 (37.79347951302, -122.443133161562) 13 9 1 57 27
80393 226871 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 4 : Tree Private 2     10 Width 3ft   6009582.69337 2105397.44165 37.761561013249 -122.409970660215 (37.761561013249, -122.409970660215) 2 4 8 28859 19
80563 226854 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1306 York St 1 : Tree Private 2     2 Width 2ft   6010039.20712 2101569.82479 37.7510768094609 -122.40812180518 (37.7510768094609, -122.40812180518) 2 4 7 28859 19
86385 226876 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2799 18th St 2 : Tree Private 2     9 Width 3ft   6009598.28938 2105442.85727 37.7616865882978 -122.409919925863 (37.7616865882978, -122.409919925863) 2 4 8 28859 19
87297 249763 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 47 : Tree Private 2     21 Width 1ft   6000244.96871 2117178.73081 37.7933816658824 -122.443112069768 (37.7933816658824, -122.443112069768) 13 9 1 57 27
88287 249609 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2310 Golden Gate Ave 1 : Tree Private 2     8 Width 2ft   5998473.33255 2111438.47015 37.7775192428532 -122.448828371134 (37.7775192428532, -122.448828371134) 15 6 2 54 16
88766 249761 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 45 : Tree Private 2     8 Width 1ft   6000243.02333 2117185.98187 37.7934014644644 -122.443119321906 (37.7934014644644, -122.443119321906) 13 9 1 57 27
90351 249754 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 38 : Tree Private 2     10 Width 1ft   6000238.64594 2117219.34236 37.7934928140037 -122.443136864991 (37.7934928140037, -122.443136864991) 13 9 1 57 27
96055 190801 DPW Maintained 1 Juniperus chinensis :: Juniper 113 625 Rhode Island St 1 : Tree Private 2     6 Width 1ft   6011843.82819 2105357.07787 37.7615766515602 -122.402147437048 (37.7615766515602, -122.402147437048) 10 3 8 28856 29
97406 249758 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 42 : Tree Private 2     11 Width 1ft   6000240.94884 2117198.36774 37.793435354522 -122.443127389726 (37.793435354522, -122.443127389726) 13 9 1 57 27
97815 176621 DPW Maintained 1 Juniperus chinensis :: Juniper 113 20 Tomaso Ct 1 : Tree Private 2     6 Width 2ft   6009241.33314 2086520.93111 37.7097110493951 -122.409818786308 (37.7097110493951, -122.409818786308) 9 7 8 309 39
99180 249749 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 33 : Tree Private 2     12 Width 1ft   6000235.88036 2117238.71283 37.7935458425285 -122.443147825913 (37.7935458425285, -122.443147825913) 13 9 1 57 27
100951 129199 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3688 Fillmore St 1 : Tree Private 2     9 Width 1ft   6002142.29562 2121107.7471 37.8042777151067 -122.436828586663 (37.8042777151067, -122.436828586663) 13 9 1 57 17
112756 190805 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1924 22nd St 2 : Tree Private 2     8 Width 2ft   6012299.62421 2103787.4473 37.7572922228659 -122.400460756771 (37.7572922228659, -122.400460756771) 10 3 8 28856 29
112796 226868 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 1 : Tree Private 2     13 Width 3ft   6009583.77796 2105356.60211 37.7614489379435 -122.40996402594 (37.7614489379435, -122.40996402594) 2 4 8 28859 19
114680 129187 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3445 Broderick St 1 : Tree Private 2     6 Width 2ft   5999729.19027 2120417.13156 37.8022440296095 -122.44512962056 (37.8022440296095, -122.44512962056) 13 9 1 57 17
117929 226878 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2799 18th St 4 : Tree Private 2     6 Width 3ft   6009615.15158 2105443.01814 37.7616879750304 -122.409861617432 (37.7616879750304, -122.409861617432) 2 4 8 28859 19
118330 190804 DPW Maintained 1 Juniperus chinensis :: Juniper 113 960 Rhode Island St 4 : Tree Private 2     9 Width 2ft   6011852.70607 2103917.67826 37.7576248748965 -122.402015538912 (37.7576248748965, -122.402015538912) 10 3 8 28856 29
132935 226880 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1850 Bryant St 3 : Tree Private 2     25 Width 2ft   6009467.77548 2106133.65438 37.7635760441104 -122.410420101809 (37.7635760441104, -122.410420101809) 8 4 7 28859 19
133876 202046 DPW Maintained 1 Juniperus chinensis :: Juniper 113 47 Exeter St 2 : Tree Private 2     8 Width 2ft   6012581.44921 2090990.21223 37.722169424252 -122.398588087695 (37.722169424252, -122.398588087695) 10 3 8 58 1
136907 129202 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1425 Jefferson St 3 : Tree Private 2     16 Width 2ft   6002378.47119 2121561.31201 37.8055365042628 -122.436043759126 (37.8055365042628, -122.436043759126) 13 9 1 57 17
142046 226875 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2799 18th St 1 : Tree Private 2     8 Width 3ft   6009589.19178 2105442.78683 37.7616858850104 -122.409951385948 (37.7616858850104, -122.409951385948) 2 4 8 28859 19
142648 226877 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2799 18th St 3 : Tree Private 2     7 Width 3ft   6009607.1639 2105442.92865 37.7616872816556 -122.409889237391 (37.7616872816556, -122.409889237391) 2 4 8 28859 19
143909 190759 DPW Maintained 1 Juniperus chinensis :: Juniper 113 960 Rhode Island St 1 : Tree Private 2     6 Width 2ft   6011851.68946 2103937.20655 37.7576784385299 -122.402020427597 (37.7576784385299, -122.402020427597) 10 3 8 28856 29
145430 190813 DPW Maintained 1 Juniperus chinensis :: Juniper 113 870 Arkansas St 2 : Tree Private 2     12 Width 3ft   6013034.16138 2103011.82985 37.7552034817751 -122.39786601663 (37.7552034817751, -122.39786601663) 10 3 8 28856 29
146366 129188 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3445 Broderick St 2 : Tree Private 2     4 Width 2ft   5999731.06738 2120400.48948 37.8021984420688 -122.445121927729 (37.8021984420688, -122.445121927729) 13 9 1 57 17
149499 249748 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 32 : Tree Private 2     2 Width 1ft   6000234.88856 2117241.71857 37.7935540389482 -122.443151473582 (37.7935540389482, -122.443151473582) 13 9 1 57 27
150568 226874 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 7 : Tree Private 2     9 Width 3ft   6009580.43955 2105432.84678 37.7616581013669 -122.409980954769 (37.7616581013669, -122.409980954769) 2 4 8 28859 19
154219 249747 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 31 : Tree Private 2     10 Width 1ft   6000233.56128 2117245.74106 37.793565007967 -122.443156355094 (37.793565007967, -122.443156355094) 13 9 1 57 27
155788 226872 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 5 : Tree Private 2     15 Width 3ft   6009582.03352 2105410.01949 37.7615955121557 -122.409973830325 (37.7615955121557, -122.409973830325) 2 4 8 28859 19
159720 249760 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 44 : Tree Private 2     12 Width 1ft   6000241.78626 2117189.52986 37.7934111357761 -122.443123857177 (37.7934111357761, -122.443123857177) 13 9 1 57 27
160403 249746 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 30 : Tree Private 2     4 Width 1ft   6000233.18821 2117249.22853 37.7935745623699 -122.44315789653 (37.7935745623699, -122.44315789653) 13 9 1 57 27
161660 226870 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 3 : Tree Private 2     9 Width 3ft   6009582.96211 2105385.4738 37.7615281673157 -122.409968885865 (37.7615281673157, -122.409968885865) 2 4 8 28859 19
167267 249756 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 40 : Tree Private 2     6 Width 1ft   6000240.43697 2117209.2145 37.7934651076862 -122.443129940195 (37.7934651076862, -122.443129940195) 13 9 1 57 27
167557 129200 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3688 Fillmore St 3 : Tree Private 2     12 Width 1ft   6002139.18705 2121127.02263 37.8043304639385 -122.436840724815 (37.8043304639385, -122.436840724815) 13 9 1 57 17
169773 250323 DPW Maintained 1 Juniperus chinensis :: Juniper 113 179 27th Ave 1 : Tree Private 2     8 Width 3ft   5987396.03432 2114802.15795 37.7861152804279 -122.487395082144 (37.7861152804279, -122.487395082144) 11 6 1 55 33
171163 246621 DPW Maintained 1 Juniperus chinensis :: Juniper 113 37 Norwich St 1 : Tree Private 2     6 Width 4ft   6009124.59661 2099436.39802 37.745167639486 -122.411133952165 (37.745167639486, -122.411133952165) 2 7 7 28859 2
172640 249745 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 29 : Tree Private 2     10 Width 1ft   6000232.82903 2117254.64914 37.7935894254586 -122.443159528809 (37.7935894254586, -122.443159528809) 13 9 1 57 27
174003 250324 DPW Maintained 1 Juniperus chinensis :: Juniper 113 179 27th Ave 2 : Tree Private 2     8 Width 3ft   5987396.8518 2114775.10833 37.7860410575969 -122.487390266267 (37.7860410575969, -122.487390266267) 11 6 1 55 33
175042 226839 DPW Maintained 1 Juniperus chinensis :: Juniper 113 14 Liberty St 3 : Tree Private 2     6 Width 1ft   6006174.93663 2104077.42455 37.7577449739746 -122.421662955682 (37.7577449739746, -122.421662955682) 2 4 5 28859 19
175388 249753 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2500 Broderick St 37 : Tree Private 2     7 Width 1ft   6000238.56892 2117223.4057 37.793503966475 -122.443137423448 (37.793503966475, -122.443137423448) 13 9 1 57 27
177692 190803 DPW Maintained 1 Juniperus chinensis :: Juniper 113 960 Rhode Island St 3 : Tree Private 2     7 Width 2ft   6011852.27614 2103926.33475 37.7576486197115 -122.402017634333 (37.7576486197115, -122.402017634333) 10 3 8 28856 29
181324 190802 DPW Maintained 1 Juniperus chinensis :: Juniper 113 625 Rhode Island St 2 : Tree Private 2     10 Width 1ft   6011842.77301 2105367.13187 37.7616041987086 -122.402151793375 (37.7616041987086, -122.402151793375) 10 3 8 28856 29
184683 190807 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1950 22nd St 1 : Tree Private 2     12 Width 2ft   6012259.17788 2103783.27956 37.7572785235114 -122.400600344128 (37.7572785235114, -122.400600344128) 10 3 8 28856 29
186079 226879 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1850 Bryant St 2 : Tree Private 2     25 Width 2ft   6009465.88714 2106164.02417 37.7636593267514 -122.410428777572 (37.7636593267514, -122.410428777572) 8 4 7 28859 19
187160 226869 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2001 Bryant St 2 : Tree Private 2     9 Width 3ft   6009583.3453 2105371.17651 37.761488931684 -122.409966551231 (37.761488931684, -122.409966551231) 2 4 8 28859 19
193033 129198 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3537 Fillmore St 2 : Tree Private 2     8 Width 2ft   6002132.11244 2120360.66499 37.8022258462139 -122.436810313348 (37.8022258462139, -122.436810313348) 13 9 1 57 17
37204 227015 DPW Maintained 1 Juniperus chinensis :: Juniper 113 29 Poppy Ln 1 Back Yard : Yard Tree Private 2     1 Width 2ft   6002114.09151 2096793.82616 37.7375161085743 -122.435186060404 (37.7375161085743, -122.435186060404) 2 7 5 63 7
69287 227016 DPW Maintained 1 Juniperus chinensis :: Juniper 113 29 Poppy Ln 2 Back Yard : Yard Tree Private 2     4 Width 2ft   6002117.32476 2096797.30121 37.7375258338607 -122.435175130032 (37.7375258338607, -122.435175130032) 2 7 5 63 7
139843 108680 Property Tree 8 Juniperus chinensis :: Juniper 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree Private 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
37022 95985 Significant Tree 6 Juniperus chinensis :: Juniper 113 577 Sanchez St 1 Front Yard : Tree Private 2           6003673 2104901 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
159975 97139 DPW Maintained 1 Juniperus chinensis :: Juniper 113 937 Goettingen St   Front Yard : Landscaping Private 2           6011052 2090410 37.7204909525546 -122.403834244644 (37.7204909525546, -122.403834244644) 10 7 8 309 28
17941 258800 Significant Tree 6 Juniperus chinensis :: Juniper 113 566 29th Ave 2 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
125570 253265 Significant Tree 6 Juniperus chinensis :: Juniper 113 180 San Aleso Ave 1 Front Yard : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   5993319 2094440 37.7305497238902 -122.465423653439 (37.7305497238902, -122.465423653439) 9 8 4 59 40
130833 106685 Undocumented 4 Juniperus chinensis :: Juniper 113 100 Yukon St   Front Yard : Cutout Tree Private 2         Permit Number 772768 6000197.4 2104288 37.757984281634 -122.442350801363 (37.757984281634, -122.442350801363) 2 4 5 28862 3
178383 254277 Significant Tree 6 Juniperus chinensis :: Juniper 113 105 Gladeview Way 1 Front Yard : Cutout Tree Private 2       3x6 Permit Number 781296 5997754 2101950 37.7514251480437 -122.450632514859 (37.7514251480437, -122.450632514859) 1 5 4 63 38
6098 129331 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 9 Front Yard : Yard Tree Private 2     2     6007561.62509 2119863.3782 37.8011675015458 -122.417986250159 (37.8011675015458, -122.417986250159) 5 1 1 28858 32
28183 129327 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 5 Front Yard : Yard Tree Private 2     2     6007552.17158 2119860.88653 37.8011601279913 -122.418018786759 (37.8011601279913, -122.418018786759) 5 1 1 28858 32
31670 104539 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 2 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
38960 103564 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 2 Front Yard : Yard Tree Private 2     13   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
44754 253482 Significant Tree 6 Juniperus chinensis :: Juniper 113 2179 41st Ave 1 Front Yard : Yard Tree Private 2       3x5   5983532 2100331 37.7461555051432 -122.499693454208 (37.7461555051432, -122.499693454208) 1 8 3 29491 35
49750 104540 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 4 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
50909 103563 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 1 Front Yard : Yard Tree Private 2     15   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
52825 104544 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 8 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
57437 108624 Property Tree 8 Juniperus chinensis :: Juniper 113 101 GENEBERN WAY 1 Front Yard : Yard Tree Private 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
59898 108211 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 2 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
60578 202032 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1319 Fitzgerald Ave 2 Front Yard : Yard Tree Private 2     9 Width 7ft   6014005.50578 2090967.22182 37.7221855320171 -122.393663822829 (37.7221855320171, -122.393663822829) 10 3 8 58 1
62300 99828 Significant Tree 6 Juniperus chinensis :: Juniper 113 2398 Broadway 2 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
62635 129332 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 10 Front Yard : Yard Tree Private 2     1     6007563.68428 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724) 5 1 1 28858 32
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
68299 99852 Significant Tree 6 Juniperus chinensis :: Juniper 113 86 Nordhoff St 1 Front Yard : Yard Tree Private 2           6000395 2095652 37.7342831509698 -122.441047861045 (37.7342831509698, -122.441047861045) 9 7 5 63 40
69651 247136 DPW Maintained 1 Juniperus chinensis :: Juniper 113 500 27th St 6 Front Yard : Yard Tree Private 2     3     6003181.95614 2100090.46758 37.7466285054035 -122.431729256215 (37.7466285054035, -122.431729256215) 2 7 5 63 22
74370 121732 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1301 Vermont St 7 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
74446 247945 DPW Maintained 1 Juniperus chinensis :: Juniper 113 15 Joy St 1 Front Yard : Yard Tree Private 2     4     6010344.08085 2098894.91993 37.7437491720868 -122.406879009554 (37.7437491720868, -122.406879009554) 2 7 7 28859 2
78350 107828 Undocumented 4 Juniperus chinensis :: Juniper 113 2601 Van Ness Ave 2 Front Yard : Yard Tree Private 2     35   Permit Number 774138 6005744.5 2119283.2 37.7994720432373 -122.424233014169 (37.7994720432373, -122.424233014169) 13 9 1 28858 17
82430 226865 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1100 San Jose Ave 9 Front Yard : Yard Tree Private 2     1     6004824.42349 2096711.05527 37.7374423749661 -122.425809268297 (37.7374423749661, -122.425809268297) 2 7 5 63 7
86207 104538 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 1 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
86395 129333 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 12 Front Yard : Yard Tree Private 2     1     6007566.18304 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228) 5 1 1 28858 32
87223 103565 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 3 Front Yard : Yard Tree Private 2     9   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);