trees
368 rows where qSpecies_id = 144 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194024 | 222528 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 8ft | 6002000.45417 | 2099279.73368 | 37.7443353771802 | -122.43575676478 | (37.7443353771802, -122.43575676478) | 2 | 7 | 5 | 63 | 22 | |||
193542 | 223908 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005053.43289 | 2102431.11313 | 37.7531612832725 | -122.42542442411 | (37.7531612832725, -122.42542442411) | 2 | 4 | 5 | 28862 | 22 | |||
193469 | 201987 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013596.70102 | 2092297.48635 | 37.7258154458067 | -122.395170107233 | (37.7258154458067, -122.395170107233) | 10 | 3 | 8 | 58 | 1 | |||
192745 | 207432 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5991562.70907 | 2104938.76193 | 37.7592751758288 | -122.472260373443 | (37.7592751758288, -122.472260373443) | 1 | 8 | 4 | 56 | 12 | ||||
192473 | 223894 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005048.64629 | 2102473.15844 | 37.7532764594666 | -122.425443969085 | (37.7532764594666, -122.425443969085) | 2 | 4 | 5 | 28862 | 22 | |||
191919 | 223314 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 737 Sanchez St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003692.07504 | 2104158.08059 | 37.7578261171073 | -122.430255467921 | (37.7578261171073, -122.430255467921) | 2 | 4 | 5 | 28862 | 3 | |||
191465 | 247864 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 399 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009555.15097 | 2098432.68764 | 37.7424358066648 | -122.409574335293 | (37.7424358066648, -122.409574335293) | 10 | 7 | 7 | 28859 | 2 | ||||
191452 | 207507 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 131 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000533.96633 | 2095190.65838 | 37.7330243285976 | -122.440534333115 | (37.7330243285976, -122.440534333115) | 9 | 7 | 5 | 63 | 40 | ||||
190741 | 176193 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998949.70909 | 2090563.26446 | 37.7202282430074 | -122.445678850924 | (37.7202282430074, -122.445678850924) | 9 | 7 | 6 | 28861 | 25 | |||
190017 | 103912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
189432 | 223889 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005159.43202 | 2103680.76581 | 37.7565985263084 | -122.425146769228 | (37.7565985263084, -122.425146769228) | 2 | 4 | 5 | 28859 | 19 | |||
188959 | 207428 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5991814.94231 | 2105825.1395 | 37.7617235288256 | -122.471452623948 | (37.7617235288256, -122.471452623948) | 1 | 8 | 4 | 56 | 12 | |||
188946 | 223286 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 645 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002295.49975 | 2100024.37386 | 37.7463967393229 | -122.43478980022 | (37.7463967393229, -122.43478980022) | 2 | 7 | 5 | 63 | 22 | |||
187697 | 222515 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1445 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001418.00451 | 2099470.26771 | 37.7448254366625 | -122.43778439245 | (37.7448254366625, -122.43778439245) | 2 | 7 | 5 | 63 | 22 | |||
187331 | 223292 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998862.7522 | 2107587.12928 | 37.766966704982 | -122.447203994986 | (37.766966704982, -122.447203994986) | 15 | 5 | 11 | 29492 | 9 | |||
186827 | 103909 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
186703 | 207466 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.05021 | 2094086.70842 | 37.7297991870776 | -122.452195219742 | (37.7297991870776, -122.452195219742) | 9 | 7 | 4 | 28861 | 40 | |||
186113 | 223318 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 3 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003637.29181 | 2104227.88023 | 37.7580146671663 | -122.430449911261 | (37.7580146671663, -122.430449911261) | 2 | 4 | 5 | 28862 | 3 | |||
185760 | 35816 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | 10 | 3 | 7 | 309 | 28 | |
185750 | 94352 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
185687 | 223907 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005052.86926 | 2102433.45937 | 37.7531676936567 | -122.425426540214 | (37.7531676936567, -122.425426540214) | 2 | 4 | 5 | 28862 | 22 | |||
185219 | 207498 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995864.99772 | 2092813.12874 | 37.7262292337867 | -122.456504217911 | (37.7262292337867, -122.456504217911) | 9 | 7 | 4 | 28861 | 40 | |||
183988 | 207434 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991566.65677 | 2104946.06953 | 37.7592954690347 | -122.472247253208 | (37.7592954690347, -122.472247253208) | 1 | 8 | 4 | 56 | 12 | ||||
182684 | 201981 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6013639.52945 | 2092282.86186 | 37.7257776715983 | -122.395021027505 | (37.7257776715983, -122.395021027505) | 10 | 3 | 8 | 58 | 1 | |||
182556 | 223903 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005052.503 | 2102444.27278 | 37.7531973640707 | -122.425428576291 | (37.7531973640707, -122.425428576291) | 2 | 4 | 5 | 28862 | 22 | |||
182158 | 176207 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 178 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6001859.62036 | 2093660.3477 | 37.7288978433404 | -122.435841750723 | (37.7288978433404, -122.435841750723) | 9 | 7 | 6 | 28861 | 25 | |||
181073 | 222533 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 8ft | 6002001.23018 | 2099263.25954 | 37.74429018714 | -122.435752903069 | (37.74429018714, -122.435752903069) | 2 | 7 | 5 | 63 | 22 | |||
179837 | 207455 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 651 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997115.25311 | 2094389.86364 | 37.7306302730502 | -122.452295897932 | (37.7306302730502, -122.452295897932) | 9 | 7 | 4 | 28861 | 40 | |||
178940 | 223290 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2230 Castro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6002654.58184 | 2098981.14888 | 37.7435526675385 | -122.433473598326 | (37.7435526675385, -122.433473598326) | 2 | 7 | 5 | 63 | 22 | |||
178937 | 223303 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003237.77215 | 2103281.8732 | 37.7553945175465 | -122.431764076148 | (37.7553945175465, -122.431764076148) | 2 | 4 | 5 | 28862 | 22 | |||
178836 | 207480 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999342.45977 | 2094050.86974 | 37.7298268160538 | -122.444571779177 | (37.7298268160538, -122.444571779177) | 9 | 7 | 4 | 28861 | 40 | ||||
178745 | 122932 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 184 10th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5992762.84609 | 2114244.11852 | 37.7848945742073 | -122.468786884025 | (37.7848945742073, -122.468786884025) | 11 | 6 | 2 | 54 | 11 | |||
178265 | 222520 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 793 27th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | 2 | 7 | 5 | 63 | 22 | ||||
177666 | 223307 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004278.85639 | 2103386.69911 | 37.7557413042254 | -122.428171160475 | (37.7557413042254, -122.428171160475) | 2 | 4 | 5 | 28862 | 22 | |||
177391 | 207470 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.5742 | 2094079.0064 | 37.7297780691825 | -122.452192852745 | (37.7297780691825, -122.452192852745) | 9 | 7 | 4 | 28861 | 40 | |||
177385 | 126463 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 845 Marina Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998902.34401 | 2121345.9026 | 37.8047469543639 | -122.448057809532 | (37.8047469543639, -122.448057809532) | 13 | 9 | 1 | 57 | 17 | |||
177262 | 38549 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1843 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | 3x3 | Permit Number 40519 | 6015893.6443 | 2093219.8325 | 37.7284754960653 | -122.387293979367 | (37.7284754960653, -122.387293979367) | 10 | 3 | 8 | 58 | 1 |
176989 | 223881 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1504 Bryant St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009376.30557 | 2107741.27022 | 37.7679850594966 | -122.410850015515 | (37.7679850594966, -122.410850015515) | 8 | 4 | 7 | 28853 | 19 | |||
175816 | 207477 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.54471 | 2094079.1487 | 37.729779890312 | -122.45210653761 | (37.729779890312, -122.45210653761) | 9 | 7 | 4 | 28861 | 40 | |||
174719 | 176206 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 538 Cayuga Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6001905.56245 | 2093653.69597 | 37.7288821888572 | -122.435682450208 | (37.7288821888572, -122.435682450208) | 9 | 7 | 6 | 28861 | 25 | |||
174177 | 117901 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 745 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983818.1839 | 2110710.73543 | 37.7746721257554 | -122.49947082515 | (37.7746721257554, -122.49947082515) | 11 | 6 | 2 | 55 | 26 | |||
173868 | 207437 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991566.59817 | 2104953.60306 | 37.7593161507263 | -122.472248005034 | (37.7593161507263, -122.472248005034) | 1 | 8 | 4 | 56 | 12 | ||||
173690 | 103907 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
172895 | 223331 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 99 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005029.44165 | 2097557.40609 | 37.7397778468682 | -122.425160628682 | (37.7397778468682, -122.425160628682) | 2 | 7 | 5 | 63 | 7 | |||
172338 | 207481 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999342.64859 | 2094048.18923 | 37.7298194667739 | -122.444570933828 | (37.7298194667739, -122.444570933828) | 9 | 7 | 4 | 28861 | 40 | ||||
171728 | 176188 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5998880.86348 | 2090599.21284 | 37.7203230180654 | -122.445919410554 | (37.7203230180654, -122.445919410554) | 9 | 7 | 6 | 28861 | 25 | |||
170383 | 247962 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 14 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.406824987307 | (37.7437842015861, -122.406824987307) | 2 | 7 | 7 | 28859 | 2 | ||||
170195 | 223302 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4039 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6001887.34135 | 2103503.77576 | 37.7559271662088 | -122.436450149275 | (37.7559271662088, -122.436450149275) | 2 | 4 | 5 | 28862 | 22 | |||
170167 | 247006 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 401 Valley St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 6003253.92203 | 2099189.92697 | 37.7441599095582 | -122.43141613026 | (37.7441599095582, -122.43141613026) | 2 | 7 | 5 | 63 | 22 | |||
169414 | 191051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1998 Revere Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013034.57444 | 2095940.33474 | 37.7357866816978 | -122.397368703228 | (37.7357866816978, -122.397368703228) | 10 | 3 | 8 | 58 | 1 | ||||
169017 | 223289 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2230 Castro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6002654.98258 | 2098989.6554 | 37.7435760471958 | -122.433472820437 | (37.7435760471958, -122.433472820437) | 2 | 7 | 5 | 63 | 22 | |||
168761 | 187583 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 747 University St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6008740.19071 | 2090749.62669 | 37.7212940727358 | -122.411849445609 | (37.7212940727358, -122.411849445609) | 9 | 3 | 7 | 309 | 28 | ||||
168404 | 223893 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005048.71049 | 2102476.27815 | 37.7532850290914 | -122.425443969067 | (37.7532850290914, -122.425443969067) | 2 | 4 | 5 | 28862 | 22 | |||
168114 | 94350 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
167535 | 207518 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 175 Stillings Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999625.44133 | 2095740.45065 | 37.7344821530156 | -122.443714816097 | (37.7344821530156, -122.443714816097) | 9 | 7 | 4 | 63 | 40 | |||
167398 | 207441 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1290 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5992406.74733 | 2106715.1011 | 37.7642013463338 | -122.469470611706 | (37.7642013463338, -122.469470611706) | 11 | 8 | 11 | 56 | 12 | |||
166668 | 223902 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005052.00491 | 2102446.20203 | 37.7532026332003 | -122.425430436072 | (37.7532026332003, -122.425430436072) | 2 | 4 | 5 | 28862 | 22 | |||
165645 | 223333 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 203 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004237.41218 | 2097504.4182 | 37.7395875791097 | -122.427895357291 | (37.7395875791097, -122.427895357291) | 2 | 7 | 5 | 63 | 7 | |||
165406 | 223326 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001032.4361 | 2105462.77683 | 37.7612574902612 | -122.439547114034 | (37.7612574902612, -122.439547114034) | 15 | 4 | 5 | 28862 | 3 | |||
165279 | 223313 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001079.43787 | 2104214.39787 | 37.7578324213507 | -122.439295071829 | (37.7578324213507, -122.439295071829) | 2 | 4 | 5 | 28862 | 38 | |||
165040 | 207512 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999349.27523 | 2095271.40684 | 37.7331785137748 | -122.444635908917 | (37.7331785137748, -122.444635908917) | 9 | 7 | 4 | 59 | 40 | ||||
164936 | 121952 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 108 Lake St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5990864.50946 | 2114720.39813 | 37.7860924526568 | -122.475389233666 | (37.7860924526568, -122.475389233666) | 11 | 6 | 2 | 54 | 26 | |||
164915 | 223315 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 359 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003283.34102 | 2104456.30953 | 37.7586218228666 | -122.431690331759 | (37.7586218228666, -122.431690331759) | 2 | 4 | 5 | 28862 | 3 | |||
164785 | 222511 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 190 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006121.17792 | 2096336.36399 | 37.7364867517461 | -122.421299173611 | (37.7364867517461, -122.421299173611) | 2 | 7 | 7 | 28859 | 2 | |||
164779 | 207471 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.11204 | 2094076.47997 | 37.7297711057327 | -122.452194268254 | (37.7297711057327, -122.452194268254) | 9 | 7 | 4 | 28861 | 40 | |||
164527 | 103901 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
164179 | 201985 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013611.24152 | 2092292.43846 | 37.7258023939381 | -122.395119487989 | (37.7258023939381, -122.395119487989) | 10 | 3 | 8 | 58 | 1 | |||
163431 | 223312 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001075.55529 | 2104217.42481 | 37.7578405116468 | -122.439308716341 | (37.7578405116468, -122.439308716341) | 2 | 4 | 5 | 28862 | 38 | |||
163077 | 222529 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 8ft | 6002000.5993 | 2099275.94966 | 37.7443249953938 | -122.435755992271 | (37.7443249953938, -122.435755992271) | 2 | 7 | 5 | 63 | 22 | |||
162486 | 94353 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
162282 | 103908 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
160715 | 223892 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008958.71449 | 2099085.99444 | 37.7441962043945 | -122.411682792229 | (37.7441962043945, -122.411682792229) | 2 | 7 | 7 | 28859 | 2 | |||
160648 | 106692 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 6005110.7 | 2103657.1 | 37.7565307924788 | -122.425313618185 | (37.7565307924788, -122.425313618185) | 2 | 4 | 5 | 28859 | 19 | |||
160476 | 176200 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6010755.27325 | 2091348.4361 | 37.7230511231959 | -122.404925977947 | (37.7230511231959, -122.404925977947) | 10 | 3 | 7 | 309 | 28 | |||
159988 | 223901 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005051.96111 | 2102449.00234 | 37.7532103197251 | -122.425430786811 | (37.7532103197251, -122.425430786811) | 2 | 4 | 5 | 28862 | 22 | |||
159565 | 207465 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.25418 | 2094089.75184 | 37.7298075552683 | -122.452194734107 | (37.7298075552683, -122.452194734107) | 9 | 7 | 4 | 28861 | 40 | |||
159517 | 191044 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 801 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6015135.40793 | 2105291.05341 | 37.7615785374414 | -122.390758499125 | (37.7615785374414, -122.390758499125) | 10 | 3 | 8 | 28856 | 29 | ||||
159016 | 222530 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 8ft | 6002000.54412 | 2099273.28209 | 37.7443176677386 | -122.435755992253 | (37.7443176677386, -122.435755992253) | 2 | 7 | 5 | 63 | 22 | |||
157567 | 207452 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 155 Marietta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5998658.25141 | 2097950.47884 | 37.7404951506327 | -122.44721770154 | (37.7404951506327, -122.44721770154) | 9 | 7 | 4 | 59 | 40 | |||
157504 | 207446 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993786.60025 | 2094254.5373 | 37.7300674458375 | -122.463793646662 | (37.7300674458375, -122.463793646662) | 9 | 8 | 4 | 59 | 40 | |||
157152 | 207508 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999372.65026 | 2095269.87329 | 37.7331756368378 | -122.44455498523 | (37.7331756368378, -122.44455498523) | 9 | 7 | 4 | 59 | 40 | ||||
155978 | 191039 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 18 | Front Yard : Yard | Tree | Private 2 | 5 | 6015379.43369 | 2102383.15198 | 37.7536075970141 | -122.389711396866 | (37.7536075970141, -122.389711396866) | 10 | 3 | 8 | 28856 | 29 | ||||
155100 | 207493 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992717.93715 | 2091043.75308 | 37.7211897810709 | -122.467254749618 | (37.7211897810709, -122.467254749618) | 9 | 8 | 6 | 64 | 24 | |||
155043 | 207487 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 484 Faxon Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994797.52832 | 2091773.84909 | 37.7233142792092 | -122.46011911753 | (37.7233142792092, -122.46011911753) | 9 | 8 | 4 | 28861 | 24 | |||
153805 | 191048 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 508 Missouri St | 4 | : | Tree | Private 2 | 2 | Width 8ft | 6013509.22069 | 2104630.04045 | 37.7596731815818 | -122.396336524335 | (37.7596731815818, -122.396336524335) | 10 | 3 | 8 | 28856 | 29 | |||
152816 | 201969 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6013782.62401 | 2092181.31295 | 37.7255067948939 | -122.394519248986 | (37.7255067948939, -122.394519248986) | 10 | 3 | 8 | 58 | 1 | |||
150811 | 222524 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 739 27th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6001699.42535 | 2099975.49164 | 37.7462286605235 | -122.436847454466 | (37.7462286605235, -122.436847454466) | 2 | 7 | 5 | 63 | 22 | |||
150445 | 176211 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 223 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007229.58334 | 2092624.58551 | 37.7263574447365 | -122.417203995595 | (37.7263574447365, -122.417203995595) | 9 | 3 | 7 | 309 | 28 | |||
150102 | 223284 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 8ft | 6002000.28454 | 2099249.93485 | 37.7442535469551 | -122.435755219738 | (37.7442535469551, -122.435755219738) | 2 | 7 | 5 | 63 | 22 | |||
149965 | 207458 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 458 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998364.99374 | 2094412.73568 | 37.7307645903989 | -122.447977019849 | (37.7307645903989, -122.447977019849) | 9 | 7 | 4 | 59 | 40 | ||||
149840 | 247049 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 527 Valley St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002466.92979 | 2099138.14647 | 37.7439730978735 | -122.434133672824 | (37.7439730978735, -122.434133672824) | 2 | 7 | 5 | 63 | 22 | |||
149208 | 223325 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001022.61715 | 2105456.75234 | 37.7612403896494 | -122.439580641646 | (37.7612403896494, -122.439580641646) | 15 | 4 | 5 | 28862 | 3 | |||
148101 | 207500 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 145 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995396.14048 | 2096963.9149 | 37.7375993552348 | -122.458425341581 | (37.7375993552348, -122.458425341581) | 9 | 7 | 4 | 59 | 40 | |||
147879 | 222523 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 739 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6001699.76952 | 2099972.44241 | 37.7462203076195 | -122.436846046123 | (37.7462203076195, -122.436846046123) | 2 | 7 | 5 | 63 | 22 | |||
147260 | 207511 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999356.36789 | 2095270.99741 | 37.733177794305 | -122.444611358346 | (37.733177794305, -122.444611358346) | 9 | 7 | 4 | 59 | 40 | ||||
146687 | 201989 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013578.50346 | 2092296.28411 | 37.7258111326767 | -122.395232931161 | (37.7258111326767, -122.395232931161) | 10 | 3 | 8 | 58 | 1 | ||||
145776 | 223310 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001063.6909 | 2104223.05336 | 37.7578552911032 | -122.439350151704 | (37.7578552911032, -122.439350151704) | 2 | 4 | 5 | 28862 | 38 | |||
144956 | 223300 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 9 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005822.66174 | 2099626.06801 | 37.7455027034951 | -122.422564964906 | (37.7455027034951, -122.422564964906) | 2 | 7 | 5 | 28859 | 22 | |||
144109 | 50010 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1465@ 26th ST Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46741 | 6012041.28455 | 2101546.95627 | 37.7511259142534 | -122.401196767325 | (37.7511259142534, -122.401196767325) | 10 | 3 | 8 | 28856 | 29 | |
144053 | 56424 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 279 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2011 12:00:00 AM | 4 | Permit Number 767957 | 5990232.5043 | 2113517.65935 | 37.7827534137466 | -122.477487840106 | (37.7827534137466, -122.477487840106) | 11 | 6 | 2 | 55 | 26 |
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) );