3,965 rows where qSpecies_id = 70 sorted by Neighborhoods (old) descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);