trees
835 rows where qSpecies_id = 122 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
14833 | 20055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
2364 | 38049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.7860141835177 | -122.442004950262 | (37.7860141835177, -122.442004950262) | 13 | 6 | 1 | 29490 | 27 | |
4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
4729 | 38050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.7860213405762 | -122.441934174319 | (37.7860213405762, -122.441934174319) | 13 | 6 | 1 | 29490 | 27 | |
10486 | 38055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.7857315284908 | -122.442968502827 | (37.7857315284908, -122.442968502827) | 15 | 6 | 1 | 29490 | 27 | |
11039 | 19285 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
11831 | 66789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.8005250955758 | -122.42292350049 | (37.8005250955758, -122.42292350049) | 13 | 9 | 1 | 28858 | 32 |
11891 | 38044 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.7855814713487 | -122.443435225951 | (37.7855814713487, -122.443435225951) | 15 | 6 | 1 | 29490 | 31 | |
15280 | 124754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784537 | 6003727.74275 | 2117577.18944 | 37.7946736966861 | -122.431089877801 | (37.7946736966861, -122.431089877801) | 13 | 9 | 1 | 29490 | 27 | |
16743 | 50472 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
18343 | 38054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | 15 | 6 | 1 | 29490 | 27 | |
25580 | 117035 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
26523 | 40816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | 13 | 6 | 1 | 29490 | 27 | ||
27735 | 38526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199241 | -122.437330933595 | (37.797420199241, -122.437330933595) | 13 | 9 | 1 | 57 | 17 | ||
29891 | 138357 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | 13 | 6 | 1 | 29490 | 27 | |||
32201 | 117042 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
34736 | 35252 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.422525509838 | (37.8005900423666, -122.422525509838) | 13 | 9 | 1 | 28858 | 32 | |
35015 | 50381 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.421715351995 | (37.8008219271496, -122.421715351995) | 13 | 9 | 1 | 28858 | 32 | |
36597 | 138344 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001758.896 | 2114311.2519 | 37.7855945128702 | -122.437668325433 | (37.7855945128702, -122.437668325433) | 13 | 6 | 1 | 29490 | 27 | |||
50427 | 40817 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.7859580674702 | -122.438226135379 | (37.7859580674702, -122.438226135379) | 13 | 6 | 1 | 29490 | 27 | |
59125 | 19282 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
59237 | 138342 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | 13 | 6 | 1 | 29490 | 27 | |||
59827 | 117033 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
67493 | 138339 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | 13 | 6 | 1 | 29490 | 27 | |||
74183 | 40818 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | 13 | 6 | 1 | 29490 | 27 | ||
75851 | 138350 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001659.5245 | 2114595.4043 | 37.7863690719611 | -122.438032482637 | (37.7863690719611, -122.438032482637) | 13 | 6 | 1 | 29490 | 27 | |||
76011 | 124753 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2109 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999833.99614 | 2116225.74938 | 37.7907415881946 | -122.444465538654 | (37.7907415881946, -122.444465538654) | 13 | 6 | 1 | 29490 | 27 | |||
76223 | 33122 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.7985412065447 | -122.438525775033 | (37.7985412065447, -122.438525775033) | 13 | 9 | 1 | 57 | 17 | ||
76610 | 138346 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | 13 | 6 | 1 | 29490 | 27 | |||
79064 | 50672 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
86594 | 117034 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
91842 | 50382 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | 13 | 9 | 1 | 28858 | 32 | ||
99336 | 33133 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3016 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37363 | 6001491.05795368 | 2118756.44455004 | 37.7977846260596 | -122.438913636839 | (37.7977846260596, -122.438913636839) | 13 | 9 | 1 | 57 | 17 | ||
102025 | 19281 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
102390 | 124752 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | 13 | 9 | 1 | 29490 | 27 | ||
103175 | 35258 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.423172956092 | (37.8015923223752, -122.423172956092) | 5 | 9 | 1 | 28858 | 32 | |
104988 | 44248 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1960 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2001 12:00:00 AM | 8 | Permit Number 43683 | 5999863.26477 | 2121264.87303 | 37.8045793513217 | -122.444726628942 | (37.8045793513217, -122.444726628942) | 13 | 9 | 1 | 57 | 17 | ||
108665 | 19283 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
109176 | 45035 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2306 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43925 | 6002524.20413383 | 2117822.12502906 | 37.7952779539251 | -122.435271803602 | (37.7952779539251, -122.435271803602) | 13 | 9 | 1 | 57 | 17 | |||
110471 | 138348 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646 | (37.786350268304, -122.43818965646) | 13 | 6 | 1 | 29490 | 27 | |||
112319 | 138353 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.7864074802067 | -122.437746380915 | (37.7864074802067, -122.437746380915) | 13 | 6 | 1 | 29490 | 27 | |||
117088 | 42651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.88126 | 37.7960721541703 | -122.429007191848 | (37.7960721541703, -122.429007191848) | 13 | 9 | 1 | 57 | 17 | |
118283 | 138351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.7863847439093 | -122.437924862001 | (37.7863847439093, -122.437924862001) | 13 | 6 | 1 | 29490 | 27 | |||
135042 | 50673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
135943 | 124760 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007817.3795 | 2119902.39919 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | 5 | 1 | 1 | 308 | 32 | |||
137380 | 138778 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001713.8653 | 2114306.3395 | 37.785578464198 | -122.437823766308 | (37.785578464198, -122.437823766308) | 13 | 6 | 1 | 29490 | 27 | |||
138145 | 138352 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.7863941325812 | -122.437839612353 | (37.7863941325812, -122.437839612353) | 13 | 6 | 1 | 29490 | 27 | |||
139911 | 38043 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.443417658382 | (37.7855000811005, -122.443417658382) | 15 | 6 | 1 | 29490 | 31 | |
141281 | 138337 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001955.803 | 2114338.6797 | 37.7856810164636 | -122.436989049911 | (37.7856810164636, -122.436989049911) | 13 | 6 | 1 | 29490 | 27 | |||
142155 | 249709 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2901 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 5999701.30683 | 2117014.48804 | 37.7928996850292 | -122.444981360099 | (37.7928996850292, -122.444981360099) | 13 | 9 | 1 | 29490 | 27 | ||||
142595 | 124762 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | 5 | 1 | 1 | 308 | 32 | |||
144059 | 66784 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | 5 | 9 | 1 | 28858 | 32 | ||
147231 | 50471 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
149936 | 138338 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | 13 | 6 | 1 | 29490 | 27 | |||
155399 | 124761 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.416967423511 | (37.8013029241584, -122.416967423511) | 5 | 1 | 1 | 308 | 32 | |||
162982 | 19284 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 9 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
166110 | 50534 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.429599513219 | (37.7968102295769, -122.429599513219) | 13 | 9 | 1 | 57 | 17 | ||
169107 | 50470 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | ||
169839 | 36186 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722 | -122.45794382331 | (37.783030646722, -122.45794382331) | 11 | 6 | 1 | 54 | 31 | |
174508 | 50469 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
175021 | 42685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | 5 | 9 | 1 | 28858 | 32 | |
177563 | 38525 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.51648 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | 13 | 9 | 1 | 57 | 17 | ||
177732 | 38051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875697 | 37.7860319624569 | -122.441789880059 | (37.7860319624569, -122.441789880059) | 13 | 6 | 1 | 29490 | 27 | |
178228 | 117038 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
185557 | 138347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.7862537218777 | -122.438283486898 | (37.7862537218777, -122.438283486898) | 13 | 6 | 1 | 29490 | 27 | |||
189089 | 124759 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.8001299114167 | -122.422533316862 | (37.8001299114167, -122.422533316862) | 13 | 9 | 1 | 28858 | 32 | |||
191158 | 102771 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.423133635925 | (37.7996844799161, -122.423133635925) | 13 | 9 | 1 | 28858 | 32 | |||
2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
15666 | 44745 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.420366856354 | (37.7952406976494, -122.420366856354) | 13 | 9 | 10 | 28858 | 32 | ||
33613 | 49479 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
41332 | 249768 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 266 Lombard St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | 3 | 1 | 10 | 308 | 23 | |||
43532 | 250193 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 3 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011782.39923 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | 3 | 1 | 10 | 308 | 23 | |||
60595 | 49477 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
64202 | 253615 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221 | 2118816 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | 13 | 9 | 10 | 28858 | 32 | ||
68255 | 42696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | 5 | 1 | 10 | 28858 | 32 | |
69468 | 124758 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.7942702662113 | -122.419903713582 | (37.7942702662113, -122.419903713582) | 13 | 9 | 10 | 28858 | 32 | |||
72507 | 35266 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.422306489847 | (37.798273260158, -122.422306489847) | 13 | 9 | 10 | 28858 | 32 |
94924 | 250191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.403342304231 | (37.8016295579248, -122.403342304231) | 3 | 1 | 10 | 308 | 23 | |||
112476 | 38501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.7974092298161 | -122.420467894474 | (37.7974092298161, -122.420467894474) | 13 | 9 | 10 | 28858 | 32 | ||
137852 | 35265 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.7980573523528 | -122.422285851072 | (37.7980573523528, -122.422285851072) | 13 | 9 | 10 | 28858 | 32 | |
138647 | 44744 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | 13 | 9 | 10 | 28858 | 32 | ||
161776 | 49478 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
162974 | 250192 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | 3 | 1 | 10 | 308 | 23 | |||
163483 | 34234 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.412892958068 | (37.8046933049163, -122.412892958068) | 3 | 1 | 10 | 308 | 23 |
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) );