trees
665 rows where qSpecies_id = 89 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194147 | 221775 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 21 Addison St | 14 | Back Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | 2 | 7 | 5 | 63 | 7 | |||
194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
193901 | 175157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | 9 | 7 | 6 | 28861 | 25 | |||
193860 | 32513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.62959 | 37.7352510410088 | -122.416089643829 | (37.7352510410088, -122.416089643829) | 2 | 7 | 7 | 28859 | 2 | |
193686 | 16402 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
193513 | 125465 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.413927056694 | (37.7913483149251, -122.413927056694) | 5 | 1 | 10 | 28857 | 21 | |||
192901 | 203478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.7423403049648 | -122.469178135975 | (37.7423403049648, -122.469178135975) | 1 | 8 | 4 | 29491 | 40 | |||
192892 | 220637 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003700.73164 | 2096802.65879 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | 2 | 7 | 5 | 63 | 7 | |||
192377 | 203455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | 1 | 8 | 4 | 59 | 40 | |||
191914 | 125472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6010077.81978 | 2116010.1713 | 37.7907288268122 | -122.409007053754 | (37.7907288268122, -122.409007053754) | 5 | 1 | 10 | 28857 | 21 | |||
191382 | 33001 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
190539 | 125507 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.413176159668 | (37.7976958234636, -122.413176159668) | 3 | 1 | 10 | 308 | 21 | |||
190022 | 249946 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011346.83837 | 2120055.65824 | 37.8019077631812 | -122.404901241218 | (37.8019077631812, -122.404901241218) | 3 | 1 | 10 | 308 | 23 | |||
189904 | 33365 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
189345 | 125524 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011207.68462 | 2120726.93894 | 37.8037431562814 | -122.405430083952 | (37.8037431562814, -122.405430083952) | 3 | 1 | 10 | 308 | 23 | |||
189305 | 30607 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | |
189014 | 49035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
188953 | 220660 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003703.33838 | 2095523.526 | 37.7341182720406 | -122.429600714704 | (37.7341182720406, -122.429600714704) | 2 | 7 | 5 | 28861 | 25 | |||
188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
187634 | 32133 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
187380 | 125532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.7931382383022 | -122.409066739034 | (37.7931382383022, -122.409066739034) | 3 | 1 | 10 | 28857 | 4 | |||
187360 | 24505 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005509.85054 | 2114996.70292 | 37.787689150419 | -122.424739879851 | (37.787689150419, -122.424739879851) | 13 | 9 | 1 | 28858 | 41 | |||
186795 | 69515 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.7377003998713 | -122.412084952925 | (37.7377003998713, -122.412084952925) | 10 | 7 | 7 | 28859 | 2 | ||
186427 | 32706 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | 13 | 1 | 10 | 28858 | 21 | |
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
186226 | 32707 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
185797 | 114540 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.44502 | 2104594.78019 | 37.7594980943773 | -122.401192496453 | (37.7594980943773, -122.401192496453) | 10 | 3 | 8 | 28856 | 29 | |
185576 | 69035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | 1 | 8 | 3 | 56 | 35 | ||
184630 | 17102 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.447940341436 | (37.771661239802, -122.447940341436) | 15 | 5 | 11 | 29492 | 9 | |||
184139 | 99406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
184137 | 46752 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | 9 | 8 | 6 | 64 | 24 | ||
183777 | 125442 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3719 Scott St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6000612.64349 | 2121133.322 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | 13 | 9 | 1 | 57 | 17 | |||
183254 | 175152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.39297 | 37.7286399726426 | -122.43966968351 | (37.7286399726426, -122.43966968351) | 9 | 7 | 6 | 28861 | 25 | |
182885 | 203490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001874.24208 | 2094906.20617 | 37.7323195164307 | -122.435880309143 | (37.7323195164307, -122.435880309143) | 9 | 7 | 4 | 63 | 40 | |||
182821 | 123467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.459448396296 | (37.775289512367, -122.459448396296) | 11 | 6 | 2 | 54 | 11 | |||
182788 | 220644 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6009354.03531 | 2097334.25884 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | 10 | 7 | 7 | 28859 | 2 | |||
182650 | 88208 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 607 Central Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | 15 | 5 | 11 | 29492 | 16 | |||
182643 | 96060 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
182415 | 125459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002302.24315 | 2117372.64149 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | 13 | 9 | 1 | 29490 | 27 | |||
182215 | 249950 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 5 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.8019120241928 | -122.404858102512 | (37.8019120241928, -122.404858102512) | 3 | 1 | 10 | 308 | 23 | |||
182154 | 125467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.7913636807268 | -122.413784882888 | (37.7913636807268, -122.413784882888) | 5 | 1 | 10 | 28857 | 21 | |||
182127 | 189164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6014453.29453 | 2102557.37778 | 37.7540345843346 | -122.392926403935 | (37.7540345843346, -122.392926403935) | 10 | 3 | 8 | 28856 | 29 | ||||
181637 | 220589 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.434640834713 | (37.7455521185496, -122.434640834713) | 2 | 7 | 5 | 63 | 22 | |||
180503 | 51460 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
180103 | 95587 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153 | 2112651 | 37.7816213577124 | -122.401590796207 | (37.7816213577124, -122.401590796207) | 6 | 2 | 9 | 28856 | 34 | |
180034 | 220634 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002844.7092 | 2095716.31094 | 37.7345989605548 | -122.432583028494 | (37.7345989605548, -122.432583028494) | 2 | 7 | 5 | 63 | 7 | |||
179959 | 189166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 20 | Median : Yard | Tree | DPW 1 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951887 | (37.752778669414, -122.40048951887) | 10 | 3 | 8 | 28856 | 29 | ||||
179956 | 220635 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002826.10631 | 2095715.40994 | 37.7345954316319 | -122.432647280541 | (37.7345954316319, -122.432647280541) | 2 | 7 | 5 | 63 | 7 | |||
179888 | 203491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.7337449607507 | -122.442702834189 | (37.7337449607507, -122.442702834189) | 9 | 7 | 4 | 63 | 40 | |||
179693 | 203486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.08817 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | 9 | 7 | 4 | 59 | 40 | |||
179660 | 49037 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | |
179429 | 203467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 5998177.87228 | 2094421.44457 | 37.7307778050431 | -122.448624552388 | (37.7307778050431, -122.448624552388) | 9 | 7 | 4 | 59 | 40 | |||
179202 | 248093 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010450.13728 | 2099873.13293 | 37.7464410659956 | -122.406581208982 | (37.7464410659956, -122.406581208982) | 2 | 7 | 7 | 28859 | 2 | |||
178944 | 220658 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007553.6507 | 2100235.86656 | 37.7472745765577 | -122.416622650424 | (37.7472745765577, -122.416622650424) | 2 | 7 | 7 | 28859 | 2 | |||
178906 | 249551 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 3 | : | Tree | Private 2 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.7876801439695 | -122.424807261672 | (37.7876801439695, -122.424807261672) | 13 | 9 | 1 | 28858 | 41 | |||
178524 | 249534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6006252.35701 | 2114034.72493 | 37.7850897043627 | -122.422102579373 | (37.7850897043627, -122.422102579373) | 13 | 9 | 11 | 28858 | 41 | |||
178492 | 189181 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013494.87898 | 2110935.49205 | 37.7769857497279 | -122.396828192679 | (37.7769857497279, -122.396828192679) | 6 | 2 | 9 | 28856 | 34 | |||
178418 | 221769 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | 2 | 7 | 5 | 63 | 7 | |||
178388 | 203473 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 128 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | 9 | 8 | 6 | 28861 | 24 | |||
178268 | 125503 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6007472.5485 | 2120196.70062 | 37.8020777071716 | -122.418318141382 | (37.8020777071716, -122.418318141382) | 5 | 1 | 1 | 28858 | 32 | |||
178236 | 249821 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010901.87597 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | 3 | 1 | 10 | 308 | 23 | |||
178191 | 91499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | 14 | 10 | 9 | 28852 | 36 | |
177681 | 92445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
176858 | 220588 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1285 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010337.44954 | 2101779.52105 | 37.7516692837277 | -122.407105226845 | (37.7516692837277, -122.407105226845) | 10 | 4 | 7 | 28859 | 19 | |||
176774 | 220590 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 653 Duncan St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002350.00188 | 2099716.46414 | 37.7455543857324 | -122.434579325574 | (37.7455543857324, -122.434579325574) | 2 | 7 | 5 | 63 | 22 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
175348 | 97941 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
175290 | 203445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.97252 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | 9 | 7 | 4 | 59 | 40 | |||
174438 | 31950 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
174368 | 32129 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | 3 | 1 | 10 | 28857 | 4 | ||
173885 | 92979 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575 | (37.78494212831, -122.40950424575) | 14 | 10 | 9 | 28852 | 36 | ||
173833 | 203482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.7262851788162 | -122.460793782631 | (37.7262851788162, -122.460793782631) | 9 | 8 | 4 | 28861 | 40 | |||
173456 | 16405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
172548 | 94178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1379 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53590 | 6011748.15969 | 2101956.87191 | 37.7522350957877 | -122.402239247057 | (37.7522350957877, -122.402239247057) | 10 | 3 | 8 | 28856 | 29 | |
172501 | 32487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 257 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.08159 | 2106647.67071 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | 15 | 5 | 5 | 28862 | 3 | |
171957 | 220662 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.423646281876 | (37.7365897745051, -122.423646281876) | 2 | 7 | 7 | 28859 | 2 | |||
171584 | 220623 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 58 Fountain St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6000335.70641 | 2101336.8621 | 37.7498890559574 | -122.441660695297 | (37.7498890559574, -122.441660695297) | 2 | 4 | 5 | 28862 | 22 | |||
171547 | 95678 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 307 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767430 | 6009637.5069 | 2092959.36639 | 37.7274118548521 | -122.408903491428 | (37.7274118548521, -122.408903491428) | 10 | 3 | 7 | 309 | 28 |
170949 | 175170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004288.38035 | 2091053.98491 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | 9 | 7 | 6 | 28861 | 5 | |||
170746 | 38961 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.7432621510095 | -122.406749540855 | (37.7432621510095, -122.406749540855) | 10 | 7 | 7 | 28859 | 2 | ||
170340 | 125439 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 99 Collins St | 0 | Side Yard : Yard | Tree | Private 2 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | 15 | 6 | 1 | 54 | 31 | ||||
170280 | 221764 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3809 16th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6001727.44948 | 2106346.39943 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | 15 | 5 | 5 | 28862 | 3 | |||
170131 | 45807 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.470920456526 | (37.7509526116716, -122.470920456526) | 1 | 8 | 4 | 29491 | 12 | |||
170126 | 220628 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.440953463952 | (37.751606143208, -122.440953463952) | 2 | 4 | 5 | 28862 | 22 | |||
170059 | 125445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | 13 | 9 | 1 | 57 | 17 | |||
169681 | 125486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 4 | Median : Yard | Tree | DPW 1 | 6 | 6007645.27033 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | 5 | 1 | 10 | 28858 | 32 | ||||
169624 | 17031 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.438444795925 | (37.7730732545652, -122.438444795925) | 15 | 5 | 11 | 29492 | 10 | |||
169591 | 249537 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6006345.87488 | 2114047.32097 | 37.7851295641198 | -122.421779931396 | (37.7851295641198, -122.421779931396) | 13 | 9 | 11 | 28858 | 41 | |||
169473 | 37601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 781 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 11 | 6x9 | Permit Number 40028 | 5992556.63358 | 2110168.87379 | 37.7736931455181 | -122.469203595419 | (37.7736931455181, -122.469203595419) | 11 | 6 | 2 | 54 | 11 |
168918 | 221754 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003935.10667 | 2102444.58543 | 37.7531350266776 | -122.429292779651 | (37.7531350266776, -122.429292779651) | 2 | 4 | 5 | 28862 | 22 | |||
168658 | 189163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010839.47216 | 2105097.25682 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | 10 | 3 | 8 | 28856 | 29 | |||
168006 | 49034 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
167693 | 189185 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6013378.56954 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | 6 | 2 | 9 | 28856 | 34 | |||
167613 | 33368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
167430 | 37576 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918 | (37.7601298795068, -122.44341407918) | 2 | 4 | 5 | 28862 | 3 | ||
166460 | 16400 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
166235 | 16403 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
165994 | 221762 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001705.95618 | 2104074.38405 | 37.7574836102927 | -122.437118289774 | (37.7574836102927, -122.437118289774) | 2 | 4 | 5 | 28862 | 3 | |||
165775 | 34188 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
165467 | 203489 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996836.54011 | 2096166.78672 | 37.7354933057555 | -122.453387687511 | (37.7354933057555, -122.453387687511) | 9 | 7 | 4 | 59 | 40 |
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) );