trees
272 rows where Supervisor Districts = 5 and qSpecies_id = 50 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121342 | 226766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005428.90079 | 2099643.28917 | 37.7455277666988 | -122.423927754381 | (37.7455277666988, -122.423927754381) | 2 | 7 | 5 | 28859 | 22 | |||
121690 | 229856 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005420.32438 | 2102982.74414 | 37.7546966562501 | -122.424194867403 | (37.7546966562501, -122.424194867403) | 2 | 4 | 5 | 28859 | 19 | |||
123496 | 226373 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4222 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002349.44402 | 2100642.72182 | 37.7480976397016 | -122.434647475301 | (37.7480976397016, -122.434647475301) | 2 | 4 | 5 | 28862 | 22 | |||
123697 | 229858 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005418.69368 | 2103014.66569 | 37.7547842133232 | -122.424202776932 | (37.7547842133232, -122.424202776932) | 2 | 4 | 5 | 28859 | 19 | |||
124976 | 226779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003146.24554 | 2105369.35546 | 37.76112105592 | -122.432229675877 | (37.76112105592, -122.432229675877) | 15 | 4 | 5 | 28862 | 3 | |||
127610 | 226368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002219.8956 | 2101222.17774 | 37.7496813332396 | -122.43513688726 | (37.7496813332396, -122.43513688726) | 2 | 4 | 5 | 28862 | 22 | |||
128537 | 229878 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | 2 | 7 | 5 | 63 | 22 | |||
129006 | 226794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001783.4277 | 2104311.13216 | 37.7581380667326 | -122.4368673106 | (37.7581380667326, -122.4368673106) | 2 | 4 | 5 | 28862 | 3 | |||
130054 | 229852 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005555.32091 | 2102533.44251 | 37.7534705997005 | -122.423696068331 | (37.7534705997005, -122.423696068331) | 2 | 4 | 5 | 28859 | 19 | |||
130410 | 229841 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6005193.66428 | 2104309.81334 | 37.7583276770852 | -122.425073138141 | (37.7583276770852, -122.425073138141) | 2 | 4 | 5 | 28859 | 19 | |||
130979 | 226810 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003888.71107 | 2106689.12082 | 37.7647868841307 | -122.429755942181 | (37.7647868841307, -122.429755942181) | 8 | 4 | 5 | 28862 | 3 | |||
131153 | 226364 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001531.18753 | 2100555.73376 | 37.7478123046113 | -122.437470743076 | (37.7478123046113, -122.437470743076) | 2 | 4 | 5 | 63 | 22 | |||
131236 | 226814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003182.02121 | 2107933.96626 | 37.7681648843321 | -122.432289109354 | (37.7681648843321, -122.432289109354) | 15 | 5 | 5 | 28862 | 3 | |||
132381 | 229787 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005558.49234 | 2107230.4627 | 37.7663676926515 | -122.424019094899 | (37.7663676926515, -122.424019094899) | 8 | 4 | 5 | 28853 | 19 | |||
134963 | 229795 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004958.17286 | 2108195.3416 | 37.7689831073039 | -122.426164188445 | (37.7689831073039, -122.426164188445) | 8 | 4 | 5 | 28853 | 19 | |||
135145 | 226365 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001939.89483 | 2100487.05511 | 37.7476469570616 | -122.436052541887 | (37.7476469570616, -122.436052541887) | 2 | 4 | 5 | 63 | 22 | |||
136734 | 229853 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6005411.70889 | 2102466.72114 | 37.7532792905247 | -122.424187965125 | (37.7532792905247, -122.424187965125) | 2 | 4 | 5 | 28859 | 19 | |||
138763 | 226797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003894.50507 | 2104240.41525 | 37.7580636523416 | -122.429561252457 | (37.7580636523416, -122.429561252457) | 2 | 4 | 5 | 28862 | 3 | |||
139345 | 226820 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214 | -122.426592230667 | (37.740029548214, -122.426592230667) | 2 | 7 | 5 | 63 | 7 | |||
140045 | 226369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | 2 | 4 | 5 | 28862 | 22 | |||
140189 | 226761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005532.06027 | 2099607.16908 | 37.7454344125679 | -122.423568476998 | (37.7454344125679, -122.423568476998) | 2 | 7 | 5 | 28859 | 22 | |||
140480 | 226425 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005988.79838 | 2101974.74893 | 37.7519610156893 | -122.422157319311 | (37.7519610156893, -122.422157319311) | 2 | 4 | 5 | 28859 | 19 | |||
140532 | 226793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.14773 | 2103676.31571 | 37.7564148838461 | -122.435612414605 | (37.7564148838461, -122.435612414605) | 2 | 4 | 5 | 28862 | 3 | |||
148052 | 229872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004865.55222 | 2102495.62663 | 37.7533278053416 | -122.426078745663 | (37.7533278053416, -122.426078745663) | 2 | 4 | 5 | 28862 | 22 | |||
149017 | 226776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 16 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6004065.40509 | 2102868.59003 | 37.7543066193819 | -122.428872407741 | (37.7543066193819, -122.428872407741) | 2 | 4 | 5 | 28862 | 22 | |||
150983 | 229845 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005155.25082 | 2103726.26853 | 37.756723229919 | -122.425164466987 | (37.756723229919, -122.425164466987) | 2 | 4 | 5 | 28859 | 19 | |||
151810 | 226467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 11 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726947 | (37.7455007798334, -122.42261726947) | 2 | 7 | 5 | 28859 | 22 | |||
153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
153280 | 226762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005544.98011 | 2099653.84342 | 37.7455632989187 | -122.423527119901 | (37.7455632989187, -122.423527119901) | 2 | 7 | 5 | 28859 | 22 | |||
153755 | 226788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.7602161904576 | -122.43597676864 | (37.7602161904576, -122.43597676864) | 2 | 4 | 5 | 28862 | 3 | |||
155526 | 226784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003023.04842 | 2105091.71244 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | 2 | 4 | 5 | 28862 | 3 | |||
156001 | 226798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003742.96223 | 2104233.19003 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | 2 | 4 | 5 | 28862 | 3 | |||
156427 | 229873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3571 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004534.15788 | 2103646.15858 | 37.7564681605797 | -122.427306727641 | (37.7564681605797, -122.427306727641) | 2 | 4 | 5 | 28862 | 22 | |||
156574 | 226370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.436090732519 | (37.7499246016413, -122.436090732519) | 2 | 4 | 5 | 28862 | 22 | |||
157178 | 229840 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508 | (37.7583780804987, -122.42428471508) | 2 | 4 | 5 | 28859 | 19 | |||
157299 | 226765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | 2 | 7 | 5 | 28861 | 25 | |||
157854 | 226806 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Storrie St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6000773.9022 | 2105295.69732 | 37.7607840134024 | -122.440429287805 | (37.7607840134024, -122.440429287805) | 15 | 4 | 5 | 28862 | 3 | |||
157868 | 226819 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | 15 | 5 | 5 | 29492 | 9 | |||
158762 | 229744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006129.97006 | 2100227.10081 | 37.7471703352582 | -122.421545017711 | (37.7471703352582, -122.421545017711) | 2 | 7 | 5 | 28859 | 22 | |||
162653 | 251225 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x2.5 | 6000238 | 2104757 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | 2 | 4 | 5 | 28862 | 3 | ||||
163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
166424 | 229855 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005458.16704 | 2101659.72097 | 37.7510660778443 | -122.42396992087 | (37.7510660778443, -122.42396992087) | 2 | 4 | 5 | 28859 | 19 | |||
167928 | 226763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.423709577049 | (37.7463491139326, -122.423709577049) | 2 | 7 | 5 | 28859 | 22 | |||
168291 | 229850 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005369.98342 | 2103227.02308 | 37.7553645467641 | -122.424386333963 | (37.7553645467641, -122.424386333963) | 2 | 4 | 5 | 28859 | 19 | |||
168980 | 226358 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.421699497839 | (37.7462380152724, -122.421699497839) | 2 | 7 | 5 | 28859 | 2 | |||
169196 | 226795 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002427.79388 | 2104301.04841 | 37.7581469808114 | -122.434638096272 | (37.7581469808114, -122.434638096272) | 2 | 4 | 5 | 28862 | 3 | |||
170230 | 229874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004568.82488 | 2103108.44768 | 37.7549936933086 | -122.42714853777 | (37.7549936933086, -122.42714853777) | 2 | 4 | 5 | 28862 | 22 | |||
175338 | 226824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003840.68463 | 2095954.97206 | 37.7353107011233 | -122.429156618694 | (37.7353107011233, -122.429156618694) | 2 | 7 | 5 | 63 | 7 | |||
176654 | 226367 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.7523360311927 | -122.438680460736 | (37.7523360311927, -122.438680460736) | 2 | 4 | 5 | 28862 | 22 | |||
181243 | 226780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3980 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003123.97049 | 2105369.10011 | 37.7611190917893 | -122.432306697403 | (37.7611190917893, -122.432306697403) | 15 | 4 | 5 | 28862 | 3 | |||
181529 | 229746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 6005420.74895 | 2100228.937 | 37.7471353615169 | -122.423997581329 | (37.7471353615169, -122.423997581329) | 2 | 7 | 5 | 28859 | 22 | |||
184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
185908 | 226777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004194.76383 | 2103338.46367 | 37.7556041027521 | -122.428458541531 | (37.7556041027521, -122.428458541531) | 2 | 4 | 5 | 28862 | 22 | |||
186292 | 226801 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | 2 | 4 | 5 | 28862 | 3 | |||
186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
188574 | 226773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.7530417058104 | -122.432759865801 | (37.7530417058104, -122.432759865801) | 2 | 4 | 5 | 28862 | 22 | |||
190748 | 229846 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005141.9373 | 2103725.25099 | 37.7567196838778 | -122.425210437638 | (37.7567196838778, -122.425210437638) | 2 | 4 | 5 | 28859 | 19 | |||
191205 | 226361 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005760.58737 | 2103420.35055 | 37.7559174283599 | -122.423049246236 | (37.7559174283599, -122.423049246236) | 2 | 4 | 5 | 28859 | 19 | |||
133178 | 108708 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.85423 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | 2 | 4 | 5 | 63 | 22 | |
109741 | 39737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
130336 | 39735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
78982 | 50683 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | 15 | 5 | 5 | 29492 | 9 | |||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
40238 | 46344 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | 2 | 4 | 5 | 28859 | 19 | ||
49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
181262 | 35309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38777 | 6005480.32103823 | 2105501.15439096 | 37.7616150083325 | -122.424166477384 | (37.7616150083325, -122.424166477384) | 8 | 4 | 5 | 28859 | 19 | ||
152582 | 41339 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 791 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 8 | Permit Number 41992 | 6002462.02491535 | 2103606.38445454 | 37.7562415435961 | -122.434470043403 | (37.7562415435961, -122.434470043403) | 2 | 4 | 5 | 28862 | 3 | ||
29492 | 94652 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847 | 2095961 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) | 2 | 7 | 5 | 63 | 7 |
11638 | 95638 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462 | 2107407 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | 8 | 4 | 5 | 28862 | 3 | |
79369 | 95629 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767396 | 6004866 | 2102499 | 37.753337093137 | -122.426077437274 | (37.753337093137, -122.426077437274) | 2 | 4 | 5 | 28862 | 22 | |
80034 | 95634 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767401 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
130082 | 95630 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767398 | 6004828 | 2102496 | 37.753326708053 | -122.426208635682 | (37.753326708053, -122.426208635682) | 2 | 4 | 5 | 28862 | 22 | |
166276 | 95624 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767391 | 6005934 | 2105520 | 37.761692359374 | -122.422598723522 | (37.761692359374, -122.422598723522) | 8 | 4 | 5 | 28859 | 19 | |
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
39458 | 67919 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085455 | -122.427629821288 | (37.734399085455, -122.427629821288) | 2 | 7 | 5 | 28861 | 25 | ||
49433 | 66285 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | 2 | 7 | 5 | 28861 | 25 | ||
13239 | 35575 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.423142532595 | (37.7559036789868, -122.423142532595) | 2 | 4 | 5 | 28859 | 19 | |
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
156239 | 35551 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
165980 | 35552 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
172051 | 35555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
116513 | 220576 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4248 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781634 | 6002235.87131 | 2101222.78245 | 37.7496839007903 | -122.435081685973 | (37.7496839007903, -122.435081685973) | 2 | 4 | 5 | 28862 | 22 | |
145866 | 91415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 46 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2009 12:00:00 AM | 3x3 | Permit Number 52098 | 6003215 | 2107427 | 37.7667747483278 | -122.432138830712 | (37.7667747483278, -122.432138830712) | 15 | 5 | 5 | 28862 | 3 | ||
6567 | 45 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1990 12:00:00 AM | 12 | 3x3 | 6003436.52432 | 2107742.06145 | 37.7676523876611 | -122.431395108624 | (37.7676523876611, -122.431395108624) | 15 | 5 | 5 | 28862 | 3 | ||
110649 | 64206 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | Permit No. 49278 | 6001454.61421942 | 2102939.02028788 | 37.7543518855401 | -122.437906209203 | (37.7543518855401, -122.437906209203) | 2 | 4 | 5 | 28862 | 22 | |||
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
89909 | 40262 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45085 | 6005347.95435348 | 2101987.4938302 | 37.7519598434296 | -122.424374358675 | (37.7519598434296, -122.424374358675) | 2 | 4 | 5 | 28859 | 19 | ||
132383 | 42046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | 2 | 7 | 5 | 28859 | 22 | ||
40413 | 40242 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
61584 | 40245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
85186 | 40244 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
101368 | 40260 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41418 | 6006042.36187531 | 2101970.77964266 | 37.7519531379729 | -122.421971806823 | (37.7519531379729, -122.421971806823) | 2 | 4 | 5 | 28859 | 19 | ||
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 |
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) );