trees
412 rows where qSpecies_id = 216 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194008 | 203349 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1774 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993139.91773 | 2103410.94201 | 37.7551713319069 | -122.466694610463 | (37.7551713319069, -122.466694610463) | 1 | 8 | 4 | 56 | 12 | |||
193905 | 203332 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 754 Ulloa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993838.4118 | 2098152.73836 | 37.7407739251688 | -122.46389737627 | (37.7407739251688, -122.46389737627) | 1 | 8 | 4 | 59 | 40 | |||
192953 | 187840 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012623.23421 | 2115291.51814 | 37.7888978332071 | -122.4001495014 | (37.7888978332071, -122.4001495014) | 12 | 2 | 9 | 28855 | 6 | |||
192886 | 220351 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3921 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6002309.75741 | 2103525.9195 | 37.7560119615059 | -122.434990881437 | (37.7560119615059, -122.434990881437) | 2 | 4 | 5 | 28862 | 22 | ||||
192581 | 125389 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1182 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6007220.46315 | 2119868.37371 | 37.8011620111718 | -122.419167176043 | (37.8011620111718, -122.419167176043) | 5 | 1 | 1 | 28858 | 32 | ||||
192384 | 125364 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2683 Green St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000248.1233 | 2117795.83922 | 37.7950762629051 | -122.443145495791 | (37.7950762629051, -122.443145495791) | 13 | 9 | 1 | 57 | 27 | |||
192108 | 221689 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 146 Alma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997950.61763 | 2106210.41834 | 37.7631344455149 | -122.450259661975 | (37.7631344455149, -122.450259661975) | 15 | 5 | 11 | 29492 | 9 | |||
191740 | 220382 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 540 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002775.85956 | 2103885.79628 | 37.7570265514437 | -122.43340466262 | (37.7570265514437, -122.43340466262) | 2 | 4 | 5 | 28862 | 3 | |||
191234 | 221672 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1209 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6011147.34779 | 2102647.41029 | 37.7540976070279 | -122.404365560027 | (37.7540976070279, -122.404365560027) | 10 | 4 | 8 | 28859 | 19 | |||
190340 | 203317 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1515 16th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 5991175.14948 | 2105039.99944 | 37.7595307100943 | -122.473608113639 | (37.7595307100943, -122.473608113639) | 1 | 8 | 4 | 56 | 12 | |||
190025 | 187842 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012630.56089 | 2115283.22761 | 37.788875477874 | -122.40012356945 | (37.788875477874, -122.40012356945) | 12 | 2 | 9 | 28855 | 6 | |||
189875 | 203348 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1774 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993141.66536 | 2103395.17123 | 37.7551281302828 | -122.466687420382 | (37.7551281302828, -122.466687420382) | 1 | 8 | 4 | 56 | 12 | |||
189592 | 220372 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 310 Liberty St | 59 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003720.16644 | 2103926.0681 | 37.7571906570269 | -122.430141764855 | (37.7571906570269, -122.430141764855) | 2 | 4 | 5 | 28862 | 3 | |||
189368 | 175104 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 700 Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | |||
188948 | 187831 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012023.10587 | 2105969.444 | 37.7632680775732 | -122.40157042575 | (37.7632680775732, -122.40157042575) | 8 | 3 | 8 | 28856 | 29 | ||||
188505 | 221677 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 306 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009672.05994 | 2099616.1831 | 37.7456919765986 | -122.409253594785 | (37.7456919765986, -122.409253594785) | 2 | 7 | 7 | 28859 | 2 | |||
188416 | 249968 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 213 Filbert St | 3 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | 3 | 1 | 10 | 308 | 23 | |||
188117 | 187846 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014052.69217 | 2107285.98471 | 37.7669960498487 | -122.394642903074 | (37.7669960498487, -122.394642903074) | 14 | 3 | 9 | 310 | 20 | |||
187283 | 221684 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 493 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6002787.95536 | 2098580.01787 | 37.7424588212222 | -122.432983773584 | (37.7424588212222, -122.432983773584) | 2 | 7 | 5 | 63 | 22 | |||
185892 | 220363 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4032 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002903.53093 | 2102429.12287 | 37.7530341155335 | -122.43285906552 | (37.7530341155335, -122.43285906552) | 2 | 4 | 5 | 28862 | 22 | |||
185264 | 250216 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011344.36464 | 2120071.55622 | 37.8019512768773 | -122.404910921503 | (37.8019512768773, -122.404910921503) | 3 | 1 | 10 | 308 | 23 | |||
185125 | 220340 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1314 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003222.18081 | 2100542.7094 | 37.7478725357993 | -122.431622445534 | (37.7478725357993, -122.431622445534) | 2 | 4 | 5 | 63 | 22 | |||
184228 | 203380 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 689 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 5996859.18595 | 2095252.24814 | 37.7329835011734 | -122.453243390374 | (37.7329835011734, -122.453243390374) | 9 | 7 | 4 | 59 | 40 | |||
184222 | 187843 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012635.2526 | 2115279.40045 | 37.7888652309851 | -122.400107067789 | (37.7888652309851, -122.400107067789) | 12 | 2 | 9 | 28855 | 6 | |||
184160 | 221669 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 120 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 6005709.14561 | 2100246.00775 | 37.7471985118996 | -122.423001540815 | (37.7471985118996, -122.423001540815) | 2 | 7 | 5 | 28859 | 22 | |||
183955 | 89330 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 846 Junipero Serra Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2008 12:00:00 AM | 3x3 | Permit Number 51923 | 5991242.2 | 2091754 | 37.723054643014 | -122.472407650365 | (37.723054643014, -122.472407650365) | 9 | 8 | 4 | 64 | 40 | |||
183236 | 220390 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3731 16th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002071.97409 | 2106459.45016 | 37.7640532216896 | -122.436023118775 | (37.7640532216896, -122.436023118775) | 15 | 5 | 5 | 28862 | 3 | |||
180704 | 221699 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 115 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006201.60829 | 2102393.63574 | 37.7531231834924 | -122.421451136554 | (37.7531231834924, -122.421451136554) | 2 | 4 | 5 | 28859 | 19 | |||
180390 | 221696 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 46 Mirabel Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6007595.89057 | 2099927.51687 | 37.7464302930267 | -122.416454749686 | (37.7464302930267, -122.416454749686) | 2 | 7 | 7 | 28859 | 2 | |||
180315 | 125355 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2298 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999283.74107 | 2120846.75644 | 37.8033982285105 | -122.446702014982 | (37.8033982285105, -122.446702014982) | 13 | 9 | 1 | 57 | 17 | |||
179224 | 125375 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1051 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006280.0736 | 2120717.56355 | 37.803440666609 | -122.422481711961 | (37.803440666609, -122.422481711961) | 5 | 9 | 1 | 28858 | 32 | |||
179126 | 220345 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 480 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001157.56269 | 2103469.06712 | 37.7557903694526 | -122.438971470555 | (37.7557903694526, -122.438971470555) | 2 | 4 | 5 | 28862 | 38 | |||
178804 | 187824 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 654 Minnesota St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6015152.23772 | 2105353.21099 | 37.7617501424761 | -122.390704635107 | (37.7617501424761, -122.390704635107) | 10 | 3 | 8 | 28856 | 29 | |||
177838 | 31147 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34853 | 5998060.58251 | 2094419.26821 | 37.7307651218955 | -122.449029883147 | (37.7307651218955, -122.449029883147) | 9 | 7 | 4 | 59 | 40 | |
177277 | 125365 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2675 Green St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000273.66327 | 2117798.51771 | 37.7950850735638 | -122.443057316357 | (37.7950850735638, -122.443057316357) | 13 | 9 | 1 | 57 | 27 | |||
177152 | 125359 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 799 Marina Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5999223.07428 | 2121455.46284 | 37.8050661057806 | -122.446955783002 | (37.8050661057806, -122.446955783002) | 13 | 9 | 1 | 57 | 17 | |||
177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
176473 | 220389 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 88 Museum Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6000859.55661 | 2106657.73105 | 37.7645286995532 | -122.440230724684 | (37.7645286995532, -122.440230724684) | 15 | 5 | 5 | 28862 | 3 | |||
175851 | 125354 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3733 Broderick St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 5999600.77298 | 2121346.59164 | 37.804788745862 | -122.445640883317 | (37.804788745862, -122.445640883317) | 13 | 9 | 1 | 57 | 17 | |||
174256 | 220369 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50 Seward St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000827.36133 | 2104393.13984 | 37.7583088551915 | -122.440179672861 | (37.7583088551915, -122.440179672861) | 2 | 4 | 5 | 28862 | 38 | |||
173875 | 220346 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3931 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6002253.36563 | 2103525.49651 | 37.7560075979795 | -122.435185872425 | (37.7560075979795, -122.435185872425) | 2 | 4 | 5 | 28862 | 22 | ||||
172860 | 125370 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Marion Pl | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.36598 | 2119390.6131 | 37.7999132602469 | -122.41525451361 | (37.7999132602469, -122.41525451361) | 5 | 1 | 10 | 308 | 32 | ||||
172643 | 68957 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 896 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 1 | Permit Number 32946 | 5988548.10153 | 2109960.29491 | 37.7728880022167 | -122.483054272347 | (37.7728880022167, -122.483054272347) | 11 | 6 | 2 | 55 | 26 | |
171961 | 175099 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 246 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012405.6069 | 2087718.72316 | 37.7131767739728 | -122.398966433363 | (37.7131767739728, -122.398966433363) | 10 | 3 | 8 | 309 | 1 | |||
171789 | 221700 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 130 Cuvier St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6004001.56182 | 2095074.00378 | 37.7329008669808 | -122.4285376315 | (37.7329008669808, -122.4285376315) | 9 | 7 | 5 | 28861 | 25 | |||
171674 | 101637 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 10X Walter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003101.5 | 2108239.9 | 37.769000337681 | -122.432589479219 | (37.769000337681, -122.432589479219) | 15 | 5 | 5 | 28862 | 3 | |||
171590 | 203385 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 219 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 5998728.86966 | 2093627.5274 | 37.7286293858168 | -122.446662574341 | (37.7286293858168, -122.446662574341) | 9 | 7 | 4 | 28861 | 40 | |||
171406 | 187847 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014037.17214 | 2107299.70636 | 37.7670328636008 | -122.394697545853 | (37.7670328636008, -122.394697545853) | 14 | 3 | 9 | 310 | 20 | |||
171052 | 67167 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 92 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2008 12:00:00 AM | 3x3 | Permit Number 51915 | 6009125.10748473 | 2096937.35188264 | 37.7383058340982 | -122.410955710423 | (37.7383058340982, -122.410955710423) | 10 | 7 | 7 | 28859 | 2 | ||
169786 | 187829 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012022.35521 | 2105982.64886 | 37.7633042932852 | -122.401573950187 | (37.7633042932852, -122.401573950187) | 8 | 3 | 8 | 28856 | 29 | ||||
169482 | 203325 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 125 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992735.62503 | 2098311.02806 | 37.7411449350923 | -122.46772187369 | (37.7411449350923, -122.46772187369) | 1 | 8 | 4 | 59 | 40 | |||
169024 | 125360 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1665 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6002803.7386 | 2120926.10172 | 37.8038165346806 | -122.434526617225 | (37.8038165346806, -122.434526617225) | 13 | 9 | 1 | 57 | 17 | |||
168611 | 221693 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 57 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007477.41526 | 2099085.84176 | 37.7441125782394 | -122.416804805422 | (37.7441125782394, -122.416804805422) | 2 | 7 | 7 | 28859 | 2 | |||
168299 | 203366 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 32 Malta Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5999734.80282 | 2095934.78629 | 37.7350219899734 | -122.443350672502 | (37.7350219899734, -122.443350672502) | 9 | 7 | 4 | 63 | 40 | |||
167869 | 31038 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 737 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 3 | Permit Number 34797 | 6002560.38069 | 2087228.56052 | 37.7112773680176 | -122.432959852538 | (37.7112773680176, -122.432959852538) | 9 | 7 | 6 | 28861 | 5 | |
167341 | 203375 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 35 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999856.56094 | 2095472.87886 | 37.7337606431433 | -122.442896553556 | (37.7337606431433, -122.442896553556) | 9 | 7 | 4 | 63 | 40 | |||
167088 | 125383 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008843.29101 | 2118569.75825 | 37.7976875919697 | -122.413459572924 | (37.7976875919697, -122.413459572924) | 3 | 1 | 10 | 308 | 21 | ||||
166673 | 203384 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 219 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5998622.52876 | 2093760.38106 | 37.7289880957201 | -122.447039756281 | (37.7289880957201, -122.447039756281) | 9 | 7 | 4 | 28861 | 40 | ||||
166649 | 203324 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 125 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992729.40865 | 2098294.87451 | 37.7411002225902 | -122.467742192966 | (37.7411002225902, -122.467742192966) | 1 | 8 | 4 | 59 | 40 | |||
165950 | 87397 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 668 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50369 | 6009213.07274 | 2091121.28635 | 37.722341090456 | -122.41024104678 | (37.722341090456, -122.41024104678) | 9 | 3 | 7 | 309 | 28 | |
165832 | 203377 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 419 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999282.97385 | 2094938.01087 | 37.7322593032094 | -122.444841172884 | (37.7322593032094, -122.444841172884) | 9 | 7 | 4 | 59 | 40 | |||
165686 | 253986 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 455X Detroit St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5999323 | 2094622 | 37.7313938956762 | -122.444680088302 | (37.7313938956762, -122.444680088302) | 9 | 7 | 4 | 59 | 40 | ||||
165562 | 51548 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2795 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2005 12:00:00 AM | 4 | Permit Number 47848 | 6000234.45806 | 2117448.12795 | 37.7941207602291 | -122.443167794483 | (37.7941207602291, -122.443167794483) | 13 | 9 | 1 | 57 | 27 | ||
164905 | 120498 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013051.90851 | 2115477.96446 | 37.7894336636916 | -122.398679426422 | (37.7894336636916, -122.398679426422) | 12 | 2 | 9 | 28855 | 6 | |
164607 | 9377 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 316 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6001083.96369 | 2097786.509 | 37.7401832324575 | -122.438818805251 | (37.7401832324575, -122.438818805251) | 2 | 7 | 5 | 63 | 7 | |||
162706 | 94228 | Property Tree 8 | Acer palmatum :: Japanese Maple 216 | 1097 Church St | Front Yard : Yard | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455 | 2102510 | 37.7533440588084 | -122.427499544702 | (37.7533440588084, -122.427499544702) | 2 | 4 | 5 | 28862 | 22 | ||||
162070 | 221678 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 123 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009783.0499 | 2099895.62844 | 37.7464654897831 | -122.408889518653 | (37.7464654897831, -122.408889518653) | 2 | 7 | 7 | 28859 | 2 | |||
161930 | 203342 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 489 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992457.25612 | 2091158.94036 | 37.7214910053888 | -122.468164216018 | (37.7214910053888, -122.468164216018) | 9 | 8 | 6 | 64 | 24 | |||
161680 | 125390 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1048 Union St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007884.3838 | 2119276.01103 | 37.7995728983285 | -122.416827724637 | (37.7995728983285, -122.416827724637) | 5 | 1 | 1 | 308 | 32 | |||
161670 | 220347 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3931 21st St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6002257.17808 | 2103516.9428 | 37.7559843280368 | -122.435172075945 | (37.7559843280368, -122.435172075945) | 2 | 4 | 5 | 28862 | 22 | ||||
161024 | 119590 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3025 Cabrillo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986201.17541 | 2110423.78509 | 37.7740237676609 | -122.491206570673 | (37.7740237676609, -122.491206570673) | 11 | 6 | 2 | 55 | 26 | |||
158447 | 187841 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012627.24493 | 2115287.70514 | 37.7888875872319 | -122.400135356873 | (37.7888875872319, -122.400135356873) | 12 | 2 | 9 | 28855 | 6 | |||
158373 | 203316 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1751 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992770.81474 | 2103552.18541 | 37.7555378416203 | -122.467981338873 | (37.7555378416203, -122.467981338873) | 1 | 8 | 4 | 56 | 12 | |||
158273 | 221692 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 63 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007455.59765 | 2099047.06577 | 37.7440048808367 | -122.416877499393 | (37.7440048808367, -122.416877499393) | 2 | 7 | 7 | 28859 | 2 | |||
157683 | 220370 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 354 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001120.64337 | 2104298.99264 | 37.7580670427826 | -122.439158629368 | (37.7580670427826, -122.439158629368) | 2 | 4 | 5 | 28862 | 38 | |||
157003 | 61580 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 660 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 10 | Permit Number 31997 | 6012675.50782 | 2104387.47055 | 37.7589607098827 | -122.399202913691 | (37.7589607098827, -122.399202913691) | 10 | 3 | 8 | 28856 | 29 | |
156820 | 249995 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 41 Darrell Pl | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011498.48414 | 2120303.07103 | 37.8025955736741 | -122.404393897677 | (37.8025955736741, -122.404393897677) | 3 | 1 | 10 | 308 | 23 | |||
155517 | 220342 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2110 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 6002639.61253 | 2099302.10226 | 37.7444330813218 | -122.433548290637 | (37.7444330813218, -122.433548290637) | 2 | 7 | 5 | 63 | 22 | |||
153899 | 220364 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 384 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003888.39565 | 2102164.05011 | 37.7523620980318 | -122.429434311351 | (37.7523620980318, -122.429434311351) | 2 | 4 | 5 | 28862 | 22 | |||
153408 | 63250 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 341 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1987 12:00:00 AM | Permit Number 23802 | 6006556.22504592 | 2104122.60651516 | 37.7578905263243 | -122.420347507255 | (37.7578905263243, -122.420347507255) | 2 | 4 | 7 | 28859 | 19 | ||
151760 | 203314 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1443 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991130.13429 | 2105570.21415 | 37.7609839317858 | -122.473802477807 | (37.7609839317858, -122.473802477807) | 1 | 8 | 4 | 56 | 12 | |||
151550 | 93180 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 290 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53191 | 5996667.07988 | 2115408.31941 | 37.7883159385639 | -122.455363742658 | (37.7883159385639, -122.455363742658) | 11 | 6 | 1 | 54 | 31 | |
151378 | 203356 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 460 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997175.08877 | 2095812.63351 | 37.7345402860987 | -122.452191657518 | (37.7345402860987, -122.452191657518) | 9 | 7 | 4 | 59 | 40 | |||
150656 | 203341 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 247 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991927.69835 | 2090159.32965 | 37.718715720927 | -122.469921991331 | (37.718715720927, -122.469921991331) | 9 | 8 | 6 | 64 | 24 | |||
150350 | 125371 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008342.7298 | 2119381.51745 | 37.799888362508 | -122.415249150039 | (37.799888362508, -122.415249150039) | 5 | 1 | 10 | 308 | 32 | ||||
149629 | 187850 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013958.61615 | 2107374.23355 | 37.7672331309277 | -122.3949744813 | (37.7672331309277, -122.3949744813) | 14 | 3 | 9 | 310 | 20 | |||
149253 | 203369 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 425 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995476.22041 | 2098338.44632 | 37.7413780816427 | -122.458247926009 | (37.7413780816427, -122.458247926009) | 1 | 8 | 4 | 59 | 40 | |||
149085 | 125392 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 14 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008540.3901 | 2119172.36551 | 37.7993251899554 | -122.414550360622 | (37.7993251899554, -122.414550360622) | 5 | 1 | 10 | 308 | 32 | ||||
149068 | 249958 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 283 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011531.90819 | 2120075.94359 | 37.8019738048974 | -122.404262237813 | (37.8019738048974, -122.404262237813) | 3 | 1 | 10 | 308 | 23 | |||
148219 | 220326 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 708 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6001877.33275 | 2100040.15325 | 37.7464163157589 | -122.436236900239 | (37.7464163157589, -122.436236900239) | 2 | 7 | 5 | 63 | 22 | |||
148179 | 221685 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 191 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004729.57356 | 2098686.96035 | 37.7428624009909 | -122.426277845652 | (37.7428624009909, -122.426277845652) | 2 | 7 | 5 | 63 | 22 | |||
148084 | 203334 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 379 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5998906.46695 | 2094352.08101 | 37.7306289834441 | -122.446100707607 | (37.7306289834441, -122.446100707607) | 9 | 7 | 4 | 28861 | 40 | |||
147734 | 187856 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013871.42116 | 2107465.38185 | 37.7674785550305 | -122.395282464041 | (37.7674785550305, -122.395282464041) | 14 | 3 | 9 | 310 | 20 | |||
147714 | 220359 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1020 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009158.25384 | 2103078.96288 | 37.7551711988011 | -122.411274840882 | (37.7551711988011, -122.411274840882) | 2 | 4 | 7 | 28859 | 19 | |||
147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||||
147223 | 220385 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4749 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999705.07561 | 2104966.76379 | 37.7598199266724 | -122.444102234143 | (37.7598199266724, -122.444102234143) | 2 | 4 | 5 | 28862 | 3 | |||
147056 | 125361 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 5 Kimball Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007994.32097 | 2116413.82948 | 37.7917202403447 | -122.416244474729 | (37.7917202403447, -122.416244474729) | 5 | 1 | 10 | 28858 | 21 | |||
145963 | 57696 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 896 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1976 12:00:00 AM | 1 | Permit Number 16600 | 5988547.94234 | 2109942.18348 | 37.7728382639909 | -122.483053495279 | (37.7728382639909, -122.483053495279) | 11 | 6 | 2 | 55 | 26 | ||
145794 | 203386 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 82 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999531.68482 | 2093814.54144 | 37.7291887092766 | -122.443900635817 | (37.7291887092766, -122.443900635817) | 9 | 7 | 4 | 63 | 40 | ||||
145306 | 220355 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 9 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6003936.66338 | 2096981.86435 | 37.7381357468766 | -122.428897971884 | (37.7381357468766, -122.428897971884) | 2 | 7 | 5 | 63 | 7 |
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) );