trees
170 rows where qSpecies_id = 232 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129510 | 129548 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6011012.0164 | 2118485.67299 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | 3 | 1 | 10 | 308 | 23 | |||
24261 | 218286 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1 Woodacre Dr | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5991335.90639 | 2095594.80509 | 37.7336059570417 | -122.472363586812 | (37.7336059570417, -122.472363586812) | 1 | 8 | 4 | 64 | 40 | ||||
69895 | 226640 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 10 Crescent Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6005282.96903 | 2095902.79944 | 37.7352489878562 | -122.424166394858 | (37.7352489878562, -122.424166394858) | 2 | 7 | 7 | 28859 | 2 | |||
8735 | 129545 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 10 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010092.54789 | 2116944.91924 | 37.7932962437837 | -122.409022077819 | (37.7932962437837, -122.409022077819) | 3 | 1 | 10 | 28857 | 4 | |||
99522 | 35353 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1023 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2013 12:00:00 AM | 1 | Permit Number 770231 | 6011656.23225 | 2103580.24733 | 37.7566873964196 | -122.40267130025 | (37.7566873964196, -122.40267130025) | 10 | 3 | 8 | 28856 | 29 | |
164023 | 129530 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1040 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6007879.71026 | 2119961.12323 | 37.8014537818135 | -122.416892463243 | (37.8014537818135, -122.416892463243) | 5 | 1 | 10 | 308 | 32 | |||
75259 | 121971 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 106 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991185.18904 | 2114684.00966 | 37.7860111230721 | -122.474277122949 | (37.7860111230721, -122.474277122949) | 11 | 6 | 2 | 54 | 26 | |||
116946 | 59609 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1063 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 5 | Permit Number 19011 | 6015560.85054 | 2104166.3389 | 37.7585139078159 | -122.389208516653 | (37.7585139078159, -122.389208516653) | 10 | 3 | 8 | 28856 | 29 | ||
22513 | 129523 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006484.20699 | 2120406.53709 | 37.8025981808314 | -122.42175319366 | (37.8025981808314, -122.42175319366) | 5 | 9 | 1 | 28858 | 32 | |||
92441 | 129524 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006507.13928 | 2120407.78108 | 37.8026028896668 | -122.421673924708 | (37.8026028896668, -122.421673924708) | 5 | 9 | 1 | 28858 | 32 | |||
129834 | 129525 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1109 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006520.95763 | 2120409.72682 | 37.8026090113668 | -122.421626244478 | (37.8026090113668, -122.421626244478) | 5 | 9 | 1 | 28858 | 32 | |||
158349 | 226658 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 117 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003646.08487 | 2097679.68219 | 37.7400353434466 | -122.429952409889 | (37.7400353434466, -122.429952409889) | 2 | 7 | 5 | 63 | 7 | |||
168271 | 226657 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 117 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003659.76941 | 2097669.44697 | 37.74000801486 | -122.42990436449 | (37.74000801486, -122.42990436449) | 2 | 7 | 5 | 63 | 7 | |||
42346 | 226637 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1199 Capp St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6007225.31017 | 2100622.72822 | 37.7483183396245 | -122.417785447755 | (37.7483183396245, -122.417785447755) | 2 | 4 | 7 | 28859 | 19 | |||
115948 | 191430 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 12 Augusta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6011384.73848 | 2095507.87401 | 37.7345072405216 | -122.403042454946 | (37.7345072405216, -122.403042454946) | 10 | 3 | 8 | 58 | 1 | |||
96764 | 226656 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 121 Moffitt St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6002727.92534 | 2096681.4535 | 37.7372423972127 | -122.433055722954 | (37.7372423972127, -122.433055722954) | 2 | 7 | 5 | 63 | 7 | |||
67356 | 226651 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1210 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997784.11523 | 2106211.61184 | 37.7631281925414 | -122.450835621062 | (37.7631281925414, -122.450835621062) | 15 | 5 | 11 | 29492 | 9 | |||
185616 | 226650 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1210 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997776.79189 | 2106261.76861 | 37.7632654911199 | -122.450864566663 | (37.7632654911199, -122.450864566663) | 15 | 5 | 11 | 29492 | 9 | |||
152109 | 177029 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 123 Seneca Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6000050.76247 | 2090072.63848 | 37.7189438978236 | -122.441837691751 | (37.7189438978236, -122.441837691751) | 9 | 7 | 6 | 28861 | 25 | |||
172472 | 129522 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1240 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006403.02216 | 2120103.20622 | 37.8017607330441 | -122.422012573438 | (37.8017607330441, -122.422012573438) | 5 | 9 | 1 | 28858 | 32 | |||
27116 | 177037 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 125 Goettingen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009971.552 | 2093934.84647 | 37.7301090233129 | -122.407817447612 | (37.7301090233129, -122.407817447612) | 10 | 3 | 7 | 309 | 28 | |||
153258 | 207366 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5990777.74909 | 2106795.52344 | 37.7643278872345 | -122.475110663153 | (37.7643278872345, -122.475110663153) | 11 | 8 | 3 | 56 | 12 | |||
75373 | 129547 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 13 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6010075.14286 | 2116919.1763 | 37.7932245849005 | -122.409080483394 | (37.7932245849005, -122.409080483394) | 3 | 1 | 10 | 28857 | 4 | |||
123299 | 129546 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 13 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6010072.19276 | 2116933.78445 | 37.7932645300763 | -122.409091722221 | (37.7932645300763, -122.409091722221) | 3 | 1 | 10 | 28857 | 4 | |||
97823 | 16365 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1306X Montgomery St | 18 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011450.07983 | 2119965.49195 | 37.8016659588815 | -122.404537624619 | (37.8016659588815, -122.404537624619) | 3 | 1 | 10 | 308 | 23 | |||
135366 | 129537 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1306x Montgomery St | 22 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | 3 | 1 | 10 | 308 | 23 | |||
15496 | 58940 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1360 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1980 12:00:00 AM | 2 | Permit Number 18218 | 6011963.90217 | 2102042.40825 | 37.7524820001659 | -122.401499182338 | (37.7524820001659, -122.401499182338) | 10 | 3 | 8 | 28856 | 29 | |
133526 | 226642 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 14 Cumberland St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6005484.04077 | 2104618.29186 | 37.759191085608 | -122.424090824831 | (37.759191085608, -122.424090824831) | 2 | 4 | 5 | 28859 | 19 | |||
65138 | 129535 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1420 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011436.62121 | 2120241.6491 | 37.8024234668433 | -122.404603649235 | (37.8024234668433, -122.404603649235) | 3 | 1 | 10 | 308 | 23 | |||
58621 | 10231 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1440 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 2x2 | 6005821.60814 | 2100602.13393 | 37.7481826984823 | -122.422637956596 | (37.7481826984823, -122.422637956596) | 2 | 4 | 5 | 28859 | 19 | |||
89082 | 129536 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1440 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011432.08366 | 2120273.70789 | 37.8025112388511 | -122.404621609616 | (37.8025112388511, -122.404621609616) | 3 | 1 | 10 | 308 | 23 | |||
175114 | 226639 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 145 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6007521.18601 | 2099614.94215 | 37.7455678314934 | -122.416690930545 | (37.7455678314934, -122.416690930545) | 2 | 7 | 7 | 28859 | 2 | ||||
161471 | 226648 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1488 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005200.77027 | 2099715.54685 | 37.7457132878504 | -122.424721734337 | (37.7457132878504, -122.424721734337) | 2 | 7 | 5 | 63 | 22 | |||
31336 | 177035 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6009505.01631 | 2094936.0613 | 37.7328320166696 | -122.409500962316 | (37.7328320166696, -122.409500962316) | 10 | 3 | 7 | 309 | 28 | |||
72877 | 177036 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009502.62349 | 2094943.72581 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | 10 | 3 | 7 | 309 | 28 | |||
30551 | 5710 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1609 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6005330.55919 | 2098925.54374 | 37.7435514489374 | -122.4242167677 | (37.7435514489374, -122.4242167677) | 2 | 7 | 5 | 28859 | 22 | |||
176966 | 42618 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1615 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 11 | Permit Number 42680 | 6005139.94855 | 2119525.30074 | 37.8001026358725 | -122.426342225416 | (37.8001026358725, -122.426342225416) | 13 | 9 | 1 | 57 | 17 | |
77216 | 15295 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1625 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6006990.72739 | 2109176.21889 | 37.7717910362903 | -122.41920328508 | (37.7717910362903, -122.41920328508) | 8 | 2 | 9 | 28853 | 19 | ||
59330 | 191427 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1627 20th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013091.09687 | 2104712.62895 | 37.7598766756903 | -122.397788409621 | (37.7598766756903, -122.397788409621) | 10 | 3 | 8 | 28856 | 29 | |||
89364 | 207365 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1678 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990916.62821 | 2103981.8612 | 37.7566103677027 | -122.474424980426 | (37.7566103677027, -122.474424980426) | 1 | 8 | 4 | 56 | 12 | |||
91779 | 191426 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1700 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6012934.52583 | 2103813.36642 | 37.7573987772601 | -122.39826682196 | (37.7573987772601, -122.39826682196) | 10 | 3 | 8 | 28856 | 29 | ||||
30862 | 129507 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1714 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004691.67913 | 2119164.8681 | 37.7990876313419 | -122.42786771393 | (37.7990876313419, -122.42786771393) | 13 | 9 | 1 | 57 | 17 | |||
41893 | 129509 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1714 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004669.81426 | 2119159.95033 | 37.7990728914709 | -122.427943023175 | (37.7990728914709, -122.427943023175) | 13 | 9 | 1 | 57 | 17 | |||
79227 | 129508 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1714 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004680.4249 | 2119161.32221 | 37.7990772585711 | -122.427906404578 | (37.7990772585711, -122.427906404578) | 13 | 9 | 1 | 57 | 17 | |||
4951 | 249501 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6006000.97948 | 2115886.86804 | 37.7901610488408 | -122.4231039628 | (37.7901610488408, -122.4231039628) | 13 | 9 | 1 | 28858 | 41 | |||
34613 | 249500 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005972.54693 | 2115883.04317 | 37.7901489421804 | -122.423202065344 | (37.7901489421804, -122.423202065344) | 13 | 9 | 1 | 28858 | 41 | |||
140273 | 249499 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1765 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005919.33859 | 2115875.5653 | 37.7901254069127 | -122.423385630445 | (37.7901254069127, -122.423385630445) | 13 | 9 | 1 | 28858 | 41 | |||
28025 | 177039 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 178 Seville St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | 9 | 7 | 6 | 28861 | 5 | |||
157434 | 207367 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2 Lurline St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992094.14756 | 2104940.13578 | 37.7593096900047 | -122.470422518894 | (37.7593096900047, -122.470422518894) | 1 | 8 | 4 | 56 | 12 | |||
2479 | 226638 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 201 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6007716.3532 | 2099510.69761 | 37.7452925742068 | -122.416008689563 | (37.7452925742068, -122.416008689563) | 2 | 7 | 7 | 28859 | 2 | |||
43340 | 226653 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 214 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999974.10738 | 2105629.30684 | 37.7616544501161 | -122.443219374174 | (37.7616544501161, -122.443219374174) | 15 | 5 | 5 | 28862 | 3 | |||
142786 | 129499 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2144 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002813.51527 | 2118209.06583 | 37.7963568183789 | -122.434298418735 | (37.7963568183789, -122.434298418735) | 13 | 9 | 1 | 57 | 17 | |||
173786 | 129500 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2144 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002804.88448 | 2118207.36125 | 37.7963516481611 | -122.434328161126 | (37.7963516481611, -122.434328161126) | 13 | 9 | 1 | 57 | 17 | |||
138546 | 129555 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011031.64459 | 2115258.30549 | 37.7887177673445 | -122.405653872146 | (37.7887177673445, -122.405653872146) | 5 | 1 | 10 | 28857 | 6 | |||
153511 | 129556 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011025.30596 | 2115257.2463 | 37.7887145046082 | -122.405675728365 | (37.7887145046082, -122.405675728365) | 5 | 1 | 10 | 28857 | 6 | |||
91613 | 191428 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 22 Robblee Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6012599.81478 | 2095974.63355 | 37.7358566435644 | -122.39887425376 | (37.7358566435644, -122.39887425376) | 10 | 3 | 8 | 58 | 1 | |||
129994 | 226654 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 220 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999922.0088 | 2105601.51229 | 37.7615751622837 | -122.443397564951 | (37.7615751622837, -122.443397564951) | 15 | 5 | 5 | 28862 | 3 | |||
130483 | 129532 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009758.75399 | 2121832.78165 | 37.8066984049805 | -122.410522343935 | (37.8066984049805, -122.410522343935) | 3 | 1 | 10 | 308 | 23 | |||
77691 | 129521 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2222 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000122.02291 | 2120260.78291 | 37.8018371520253 | -122.443758994388 | (37.8018371520253, -122.443758994388) | 13 | 9 | 1 | 57 | 17 | |||
38509 | 27387 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2222 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6007153.30759 | 2119954.57165 | 37.8013949068162 | -122.419405682544 | (37.8013949068162, -122.419405682544) | 5 | 1 | 1 | 28858 | 32 | |||
114668 | 27386 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2222 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6007153.46283 | 2119942.0708 | 37.8013605913839 | -122.419404257997 | (37.8013605913839, -122.419404257997) | 5 | 1 | 1 | 28858 | 32 | |||
25836 | 27388 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2238 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6007145.97631 | 2119998.36118 | 37.8015147288815 | -122.419434160451 | (37.8015147288815, -122.419434160451) | 5 | 1 | 1 | 28858 | 32 | |||
108113 | 120188 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 224 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987762.71943 | 2114453.05727 | 37.7851781269564 | -122.486100829584 | (37.7851781269564, -122.486100829584) | 11 | 6 | 2 | 55 | 26 | |||
179264 | 120189 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 224 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987764.62451 | 2114428.11322 | 37.785109748739 | -122.486092406972 | (37.785109748739, -122.486092406972) | 11 | 6 | 2 | 55 | 26 | |||
118240 | 226652 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 225 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999964.01354 | 2105579.20426 | 37.7615163052595 | -122.443250685888 | (37.7615163052595, -122.443250685888) | 15 | 5 | 5 | 28862 | 3 | |||
42690 | 27391 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2250 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007137.43653 | 2120063.48315 | 37.8016930563562 | -122.419468334714 | (37.8016930563562, -122.419468334714) | 5 | 1 | 1 | 28858 | 32 | |||
43760 | 27393 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2256 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007130.3947 | 2120101.32531 | 37.8017965647292 | -122.419495389019 | (37.8017965647292, -122.419495389019) | 5 | 1 | 1 | 28858 | 32 | |||
5482 | 72076 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 229 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5989910.70009 | 2113826.30511 | 37.7835821901674 | -122.478623713066 | (37.7835821901674, -122.478623713066) | 11 | 6 | 2 | 55 | 26 | |||
186456 | 226655 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 232 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999888.11878 | 2105582.87148 | 37.7615220465382 | -122.443513437219 | (37.7615220465382, -122.443513437219) | 15 | 5 | 5 | 28862 | 3 | |||
175292 | 177030 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 235 Ottawa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5998356.41955 | 2089266.50528 | 37.7166337499183 | -122.447636347658 | (37.7166337499183, -122.447636347658) | 9 | 7 | 6 | 28861 | 25 | |||
70889 | 191429 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2399 Lane St | 7 | Side Yard : Yard | Tree | Private 2 | 4 | 6013991.75526 | 2092879.90646 | 37.7274366158882 | -122.393845172923 | (37.7274366158882, -122.393845172923) | 10 | 3 | 8 | 58 | 1 | ||||
4624 | 75146 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010085.43601 | 2111100.02376 | 37.7772471547732 | -122.408634170555 | (37.7772471547732, -122.408634170555) | 8 | 2 | 9 | 28853 | 34 | |||
12598 | 75304 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010043.76488 | 2111144.47071 | 37.7773668617363 | -122.408781461497 | (37.7773668617363, -122.408781461497) | 8 | 2 | 9 | 28853 | 34 | |||
13461 | 75228 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010065.6483 | 2111120.54922 | 37.7773024046157 | -122.408704071262 | (37.7773024046157, -122.408704071262) | 8 | 2 | 9 | 28853 | 34 | |||
14988 | 75390 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010035.62368 | 2111155.67227 | 37.7773971625953 | -122.408810415165 | (37.7773971625953, -122.408810415165) | 8 | 2 | 9 | 28853 | 34 | |||
177220 | 9988 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005434.58987 | 2108720.51419 | 37.7704520212643 | -122.424553652838 | (37.7704520212643, -122.424553652838) | 8 | 2 | 5 | 28853 | 19 | |||
145552 | 129513 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Heather Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5997331.52493 | 2114270.89109 | 37.7852309644831 | -122.45298274797 | (37.7852309644831, -122.45298274797) | 15 | 6 | 1 | 54 | 31 | |||
151973 | 129510 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2500 Chestnut St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5999790.44594 | 2119530.29467 | 37.799812509208 | -122.444853861425 | (37.799812509208, -122.444853861425) | 13 | 9 | 1 | 57 | 17 | |||
48322 | 177031 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6005122.72167 | 2093818.53424 | 37.7295170103902 | -122.424572215729 | (37.7295170103902, -122.424572215729) | 9 | 7 | 6 | 28861 | 5 | |||
24375 | 129505 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2644 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000286.7796 | 2118548.86177 | 37.7971460678835 | -122.443065845515 | (37.7971460678835, -122.443065845515) | 13 | 9 | 1 | 57 | 17 | |||
117928 | 129506 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2644 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000302.575 | 2118552.44748 | 37.7971568138825 | -122.443011447325 | (37.7971568138825, -122.443011447325) | 13 | 9 | 1 | 57 | 17 | |||
94906 | 129503 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2656 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000257.59997 | 2118546.47471 | 37.7971378498799 | -122.443166642421 | (37.7971378498799, -122.443166642421) | 13 | 9 | 1 | 57 | 17 | |||
169135 | 129504 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2656 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000274.51269 | 2118548.19548 | 37.7971435390014 | -122.443108244054 | (37.7971435390014, -122.443108244054) | 13 | 9 | 1 | 57 | 17 | |||
33790 | 129527 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006554.47344 | 2120382.0459 | 37.802534896425 | -122.421508295689 | (37.802534896425, -122.421508295689) | 5 | 9 | 1 | 28858 | 32 | |||
118057 | 129528 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006558.18826 | 2120353.46017 | 37.802456616741 | -122.4214934092 | (37.802456616741, -122.4214934092) | 5 | 9 | 1 | 28858 | 32 | |||
127189 | 129526 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006553.85688 | 2120395.35345 | 37.8025714008062 | -122.421511374958 | (37.8025714008062, -122.421511374958) | 5 | 9 | 1 | 28858 | 32 | |||
156053 | 129529 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2677 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006561.35297 | 2120334.19193 | 37.802403889494 | -122.421481088503 | (37.802403889494, -122.421481088503) | 5 | 9 | 1 | 28858 | 32 | |||
29758 | 92776 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2701 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
75257 | 92778 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2701 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
22310 | 129514 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2730 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999183.84789 | 2118189.54872 | 37.7960965428722 | -122.446856379121 | (37.7960965428722, -122.446856379121) | 13 | 9 | 1 | 57 | 17 | |||
133028 | 129515 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2730 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999181.62943 | 2118207.94139 | 37.7961469175038 | -122.44686537955 | (37.7961469175038, -122.44686537955) | 13 | 9 | 1 | 57 | 17 | |||
25064 | 9989 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 28 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6005374.86669 | 2108638.02007 | 37.7702221392707 | -122.424754366229 | (37.7702221392707, -122.424754366229) | 8 | 2 | 5 | 28853 | 19 | |||
89274 | 129501 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2857 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 5999309.06977 | 2118008.46724 | 37.7956064942036 | -122.446410054597 | (37.7956064942036, -122.446410054597) | 13 | 9 | 1 | 57 | 17 | |||
187890 | 129502 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2857 Union St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 5999324.2861 | 2118011.40576 | 37.7956154316639 | -122.446357615115 | (37.7956154316639, -122.446357615115) | 13 | 9 | 1 | 57 | 17 | |||
146635 | 129558 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 300 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012591.86858 | 2116885.11843 | 37.793271734566 | -122.400370000791 | (37.793271734566, -122.400370000791) | 4 | 1 | 10 | 28854 | 6 | |||
159199 | 129557 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 300 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6012628.75569 | 2116888.88104 | 37.7932841227067 | -122.400242632492 | (37.7932841227067, -122.400242632492) | 4 | 1 | 10 | 28854 | 6 | |||
11496 | 129518 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3041 Divisadero St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.7977677152718 | -122.44253092607 | (37.7977677152718, -122.44253092607) | 13 | 9 | 1 | 57 | 17 | |||
184148 | 129519 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3041 Divisadero St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6000446.25144 | 2118762.17983 | 37.7977408740879 | -122.442529358545 | (37.7977408740879, -122.442529358545) | 13 | 9 | 1 | 57 | 17 | |||
189498 | 129520 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3041 Divisadero St | 4 | : | Tree | Private 2 | 2 | Width 2ft | 6000447.31564 | 2118755.23989 | 37.7977218795107 | -122.442525177605 | (37.7977218795107, -122.442525177605) | 13 | 9 | 1 | 57 | 17 | |||
99834 | 129517 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3047 Divisadero St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6000445.05587 | 2118784.6129 | 37.7978024012088 | -122.442535107006 | (37.7978024012088, -122.442535107006) | 13 | 9 | 1 | 57 | 17 |
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) );