trees
1,626 rows where qSpecies_id = 53 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
142133 | 18453 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1101 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010571.1211098 | 2102712.3512407 | 37.7542437031283 | -122.406362877305 | (37.7542437031283, -122.406362877305) | 10 | 4 | 8 | 28859 | 19 | |||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 | ||
141160 | 18451 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396 | (37.7548433927728, -122.40664849396) | 10 | 4 | 7 | 28859 | 19 | |||
165793 | 39111 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | 2 | 4 | 7 | 28859 | 19 | |
66076 | 112051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3748x 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003448 | 2103060 | 37.7547972209553 | -122.431021210073 | (37.7547972209553, -122.431021210073) | 2 | 4 | 5 | 28862 | 22 | |||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
139905 | 18447 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1036 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6010477.6303584 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | 10 | 4 | 7 | 28859 | 19 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
85621 | 21994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015909.89309 | 2103367.89889 | 37.7563409047326 | -122.387945645479 | (37.7563409047326, -122.387945645479) | 10 | 3 | 8 | 28856 | 29 | |||
162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 19 | |||
123071 | 21969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2565 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015991.1899 | 2103495.51019 | 37.7566958018452 | -122.38767339342 | (37.7566958018452, -122.38767339342) | 10 | 3 | 8 | 28856 | 29 | |||
146992 | 21975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2565 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 4x6 | 6015991.1899 | 2103495.51019 | 37.7566958018452 | -122.38767339342 | (37.7566958018452, -122.38767339342) | 10 | 3 | 8 | 28856 | 29 | |||
90466 | 21986 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
105748 | 21991 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x6 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
118179 | 21987 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
128956 | 21983 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
151394 | 21984 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
34152 | 21980 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2575 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6015881.32806 | 2103602.42313 | 37.7569832760363 | -122.388060799634 | (37.7569832760363, -122.388060799634) | 10 | 3 | 8 | 28856 | 29 | |||
112959 | 21977 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015880.48539 | 2103611.32219 | 37.7570076642803 | -122.388064334928 | (37.7570076642803, -122.388064334928) | 10 | 3 | 8 | 28856 | 29 | |||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
155548 | 115216 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | ||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
113469 | 117124 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
62161 | 109596 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | 2 | 4 | 5 | 28859 | 19 | |||
104299 | 21960 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2525 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | 10 | 3 | 8 | 28856 | 29 | |||
161591 | 21959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2525 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | 10 | 3 | 8 | 28856 | 29 | |||
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
118796 | 65046 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2498 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 18 | Permit Number 26099 | 6008837.93100399 | 2103923.47328543 | 37.7574720629103 | -122.412442306383 | (37.7574720629103, -122.412442306383) | 2 | 4 | 7 | 28859 | 19 | ||
32408 | 54027 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778679 | 6004696.3346429 | 2103995.33974478 | 37.7574361004301 | -122.426770728763 | (37.7574361004301, -122.426770728763) | 2 | 4 | 5 | 28862 | 3 | |
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
49286 | 21956 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015841.22266 | 2104083.69236 | 37.7583025169931 | -122.388233087559 | (37.7583025169931, -122.388233087559) | 10 | 3 | 8 | 28856 | 29 | |||
63978 | 119667 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 699x Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
51820 | 12942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
30509 | 109858 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5x8 | 6015836.2 | 2104173 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | 10 | 3 | 8 | 28856 | 29 | |||
50734 | 21952 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2455 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x9 | 6015836.2 | 2104173 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | 10 | 3 | 8 | 28856 | 29 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
99014 | 117566 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
169697 | 117565 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
23663 | 85059 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2435 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | 10 | 3 | 8 | 28856 | 29 | |||
129331 | 21948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2435 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | 10 | 3 | 8 | 28856 | 29 | |||
139295 | 59013 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3755 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1980 12:00:00 AM | 20 | Permit Number 18304 | 6005291.98683548 | 2104267.80164023 | 37.7582178764875 | -122.424730106513 | (37.7582178764875, -122.424730106513) | 2 | 4 | 5 | 28859 | 19 | ||
64331 | 5481 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
171840 | 69122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3744 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | 22 | 5x9 | Permit Number 33140 | 6005352.36529805 | 2104323.23161765 | 37.7583734841408 | -122.424525234112 | (37.7583734841408, -122.424525234112) | 2 | 4 | 5 | 28859 | 19 | |
100042 | 40805 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 585 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41753 | 6013296.02646982 | 2104345.28151099 | 37.758879430057 | -122.397053895785 | (37.758879430057, -122.397053895785) | 10 | 3 | 8 | 28856 | 29 | ||||
60853 | 97999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
85172 | 98001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
179093 | 21930 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2347 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x5 | 6015939.39473 | 2104425.48438 | 37.7592464441674 | -122.38791741203 | (37.7592464441674, -122.38791741203) | 10 | 3 | 8 | 28856 | 29 | |||
21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
111614 | 87145 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
172669 | 87144 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
142871 | 18385 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 16x5 | 6010402.1602537 | 2104496.7929466 | 37.759133928444 | -122.407072960308 | (37.759133928444, -122.407072960308) | 10 | 4 | 7 | 28859 | 19 | |||
139754 | 98643 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2391 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
129417 | 18412 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 799X Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6010481.3464666 | 2104567.7087473 | 37.7593330783471 | -122.406804093165 | (37.7593330783471, -122.406804093165) | 10 | 4 | 8 | 28859 | 19 | |||
111149 | 53710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4067 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1970 12:00:00 AM | 14 | Permit Number 6657 | 6002578.30950532 | 2104703.42856113 | 37.7592603634983 | -122.434146313573 | (37.7592603634983, -122.434146313573) | 2 | 4 | 5 | 28862 | 3 | ||
163561 | 101313 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 14 | 5x6 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
189703 | 66879 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.7592879918503 | -122.439106757133 | (37.7592879918503, -122.439106757133) | 2 | 4 | 5 | 28862 | 3 | ||
154248 | 18380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 756 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010387.2722525 | 2104782.2318449 | 37.7599168463595 | -122.407144570806 | (37.7599168463595, -122.407144570806) | 10 | 4 | 8 | 28859 | 19 | |||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
54784 | 101716 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
87085 | 101725 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
105989 | 101717 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138070 | 101722 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138887 | 101721 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
143637 | 101724 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
158929 | 101720 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
169319 | 101719 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
176915 | 101718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
179159 | 101726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
158811 | 225015 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.82559 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | 2 | 4 | 5 | 28862 | 3 | |
138351 | 107659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | 15 | 5 | 5 | 28862 | 3 | |||
135877 | 109331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );