trees
3,965 rows where qSpecies_id = 70 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3152 | 10368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000449.8535 | 2108924.1608 | 37.7707284158065 | -122.441810447284 | (37.7707284158065, -122.441810447284) | 15 | 5 | 11 | 29492 | 9 | |||
3225 | 248333 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999495.3806 | 2108202.9521 | 37.7686937265955 | -122.445060117561 | (37.7686937265955, -122.445060117561) | 15 | 5 | 11 | 29492 | 9 | |||
6712 | 247499 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 Scott St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 6002255.8916 | 2109762.6323 | 37.7731333935223 | -122.43562333462 | (37.7731333935223, -122.43562333462) | 15 | 5 | 11 | 29492 | 9 | |||
9481 | 10434 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259864 | (37.7700106766776, -122.44636259864) | 15 | 5 | 11 | 29492 | 9 | |||
11723 | 93875 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997572 | 2107825 | 37.7675460011803 | -122.451685641377 | (37.7675460011803, -122.451685641377) | 15 | 5 | 11 | 29492 | 9 | |||||
15072 | 246185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999538.3824 | 2108204.1634 | 37.7686995067752 | -122.444911465275 | (37.7686995067752, -122.444911465275) | 15 | 5 | 11 | 29492 | 9 | |||
15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
17965 | 220232 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 437 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 5998506.37363 | 2106647.05925 | 37.764365140767 | -122.448368942583 | (37.764365140767, -122.448368942583) | 15 | 5 | 11 | 29492 | 9 | |||
19454 | 233191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999741.22032 | 2107224.57416 | 37.7660213745188 | -122.444139467874 | (37.7660213745188, -122.444139467874) | 15 | 5 | 5 | 29492 | 9 | |||
20167 | 220228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998615.97135 | 2106084.29487 | 37.7628261965949 | -122.447949355798 | (37.7628261965949, -122.447949355798) | 15 | 5 | 11 | 29492 | 9 | |||
22212 | 246119 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5998881.3947 | 2108355.4265 | 37.7690773199884 | -122.447194813606 | (37.7690773199884, -122.447194813606) | 15 | 5 | 11 | 29492 | 9 | |||
23506 | 247295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1416 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 5999264.8582 | 2108759.0964 | 37.7702075983445 | -122.445897477638 | (37.7702075983445, -122.445897477638) | 15 | 5 | 11 | 29492 | 9 | |||
25302 | 247541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6000212.07193 | 2108508.73139 | 37.7695741993109 | -122.442603102947 | (37.7695741993109, -122.442603102947) | 15 | 5 | 11 | 29492 | 9 | ||||
29060 | 10429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1428 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 5999246.24636 | 2108817.05532 | 37.7703656761027 | -122.445966024888 | (37.7703656761027, -122.445966024888) | 15 | 5 | 11 | 29492 | 9 | |||
29121 | 247529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 10 | Side Yard : Yard | Tree | Private 2 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.443080032335 | (37.7695086378454, -122.443080032335) | 15 | 5 | 11 | 29492 | 9 | ||||
30664 | 247351 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1748 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5997784.0252 | 2108551.1894 | 37.7695520720812 | -122.451004649224 | (37.7695520720812, -122.451004649224) | 15 | 5 | 11 | 29492 | 9 | |||
33558 | 245204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1058 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6001022.4834 | 2109009.3407 | 37.7709949104145 | -122.43983582345 | (37.7709949104145, -122.43983582345) | 15 | 5 | 11 | 29492 | 9 | |||
35902 | 220229 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 414 Belvedere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998518.50037 | 2106808.3406 | 37.7648086720182 | -122.448338614731 | (37.7648086720182, -122.448338614731) | 15 | 5 | 11 | 29492 | 9 | |||
37336 | 84810 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 654 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | Permit No. 49280 | 5997579.9 | 2108309.3 | 37.7688762175244 | -122.451693255762 | (37.7688762175244, -122.451693255762) | 15 | 5 | 11 | 29492 | 9 | |||
37448 | 10372 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | 15 | 5 | 11 | 29492 | 9 | |||
38333 | 247316 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 608 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6003150.2999 | 2109300.4667 | 37.7719151611071 | -122.432496446051 | (37.7719151611071, -122.432496446051) | 15 | 5 | 11 | 29492 | 9 | |||
39452 | 38955 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.7688475919778 | -122.44492690983 | (37.7688475919778, -122.44492690983) | 15 | 5 | 11 | 29492 | 9 | |||
40260 | 14571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | 15 | 5 | 11 | 29492 | 9 | |||
40929 | 10306 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 618- 620 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 33 | 7x5 | 6003056.4779 | 2109285.6248 | 37.7718690881058 | -122.432819922419 | (37.7718690881058, -122.432819922419) | 15 | 5 | 11 | 29492 | 9 | |||
42127 | 247539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6000199.67712 | 2108517.8655 | 37.7695985727307 | -122.442646631948 | (37.7695985727307, -122.442646631948) | 15 | 5 | 11 | 29492 | 9 | ||||
42339 | 247532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6000110.00328 | 2108483.6988 | 37.7694996473165 | -122.442954355683 | (37.7694996473165, -122.442954355683) | 15 | 5 | 11 | 29492 | 9 | ||||
50299 | 14575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1134 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1997 12:00:00 AM | 18 | 4X4 | 5999433.6283 | 2108924.6352 | 37.7706717613437 | -122.445325609236 | (37.7706717613437, -122.445325609236) | 15 | 5 | 11 | 29492 | 9 | ||
50305 | 247535 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6000144.0267 | 2108489.25837 | 37.7695168522425 | -122.442837069672 | (37.7695168522425, -122.442837069672) | 15 | 5 | 11 | 29492 | 9 | ||||
50614 | 245191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 0ft | 6000867.4069 | 2109245.0193 | 37.7716331963205 | -122.440389141422 | (37.7716331963205, -122.440389141422) | 15 | 5 | 11 | 29492 | 9 | |||
53085 | 221396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 75 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6002838.16249 | 2108731.14248 | 37.7703342316754 | -122.433535457302 | (37.7703342316754, -122.433535457302) | 15 | 5 | 5 | 29492 | 9 | |||
55287 | 220284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 291 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5999008.52748 | 2106479.57938 | 37.7639339796982 | -122.446620088539 | (37.7639339796982, -122.446620088539) | 15 | 5 | 11 | 29492 | 9 | |||
57420 | 10484 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1668 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 5998167.2674 | 2108607.159 | 37.7697276834376 | -122.449683068712 | (37.7697276834376, -122.449683068712) | 15 | 5 | 11 | 29492 | 9 | |||
60471 | 246212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1372 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999575.4789 | 2107937.2196 | 37.7679686633449 | -122.44476396148 | (37.7679686633449, -122.44476396148) | 15 | 5 | 11 | 29492 | 9 | |||
62064 | 245205 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000901.8159 | 2109009.3407 | 37.7709880410172 | -122.440253214878 | (37.7709880410172, -122.440253214878) | 15 | 5 | 11 | 29492 | 9 | |||
63449 | 247538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6000181.2283 | 2108513.20093 | 37.769584713306 | -122.442710110591 | (37.769584713306, -122.442710110591) | 15 | 5 | 11 | 29492 | 9 | ||||
63702 | 98819 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768816 | 6000868 | 2109174 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) | 15 | 5 | 11 | 29492 | 9 | ||||
66144 | 220233 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.7643810731487 | -122.446070109962 | (37.7643810731487, -122.446070109962) | 15 | 5 | 11 | 29492 | 9 | |
66217 | 87839 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
67320 | 247540 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6000206.9211 | 2108513.1896 | 37.7695861468207 | -122.442621239574 | (37.7695861468207, -122.442621239574) | 15 | 5 | 11 | 29492 | 9 | ||||
67508 | 10334 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6002067 | 2109164 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | 15 | 5 | 11 | 29492 | 9 | |||
68655 | 95330 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 771 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x4.5 | 6002023 | 2108753 | 37.7703479631409 | -122.436356663462 | (37.7703479631409, -122.436356663462) | 15 | 5 | 5 | 29492 | 9 | |||
71178 | 10373 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1234 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 9x5 | 6000208.6256 | 2108891.1906 | 37.770624139779 | -122.44264248857 | (37.770624139779, -122.44264248857) | 15 | 5 | 11 | 29492 | 9 | |||
71191 | 247416 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 991 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001894.4537 | 2109427.399 | 37.7721923905385 | -122.436849589929 | (37.7721923905385, -122.436849589929) | 15 | 5 | 11 | 29492 | 9 | |||
75944 | 122778 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999743 | 2107236 | 37.7660528485452 | -122.444134133437 | (37.7660528485452, -122.444134133437) | 15 | 5 | 5 | 29492 | 9 | |||
76421 | 10473 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1632 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5998321.0771 | 2108628.9487 | 37.7697963108216 | -122.449152617838 | (37.7697963108216, -122.449152617838) | 15 | 5 | 11 | 29492 | 9 | |||
77051 | 220230 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 414 Belvedere St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5998512.68412 | 2106844.84305 | 37.7649085660145 | -122.44836136039 | (37.7649085660145, -122.44836136039) | 15 | 5 | 11 | 29492 | 9 | |||
77456 | 10426 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1418 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x4 | 5999318.43579 | 2108766.88191 | 37.7702320345214 | -122.44571271379 | (37.7702320345214, -122.44571271379) | 15 | 5 | 11 | 29492 | 9 | |||
81430 | 245966 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1343 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999289.154 | 2108368.9024 | 37.7691376115682 | -122.445785373007 | (37.7691376115682, -122.445785373007) | 15 | 5 | 11 | 29492 | 9 | |||
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
83332 | 245994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999356.6849 | 2108721.0927 | 37.7701084926807 | -122.445577117643 | (37.7701084926807, -122.445577117643) | 15 | 5 | 11 | 29492 | 9 | |||
84479 | 247552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6000078.15418 | 2108371.82358 | 37.7691906501663 | -122.443056484487 | (37.7691906501663, -122.443056484487) | 15 | 5 | 11 | 29492 | 9 | |||
84567 | 245206 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000898.0451 | 2109031.0231 | 37.7710473607737 | -122.440267813323 | (37.7710473607737, -122.440267813323) | 15 | 5 | 11 | 29492 | 9 | |||
86322 | 173862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999618 | 2107794 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | 15 | 5 | 11 | 29492 | 9 | ||||
89100 | 10367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6000483.5353 | 2108928.9047 | 37.7707433605012 | -122.441694282188 | (37.7707433605012, -122.441694282188) | 15 | 5 | 11 | 29492 | 9 | |||
90247 | 10486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1672 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 14 | 3X3 | 5998110.8706 | 2108597.7596 | 37.7696986484007 | -122.44987746519 | (37.7696986484007, -122.44987746519) | 15 | 5 | 11 | 29492 | 9 | ||
91123 | 2171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 980X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001393.407 | 2109056.2142 | 37.7711447201677 | -122.438556149448 | (37.7711447201677, -122.438556149448) | 15 | 5 | 11 | 29492 | 9 | |||
94003 | 246190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1342 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999547.9215 | 2108126.4878 | 37.7684867735414 | -122.444872886049 | (37.7684867735414, -122.444872886049) | 15 | 5 | 11 | 29492 | 9 | |||
94708 | 10376 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 21x6 | 6000170.7774496 | 2108835.6049214 | 37.7704693578958 | -122.442769413392 | (37.7704693578958, -122.442769413392) | 15 | 5 | 5 | 29492 | 9 | |||
97143 | 10371 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1202 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6000331.2557 | 2108908.0315 | 37.7706773703693 | -122.442219519892 | (37.7706773703693, -122.442219519892) | 15 | 5 | 11 | 29492 | 9 | |||
98161 | 10360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1080 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6000968.2773 | 2109001.3276 | 37.7709698227664 | -122.440022748836 | (37.7709698227664, -122.440022748836) | 15 | 5 | 11 | 29492 | 9 | |||
100329 | 51666 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
101676 | 10451 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1552 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 18 | 3x3 | 5998701.9695 | 2108681.2867 | 37.7699617956519 | -122.447838894996 | (37.7699617956519, -122.447838894996) | 15 | 5 | 11 | 29492 | 9 | ||
102160 | 117527 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099x WALLER ST | 1 | Front Yard : Yard | Tree | Private 2 | 6000071 | 2108311 | 37.769023235971 | -122.44307686155 | (37.769023235971, -122.44307686155) | 15 | 5 | 5 | 29492 | 9 | |||||
103182 | 14580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1144 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 5999439.321 | 2108878.1448 | 37.7705444354267 | -122.445302575014 | (37.7705444354267, -122.445302575014) | 15 | 5 | 11 | 29492 | 9 | |||
105207 | 247537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6000156.15822 | 2108509.54409 | 37.7695732433511 | -122.442796564207 | (37.7695732433511, -122.442796564207) | 15 | 5 | 11 | 29492 | 9 | ||||
106894 | 247533 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6000119.08328 | 2108491.69071 | 37.769522108775 | -122.442923522415 | (37.769522108775, -122.442923522415) | 15 | 5 | 11 | 29492 | 9 | ||||
108147 | 220231 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 437 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998502.08056 | 2106668.97771 | 37.7644250778887 | -122.448385369588 | (37.7644250778887, -122.448385369588) | 15 | 5 | 11 | 29492 | 9 | |||
109309 | 247522 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | 15 | 5 | 11 | 29492 | 9 | ||||
110296 | 113585 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 15x6 | 5998642 | 2106082 | 37.7628213832292 | -122.447859166975 | (37.7628213832292, -122.447859166975) | 15 | 5 | 11 | 29492 | 9 | |||
112014 | 10369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X4 | 6000434.46289 | 2108927.97129 | 37.7707380014845 | -122.44186395705 | (37.7707380014845, -122.44186395705) | 15 | 5 | 11 | 29492 | 9 | |||
112403 | 245208 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 8 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000891.9174 | 2109074.388 | 37.7711660810553 | -122.44029211957 | (37.7711660810553, -122.44029211957) | 15 | 5 | 11 | 29492 | 9 | |||
113678 | 246115 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1410 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998952.8623 | 2108365.1171 | 37.7691080111861 | -122.446948309851 | (37.7691080111861, -122.446948309851) | 15 | 5 | 11 | 29492 | 9 | |
119243 | 48778 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1144REVISED Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46034 | 6000652.0009049 | 2108954.44361468 | 37.7708230811383 | -122.441113390762 | (37.7708230811383, -122.441113390762) | 15 | 5 | 11 | 29492 | 9 | ||||
120208 | 247536 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6000152.32324 | 2108501.61751 | 37.7695512603229 | -122.442809259955 | (37.7695512603229, -122.442809259955) | 15 | 5 | 11 | 29492 | 9 | ||||
121312 | 10362 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1126 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X4 | 6000713.44362 | 2108968.6618 | 37.7708656202791 | -122.440901879767 | (37.7708656202791, -122.440901879767) | 15 | 5 | 11 | 29492 | 9 | |||
121786 | 246144 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1308 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5999526.2692 | 2108301.3715 | 37.7689657244002 | -122.444960352645 | (37.7689657244002, -122.444960352645) | 15 | 5 | 11 | 29492 | 9 | |||
121826 | 51665 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
127589 | 245870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 38 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6000878.2481 | 2109160.175 | 37.7714008523999 | -122.440345555408 | (37.7714008523999, -122.440345555408) | 15 | 5 | 11 | 29492 | 9 | |||
128434 | 10359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1060 HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X4 | 6001056 | 2109004 | 37.770982153968 | -122.439719505856 | (37.770982153968, -122.439719505856) | 15 | 5 | 11 | 29492 | 9 | |||
130955 | 247542 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6000205.7463 | 2108507.12221 | 37.769569420322 | -122.442624867448 | (37.769569420322, -122.442624867448) | 15 | 5 | 11 | 29492 | 9 | ||||
134179 | 48976 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 304 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2002 12:00:00 AM | 3x3 | Permit Number 46163 | 5999195.98170881 | 2105884.18320097 | 37.7623098764083 | -122.445928917549 | (37.7623098764083, -122.445928917549) | 15 | 5 | 5 | 29492 | 9 | ||
134561 | 10487 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1672 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5998120.16888 | 2108653.82599 | 37.7698531243998 | -122.449849344019 | (37.7698531243998, -122.449849344019) | 15 | 5 | 11 | 29492 | 9 | |||
134797 | 247281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 515 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5998908.9716 | 2108924.8186 | 37.7706423018299 | -122.447140410361 | (37.7706423018299, -122.447140410361) | 15 | 5 | 11 | 29492 | 9 | |||
135141 | 248378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1341 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999502.3457 | 2108149.3513 | 37.768546949837 | -122.445032172068 | (37.768546949837, -122.445032172068) | 15 | 5 | 11 | 29492 | 9 | |||
137946 | 14593 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999415.7366 | 2108593.9044 | 37.7697626368824 | -122.445363712809 | (37.7697626368824, -122.445363712809) | 15 | 5 | 11 | 29492 | 9 | |||
139105 | 10325 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 807 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6002259.27538 | 2109123.5178 | 37.7713787357685 | -122.435565898974 | (37.7713787357685, -122.435565898974) | 15 | 5 | 11 | 29492 | 9 | |||
139397 | 10483 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1667 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5998066.9359 | 2108543.6348 | 37.7695475216255 | -122.450025531708 | (37.7695475216255, -122.450025531708) | 15 | 5 | 11 | 29492 | 9 | |||
142742 | 14599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1250 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999487.9613 | 2108521.9825 | 37.769569280143 | -122.44510871908 | (37.769569280143, -122.44510871908) | 15 | 5 | 11 | 29492 | 9 | |||
145206 | 10481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1659 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998097.85003 | 2108526.02441 | 37.7695009368857 | -122.449917332032 | (37.7695009368857, -122.449917332032) | 15 | 5 | 11 | 29492 | 9 | |||
145632 | 247527 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 8 | Side Yard : Yard | Tree | Private 2 | 2 | 6000059.53834 | 2108484.86365 | 37.7694999683797 | -122.443128995021 | (37.7694999683797, -122.443128995021) | 15 | 5 | 11 | 29492 | 9 | ||||
146462 | 10450 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1535 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 5998775.5559 | 2108640.5401 | 37.7698541215464 | -122.447581428516 | (37.7698541215464, -122.447581428516) | 15 | 5 | 11 | 29492 | 9 | |||
147122 | 247530 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6000087.40838 | 2108481.3833 | 37.7694920012902 | -122.443032343985 | (37.7694920012902, -122.443032343985) | 15 | 5 | 11 | 29492 | 9 | ||||
148901 | 98921 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6000893.4 | 2109236.7 | 37.7716118335785 | -122.440298633253 | (37.7716118335785, -122.440298633253) | 15 | 5 | 11 | 29492 | 9 | ||||
150425 | 89312 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
150874 | 220285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 291 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999010.84111 | 2106465.46766 | 37.7638953646094 | -122.446611071041 | (37.7638953646094, -122.446611071041) | 15 | 5 | 11 | 29492 | 9 | |||
157793 | 246113 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 671 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998983.7509 | 2108397.8226 | 37.7691995768495 | -122.446843822094 | (37.7691995768495, -122.446843822094) | 15 | 5 | 11 | 29492 | 9 | |||
158004 | 246114 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998969.2151 | 2108370.2652 | 37.769123080801 | -122.44689211719 | (37.769123080801, -122.44689211719) | 15 | 5 | 11 | 29492 | 9 | |
159903 | 247520 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 1 | Side Yard : Yard | Tree | Private 2 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | 15 | 5 | 11 | 29492 | 9 | ||||
160311 | 245175 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1128 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6000703.1785 | 2108961.6377 | 37.7708457492207 | -122.44093688299 | (37.7708457492207, -122.44093688299) | 15 | 5 | 11 | 29492 | 9 | |||
160585 | 247236 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Haight St | 1 | : | Tree | Private 2 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | 15 | 5 | 5 | 29492 | 9 |
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) );