trees
59 rows where Police Districts = 1 and qSpecies_id = 8 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
16533 | 74989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.412162212732 | (37.798876023557, -122.412162212732) | 3 | 1 | 10 | 308 | 4 | |||
25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
27975 | 126544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | 5 | 1 | 1 | 308 | 32 | |||
33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
34935 | 126546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008154.11673 | 2119394.05894 | 37.7999121963461 | -122.415902712567 | (37.7999121963461, -122.415902712567) | 5 | 1 | 1 | 308 | 32 | |||
36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
39577 | 126542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 789 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | 3 | 1 | 10 | 308 | 4 | |||
41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
45874 | 126550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.7986426917617 | -122.402360227452 | (37.7986426917617, -122.402360227452) | 3 | 1 | 10 | 308 | 23 | |||
47502 | 126551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012059.41755 | 2118828.15816 | 37.7985771500692 | -122.402349010193 | (37.7985771500692, -122.402349010193) | 3 | 1 | 10 | 308 | 23 | |||
54705 | 126555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | 3 | 1 | 10 | 308 | 23 | |||
59528 | 126534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | 5 | 1 | 10 | 28858 | 21 | |||
63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
65679 | 126541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007346.83481 | 2121683.49611 | 37.8061529931217 | -122.418858679793 | (37.8061529931217, -122.418858679793) | 5 | 1 | 1 | 28858 | 32 | |||
71572 | 126556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499876 | -122.402609980888 | (37.799883499876, -122.402609980888) | 3 | 1 | 10 | 308 | 23 | |||
78300 | 126552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.402245448777 | (37.7993296056227, -122.402245448777) | 3 | 1 | 10 | 28860 | 6 | |||
86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
96112 | 126554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | 3 | 1 | 10 | 308 | 23 | |||
105051 | 108580 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
106009 | 108578 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
113991 | 126532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | 3 | 1 | 10 | 28857 | 4 | |||
116323 | 126538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | 3 | 1 | 10 | 308 | 32 | |||
124459 | 126545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008151.87492 | 2119410.8388 | 37.7999581436157 | -122.415911658989 | (37.7999581436157, -122.415911658989) | 5 | 1 | 1 | 308 | 32 | |||
130734 | 126548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | 5 | 1 | 1 | 308 | 32 | |||
136867 | 126533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008367.41227 | 2117875.57513 | 37.7957548058969 | -122.415057087242 | (37.7957548058969, -122.415057087242) | 5 | 1 | 10 | 28858 | 21 | |||
146857 | 126543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | 5 | 1 | 1 | 308 | 32 | |||
148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
167960 | 126535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008372.45938 | 2117840.81731 | 37.7956596531341 | -122.415037161853 | (37.7956596531341, -122.415037161853) | 5 | 1 | 10 | 28858 | 21 | |||
169709 | 126558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | 3 | 1 | 10 | 308 | 23 | |||
173635 | 126547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.7998627156539 | -122.41589197733 | (37.7998627156539, -122.41589197733) | 5 | 1 | 1 | 308 | 32 | |||
187764 | 108579 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 | |||
112367 | 59922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1501 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19392 | 6009252.52632 | 2118479.54886 | 37.797462868466 | -122.412037123318 | (37.797462868466, -122.412037123318) | 3 | 1 | 10 | 308 | 21 | |
129370 | 62958 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23344 | 6008125.85575238 | 2118255.57771401 | 37.7967846215561 | -122.415919842071 | (37.7967846215561, -122.415919842071) | 5 | 1 | 10 | 28858 | 21 | ||
37659 | 62959 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.7965860510683 | -122.416344986535 | (37.7965860510683, -122.416344986535) | 5 | 1 | 10 | 28858 | 21 | |
172916 | 62981 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1317 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23371 | 6007225.76848 | 2118431.56402 | 37.7972171916732 | -122.419046847643 | (37.7972171916732, -122.419046847643) | 5 | 1 | 10 | 28858 | 32 | |
40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
164066 | 64564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.409683212627 | (37.7941042450764, -122.409683212627) | 3 | 1 | 10 | 28857 | 21 | |
79356 | 66089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.97147 | 2120081.10266 | 37.8017685454413 | -122.417803248017 | (37.8017685454413, -122.417803248017) | 5 | 1 | 10 | 308 | 32 | |
70526 | 66093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.416894219588 | (37.8004974059005, -122.416894219588) | 5 | 1 | 1 | 308 | 32 | |
109118 | 42845 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 704 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 1 | Permit Number 42776 | 6007326.6292 | 2121624.2795 | 37.8059892616711 | -122.418924402261 | (37.8059892616711, -122.418924402261) | 5 | 1 | 1 | 28858 | 32 | |
32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
53575 | 46871 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
165412 | 46870 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
143270 | 88403 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071 | 2119078 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | 3 | 1 | 10 | 308 | 32 | ||
88936 | 88727 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
92474 | 32710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776816 | 6008703.66491 | 2115446.6282 | 37.7891044021039 | -122.413721697414 | (37.7891044021039, -122.413721697414) | 5 | 1 | 10 | 28858 | 21 |
177723 | 37514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782092 | 6007700.5704 | 2114390.54622 | 37.7861482783715 | -122.417117424144 | (37.7861482783715, -122.417117424144) | 13 | 1 | 9 | 28858 | 36 |
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) );