trees
2,694 rows where qSpecies_id = 84 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25804 | 196403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 140 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.407711985019 | (37.7757364574022, -122.407711985019) | 8 | 2 | 9 | 28853 | 34 | |||
41243 | 196386 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | 6 | 2 | 9 | 28856 | 6 | |||
41313 | 196392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013963.53714 | 2112927.48749 | 37.7824813907387 | -122.395346527235 | (37.7824813907387, -122.395346527235) | 6 | 2 | 9 | 28856 | 6 | |||
43932 | 196384 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 3 | : | Tree | Private 2 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.7819454154917 | -122.396070069587 | (37.7819454154917, -122.396070069587) | 6 | 2 | 9 | 28856 | 6 | |||
54703 | 196389 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | 6 | 2 | 9 | 28856 | 6 | |||
54779 | 196387 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013895.88765 | 2112864.30367 | 37.7823041397518 | -122.395576138553 | (37.7823041397518, -122.395576138553) | 6 | 2 | 9 | 28856 | 6 | |||
60398 | 214424 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 732 Shields St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992045.19947 | 2089870.88734 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | 9 | 8 | 6 | 64 | 24 | |||
76543 | 196398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 3 | : | Tree | Private 2 | 1 | Width 2ft | 6011290.67787 | 2111282.09016 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | 14 | 2 | 9 | 28856 | 34 | |||
81494 | 196402 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 136 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010324.85595 | 2110562.99084 | 37.7757859938593 | -122.407768059545 | (37.7757859938593, -122.407768059545) | 8 | 2 | 9 | 28853 | 34 | |||
84781 | 196394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 497 03rd St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.7813354799985 | -122.396043249122 | (37.7813354799985, -122.396043249122) | 6 | 2 | 9 | 28856 | 34 | |||
90958 | 196383 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 172 Clara St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6012113.23171 | 2112074.9324 | 37.7800373904398 | -122.401687873618 | (37.7800373904398, -122.401687873618) | 6 | 2 | 9 | 28856 | 34 | |||
101088 | 238007 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150 Saint Germain Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997631.46598 | 2104146.92887 | 37.7574503533568 | -122.451214671841 | (37.7574503533568, -122.451214671841) | 15 | 5 | 4 | 28862 | 38 | |||
102372 | 196395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Clara St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.403901990095 | (37.7782984271806, -122.403901990095) | 14 | 2 | 9 | 28856 | 34 | |||
119235 | 196388 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.7823484529672 | -122.395514731015 | (37.7823484529672, -122.395514731015) | 6 | 2 | 9 | 28856 | 6 | |||
120605 | 196385 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013873.09616 | 2112844.01572 | 37.7822471659153 | -122.395653565657 | (37.7822471659153, -122.395653565657) | 6 | 2 | 9 | 28856 | 6 | |||
129196 | 214423 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Bright St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993753.59221 | 2090152.37899 | 37.7188020135797 | -122.463610156194 | (37.7188020135797, -122.463610156194) | 9 | 8 | 6 | 64 | 24 | |||
132070 | 196404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009690.27769 | 2108658.23097 | 37.7705204219146 | -122.409828750806 | (37.7705204219146, -122.409828750806) | 8 | 2 | 9 | 28853 | 34 | |||
145706 | 196390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.395437303898 | (37.7824096464379, -122.395437303898) | 6 | 2 | 9 | 28856 | 6 | |||
150236 | 196391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | 6 | 2 | 9 | 28856 | 6 | |||
153987 | 196405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6009655.4576 | 2108693.13255 | 37.7706143021254 | -122.409951658457 | (37.7706143021254, -122.409951658457) | 8 | 2 | 9 | 28853 | 34 | |||
157184 | 247776 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 228 30th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | 2 | 7 | 5 | 63 | 22 | |||
159550 | 196401 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 403 06th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.403950175767 | (37.7770436561708, -122.403950175767) | 14 | 2 | 9 | 28853 | 34 | |||
170729 | 214422 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Bright St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | 9 | 8 | 6 | 64 | 24 | |||
171303 | 196396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | 14 | 2 | 9 | 28856 | 34 | |||
173650 | 196397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6011301.22079 | 2111291.73097 | 37.7778415553936 | -122.404441855801 | (37.7778415553936, -122.404441855801) | 14 | 2 | 9 | 28856 | 34 | |||
174208 | 196399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 380 Clara St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6011297.10381 | 2111266.2805 | 37.7777714442324 | -122.404454306035 | (37.7777714442324, -122.404454306035) | 14 | 2 | 9 | 28856 | 34 | |||
181908 | 196393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013990.37233 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | 6 | 2 | 9 | 28856 | 6 | |||
78261 | 250308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10 Redfield Aly | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.414769923808 | (37.8002391853351, -122.414769923808) | 5 | 1 | 10 | 308 | 32 | |||
120908 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | 9 | 7 | 6 | 28861 | 5 | ||||
159825 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard | Tree | Private 2 | 2 | 6003946.78636 | 2094329.77315 | 37.7308542770831 | -122.428673970523 | (37.7308542770831, -122.428673970523) | 9 | 7 | 6 | 28861 | 5 | ||||
165425 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard | Tree | Private 2 | 3 | 6003967.55773 | 2094330.40491 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | 9 | 7 | 6 | 28861 | 5 | ||||
59660 | 89359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 308 Tocoloma Ave | 3 | Front Yard : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.398393755853 | (37.7112369933076, -122.398393755853) | 10 | 3 | 8 | 309 | 1 | ||
104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
59436 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 261 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176 | 37.7444805424074 | -122.409394598776 | (37.7444805424074, -122.409394598776) | 2 | 7 | 7 | 28859 | 2 | ||
112489 | 249683 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.444853713047 | (37.7935581209611, -122.444853713047) | 13 | 9 | 1 | 57 | 27 | ||||
155555 | 249682 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 5999744.12671 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | 13 | 9 | 1 | 57 | 27 | ||||
192462 | 249684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 16 | Front Yard : Yard | Tree | Private 2 | 5 | 5999742.63307 | 2117264.679 | 37.7935890018918 | -122.44485636243 | (37.7935890018918, -122.44485636243) | 13 | 9 | 1 | 57 | 27 | ||||
158880 | 96804 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200X Revere Ave | 1 | Median : | Tree | DPW 1 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.382735217758 | (37.7276042330013, -122.382735217758) | 10 | 3 | 8 | 58 | 1 | |||||
6947 | 23903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | 13 | 9 | 11 | 29490 | 13 | |||
7650 | 28640 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 2 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.7827766127993 | -122.430825656777 | (37.7827766127993, -122.430825656777) | 15 | 9 | 11 | 29490 | 41 | ||
14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
29559 | 16687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 2 | 5992496.9362665 | 2103468.0481268 | 37.7552910027695 | -122.468922364571 | (37.7552910027695, -122.468922364571) | 1 | 8 | 4 | 56 | 12 | |||
45064 | 28647 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.7858859308492 | -122.431484021877 | (37.7858859308492, -122.431484021877) | 13 | 9 | 11 | 29490 | 13 | |||
47389 | 87404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 9 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.7832373349481 | -122.430947098227 | (37.7832373349481, -122.430947098227) | 15 | 9 | 11 | 29490 | 41 | ||
58755 | 178902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.7214973572857 | -122.401224985361 | (37.7214973572857, -122.401224985361) | 10 | 3 | 8 | 309 | 28 | |||
59666 | 87403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 8 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | 15 | 9 | 11 | 29490 | 41 | ||
62448 | 11188 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995291.08877 | 2099424.10153 | 37.7443483813689 | -122.458966630003 | (37.7443483813689, -122.458966630003) | 1 | 8 | 4 | 59 | 40 | |||
81051 | 28643 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 5 | Median : Cutout | Tree | DPW 1 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.430881399332 | (37.7829985565916, -122.430881399332) | 15 | 9 | 11 | 29490 | 41 | |||
83697 | 11186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | 1 | 8 | 4 | 59 | 40 | |||
106692 | 13415 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 430 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 25 | 5 | 5999619.6561933 | 2097087.2734829 | 37.7381798806191 | -122.443831547884 | (37.7381798806191, -122.443831547884) | 9 | 7 | 4 | 59 | 40 | |||
112566 | 23490 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2500X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6005777.87956 | 2119177.13076 | 37.7991826887835 | -122.424109961515 | (37.7991826887835, -122.424109961515) | 13 | 9 | 1 | 28858 | 32 | |||
130770 | 28641 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 3 | Median : Cutout | Tree | DPW 1 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | 15 | 9 | 11 | 29490 | 41 | |||
145615 | 138849 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 650x WEBSTER ST | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004012.6112 | 2111066.8822 | 37.7768141659098 | -122.429639652936 | (37.7768141659098, -122.429639652936) | 7 | 9 | 11 | 28852 | 10 | |||
147402 | 178903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011814.45609 | 2090752.08936 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | 10 | 7 | 8 | 309 | 28 | |||
148815 | 28644 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 6 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003694.7628 | 2113348.3634 | 37.7830605429851 | -122.430902047868 | (37.7830605429851, -122.430902047868) | 15 | 9 | 11 | 29490 | 41 | ||
164897 | 199981 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200x Shafter Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.383326145908 | (37.7268412531355, -122.383326145908) | 10 | 3 | 8 | 58 | 1 | |||
176433 | 199678 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1400x Underwood Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.7277182533007 | -122.388192580507 | (37.7277182533007, -122.388192580507) | 10 | 3 | 8 | 58 | 1 | |||
187173 | 28648 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 10 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003548.747 | 2114394.8281 | 37.7859255976047 | -122.431481932616 | (37.7859255976047, -122.431481932616) | 13 | 9 | 11 | 29490 | 13 | ||
189426 | 11200 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 186 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
3027 | 214407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 11 | Median : Yard | Tree | DPW 1 | 8 | 5993812.00581 | 2096497.75562 | 37.7362282335302 | -122.463868579087 | (37.7362282335302, -122.463868579087) | 1 | 8 | 4 | 59 | 40 | ||||
58048 | 214406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 10 | Median : Yard | Tree | DPW 1 | 2 | 5993802.78615 | 2096495.7432 | 37.7362221766131 | -122.463900308969 | (37.7362221766131, -122.463900308969) | 1 | 8 | 4 | 59 | 40 | ||||
69218 | 196424 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1427x Innes Ave | 31 | Median : Yard | Tree | DPW 1 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | 10 | 3 | 8 | 58 | 1 | ||||
76819 | 214405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 9 | Median : Yard | Tree | DPW 1 | 2 | 5993807.85396 | 2096495.95192 | 37.7362230417557 | -122.463882802747 | (37.7362230417557, -122.463882802747) | 1 | 8 | 4 | 59 | 40 | ||||
132799 | 214408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Idora Ave | 20 | Median : Yard | Tree | DPW 1 | 3 | Width 9ft | 5995751.65358 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | 1 | 8 | 4 | 59 | 40 | |||
88001 | 250309 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 12 Redfield Aly | 1 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | 5 | 1 | 10 | 308 | 32 | |||
88113 | 214455 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 449 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6000738.08484 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | 9 | 7 | 5 | 63 | 40 | |||
150459 | 214463 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 714 Detroit St | 12 | Side Yard : Yard | Tree | Private 2 | 5 | 5999453.46925 | 2095428.53746 | 37.7336159026397 | -122.44428697109 | (37.7336159026397, -122.44428697109) | 9 | 7 | 4 | 63 | 40 | ||||
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
339 | 18096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.7864812852303 | -122.445770680231 | (37.7864812852303, -122.445770680231) | 15 | 6 | 1 | 29490 | 31 | ||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
523 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | 1 | 8 | 3 | 29491 | 35 | ||
655 | 73536 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | 1 | 8 | 3 | 29491 | 35 | |||
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
940 | 71166 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2123 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100838.0598 | 37.747820074212 | -122.483618518196 | (37.747820074212, -122.483618518196) | 1 | 8 | 3 | 29491 | 35 | |||
1003 | 72752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988097.7754 | 2104798.077 | 37.758687755803 | -122.484233325891 | (37.758687755803, -122.484233325891) | 1 | 8 | 3 | 56 | 35 | |||
1086 | 91876 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2015 02:50:00 PM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.7641372031802 | -122.465280687147 | (37.7641372031802, -122.465280687147) | 11 | 8 | 11 | 56 | 12 | ||
1301 | 183453 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2519 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989212.7579 | 2098154.5204 | 37.7405111636594 | -122.4798910928 | (37.7405111636594, -122.4798910928) | 1 | 8 | 3 | 29491 | 35 | |||
1474 | 86100 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2628 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097431.8111 | 37.738512846905 | -122.480667939289 | (37.738512846905, -122.480667939289) | 1 | 8 | 3 | 29491 | 35 | ||
1475 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.491255586179 | (37.735588983385, -122.491255586179) | 1 | 8 | 3 | 64 | 35 | |||
1659 | 65957 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2451 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 6 | Permit Number 28979 | 5987645.5214 | 2098612.1125 | 37.7416764134378 | -122.485343487905 | (37.7416764134378, -122.485343487905) | 1 | 8 | 3 | 29491 | 35 | ||
1668 | 86560 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.485018839299 | (37.7522790893532, -122.485018839299) | 1 | 8 | 3 | 56 | 35 | ||
1697 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988223 | (37.7356241060746, -122.49141988223) | 1 | 8 | 3 | 29491 | 35 | ||
1745 | 72898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2476 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990180.6745 | 2098530.744 | 37.7416003626627 | -122.476571927541 | (37.7416003626627, -122.476571927541) | 1 | 8 | 3 | 29491 | 35 | |||
1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
1818 | 38898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.7833176557587 | -122.454612555673 | (37.7833176557587, -122.454612555673) | 11 | 6 | 1 | 54 | 31 | |
1828 | 98097 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.7891705031567 | -122.420050723983 | (37.7891705031567, -122.420050723983) | 13 | 9 | 10 | 28858 | 21 | |||
1869 | 71210 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988533.228 | 2099925.3582 | 37.7453339163785 | -122.482370330567 | (37.7453339163785, -122.482370330567) | 1 | 8 | 3 | 29491 | 35 | |||
2005 | 23894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | 13 | 9 | 11 | 29490 | 13 | ||
2074 | 64926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.3095246 | 2099579.02126823 | 37.7445543038697 | -122.472133919026 | (37.7445543038697, -122.472133919026) | 1 | 8 | 4 | 29491 | 40 | ||
2220 | 117168 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
2384 | 61000 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | 3x3 | Permit Number 20813 | 6003055.65980298 | 2095965.62236934 | 37.7352954735478 | -122.43187149765 | (37.7352954735478, -122.43187149765) | 2 | 7 | 5 | 63 | 7 | |
2537 | 245955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997557.5774 | 2107478.8878 | 37.7665948394439 | -122.45171055689 | (37.7665948394439, -122.45171055689) | 15 | 5 | 11 | 29492 | 9 | |||
2591 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | 1 | 8 | 3 | 64 | 35 | ||
2833 | 47893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.441904890309 | (37.7779961374161, -122.441904890309) | 15 | 5 | 11 | 29490 | 16 | |
3061 | 214398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994265.55246 | 2098714.72698 | 37.7423416116873 | -122.46246124889 | (37.7423416116873, -122.46246124889) | 1 | 8 | 4 | 59 | 40 | |||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
3161 | 68640 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32545 | 5990599.2738678 | 2102847.22998444 | 37.7534765784204 | -122.475439654249 | (37.7534765784204, -122.475439654249) | 1 | 8 | 4 | 56 | 12 | ||
3201 | 52387 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48512 | 6005694.4540201 | 2096630.70014958 | 37.7372708656751 | -122.422795452389 | (37.7372708656751, -122.422795452389) | 2 | 7 | 7 | 28859 | 2 | ||
3297 | 183411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2350 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5985672.7267 | 2097039.7501 | 37.737243998747 | -122.492048913642 | (37.737243998747, -122.492048913642) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );