trees
835 rows where qSpecies_id = 122 sorted by Fire Prevention 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 | |||||||||||||
1353 | 203642 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 349x Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | 1 | 8 | 4 | 56 | 12 | |||
2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
2860 | 78000 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | 1 | 8 | 3 | 29491 | 35 | |||
3138 | 71805 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987333.5642 | 2098599.3879 | 37.7416232962242 | -122.486421183565 | (37.7416232962242, -122.486421183565) | 1 | 8 | 3 | 29491 | 35 | |||
3985 | 69145 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | 1 | 8 | 3 | 29491 | 35 | |
8576 | 32346 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
9093 | 33190 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
18718 | 262041 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1550 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5993090.57371 | 2104919.01452 | 37.7593092592319 | -122.466974886903 | (37.7593092592319, -122.466974886903) | 1 | 8 | 4 | 56 | 12 | ||||
20947 | 42897 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | 1 | 8 | 3 | 29491 | 35 | |
21787 | 32344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
26074 | 220045 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 160 Marview Way | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | 1 | 5 | 4 | 63 | 38 | |||
35036 | 215287 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.467353630083 | (37.7545548052666, -122.467353630083) | 1 | 8 | 4 | 56 | 12 | ||
37537 | 32890 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
41719 | 32347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.7644988378034 | -122.494459352499 | (37.7644988378034, -122.494459352499) | 1 | 8 | 3 | 56 | 35 | |
42163 | 29220 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
47911 | 203643 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.472459222532 | (37.7417056300124, -122.472459222532) | 1 | 8 | 4 | 29491 | 40 | |||
58218 | 34625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) | 1 | 8 | 3 | 56 | 35 |
62285 | 203225 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993973.71625 | 2104850.02282 | 37.759170760037 | -122.463915566851 | (37.759170760037, -122.463915566851) | 1 | 5 | 4 | 56 | 12 | |||
65212 | 33257 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.487622710626 | (37.7377581609646, -122.487622710626) | 1 | 8 | 3 | 29491 | 35 | ||
69322 | 203646 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | 1 | 8 | 4 | 29491 | 40 | |||
74041 | 203620 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.462844042611 | (37.7492932209146, -122.462844042611) | 1 | 8 | 4 | 29491 | 40 | |||
78215 | 182147 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989680.1915 | 2103890.3009 | 37.756287254354 | -122.478694280415 | (37.756287254354, -122.478694280415) | 1 | 8 | 3 | 56 | 35 | |||
82896 | 68073 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31811 | 5993016.05828809 | 2103198.83445662 | 37.7545817907356 | -122.467107528535 | (37.7545817907356, -122.467107528535) | 1 | 8 | 4 | 56 | 12 | ||
85779 | 37474 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | 1 | 8 | 4 | 56 | 12 | ||
88476 | 29223 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
93567 | 203645 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | 1 | 8 | 4 | 29491 | 40 | |||
93718 | 203226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993976.59011 | 2104728.66377 | 37.7588377051234 | -122.463896818678 | (37.7588377051234, -122.463896818678) | 1 | 5 | 4 | 56 | 12 | |||
95371 | 31585 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1894 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49864 | 5988492.0785 | 2102440.4028 | 37.7522371668693 | -122.482696889121 | (37.7522371668693, -122.482696889121) | 1 | 8 | 3 | 56 | 35 | |
95811 | 182146 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | 1 | 8 | 3 | 56 | 35 | |||
104471 | 34233 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1997 12:00:00 AM | 8 | Permit Number 38046 | 5989683.0382 | 2103856.1412 | 37.7561936262155 | -122.478681937543 | (37.7561936262155, -122.478681937543) | 1 | 8 | 3 | 56 | 35 | ||
113430 | 46891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1442 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2002 12:00:00 AM | Permit Number 44947 | 5993067.98197095 | 2105653.75631803 | 37.7613253640923 | -122.46710643925 | (37.7613253640923, -122.46710643925) | 1 | 8 | 4 | 56 | 12 | |||
113874 | 33256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2669 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.487622710626 | (37.7377581609646, -122.487622710626) | 1 | 8 | 3 | 29491 | 35 | |||
115291 | 42896 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2016 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 6 | Permit Number 42813 | 5986675.0189 | 2096952.6028 | 37.7370632527417 | -122.488577172427 | (37.7370632527417, -122.488577172427) | 1 | 8 | 3 | 29491 | 35 | |
115462 | 32345 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
118857 | 33192 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 53 Idora Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37399 | 5996322.19797653 | 2099597.08028102 | 37.7448825563847 | -122.455413791656 | (37.7448825563847, -122.455413791656) | 1 | 5 | 4 | 59 | 40 | ||
119589 | 67746 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1479 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31365 | 5994572.72013397 | 2105470.39847949 | 37.7609086531136 | -122.461888924556 | (37.7609086531136, -122.461888924556) | 1 | 5 | 11 | 56 | 12 | ||
121599 | 32348 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.494455919418 | (37.764529258945, -122.494455919418) | 1 | 8 | 3 | 56 | 35 | |
130368 | 55817 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1479 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50161 | 5982146.8936 | 2105055.9033 | 37.7590473873167 | -122.504832947424 | (37.7590473873167, -122.504832947424) | 1 | 8 | 3 | 56 | 35 | |
135248 | 42898 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2060 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2002 12:00:00 AM | 7 | Permit Number 45580 | 5986523.9754 | 2097068.6969 | 37.7373732015103 | -122.489107923346 | (37.7373732015103, -122.489107923346) | 1 | 8 | 3 | 64 | 35 | |
139053 | 29224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
142712 | 203221 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2398 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5992664.0139 | 2099193.92326 | 37.7435650062179 | -122.468033683007 | (37.7435650062179, -122.468033683007) | 1 | 8 | 4 | 29491 | 40 | |||
143216 | 203222 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993081.79545 | 2099194.67138 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | 1 | 8 | 4 | 29491 | 40 | |||
151023 | 203227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993976.11047 | 2104705.81134 | 37.7587749306244 | -122.463896818706 | (37.7587749306244, -122.463896818706) | 1 | 5 | 4 | 56 | 12 | |||
153429 | 33189 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 | ||
157212 | 69308 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | Permit Number 33387 | 5986864.5682116 | 2104707.11140573 | 37.7583661086574 | -122.488491577304 | (37.7583661086574, -122.488491577304) | 1 | 8 | 3 | 56 | 35 | ||
157313 | 183506 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | 1 | 8 | 3 | 29491 | 35 | |||
162082 | 218406 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994236.91998 | 2100511.76696 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | 1 | 8 | 4 | 29491 | 40 | |||
166425 | 203644 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991098.76282 | 2098712.81343 | 37.7421534852088 | -122.473410796988 | (37.7421534852088, -122.473410796988) | 1 | 8 | 4 | 29491 | 40 | |||
169088 | 37096 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.7591490872948 | -122.506987547698 | (37.7591490872948, -122.506987547698) | 1 | 8 | 3 | 56 | 35 | |
172731 | 70953 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2008 12:00:00 AM | 3x3 | Permit Number 50393 | 5992532.60289704 | 2098624.81220808 | 37.7419947820759 | -122.468446668857 | (37.7419947820759, -122.468446668857) | 1 | 8 | 4 | 29491 | 40 | ||
177297 | 184961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1990 41st Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5983548.8239 | 2101628.263 | 37.7497184185455 | -122.4997311455 | (37.7497184185455, -122.4997311455) | 1 | 8 | 3 | 29491 | 35 | |||
181068 | 34626 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.2204337 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | 1 | 8 | 3 | 56 | 35 | |
185889 | 203648 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | 1 | 8 | 4 | 29491 | 12 | |||
192506 | 36124 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | 1 | 8 | 3 | 56 | 35 | |
1532 | 219991 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 13 Bronte St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009385.52811 | 2097403.78697 | 37.739601163374 | -122.410088220496 | (37.739601163374, -122.410088220496) | 10 | 7 | 7 | 28859 | 2 | |||
5032 | 85509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
5053 | 247838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 79 Nevada St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 6009045.88807 | 2098099.79815 | 37.7414932155318 | -122.411311709481 | (37.7414932155318, -122.411311709481) | 10 | 7 | 7 | 28859 | 2 | ||||
5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
7242 | 83227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.397163015669 | (37.7601232913798, -122.397163015669) | 10 | 3 | 8 | 28856 | 29 | |||
8433 | 220003 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1001 Jarboe Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 8ft | 6009413 | 2096866 | 37.738126056693 | -122.40995527996 | (37.738126056693, -122.40995527996) | 10 | 7 | 7 | 28859 | 2 | |||
8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
10295 | 188526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 12 | Median : Yard | Tree | DPW 1 | 13 | 6016254.90623 | 2096663.38381 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | 10 | 3 | 8 | 58 | 1 | ||||
12288 | 199070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1130 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | 6013384.89381 | 2101721.18884 | 37.7516791861622 | -122.3965626049 | (37.7516791861622, -122.3965626049) | 10 | 3 | 8 | 28856 | 29 | ||||
13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
17915 | 35351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) | 10 | 3 | 8 | 28856 | 29 |
19224 | 261621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1821 25th St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
23452 | 85510 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
31049 | 66174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.7386095323365 | -122.410309598587 | (37.7386095323365, -122.410309598587) | 10 | 7 | 7 | 28859 | 2 | ||
41138 | 188519 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | 10 | 3 | 8 | 28856 | 29 | ||||
41929 | 35367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.7237949110596 | -122.401914809778 | (37.7237949110596, -122.401914809778) | 10 | 3 | 7 | 309 | 28 | ||
49822 | 24833 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/12/1996 12:00:00 AM | 25 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 | ||
50050 | 220002 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 8ft | 6009383.35593 | 2096884.07021 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | 10 | 7 | 7 | 28859 | 2 | |||
61987 | 67673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969016 | -122.393277319642 | (37.733518969016, -122.393277319642) | 10 | 3 | 8 | 58 | 1 | ||
67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
69704 | 188516 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1506 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014137.77003 | 2102020.80679 | 37.7525437439982 | -122.393980012793 | (37.7525437439982, -122.393980012793) | 10 | 3 | 8 | 28856 | 29 | |||
73591 | 220673 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.7354097767383 | -122.410119940478 | (37.7354097767383, -122.410119940478) | 10 | 7 | 7 | 28859 | 2 | |||
80369 | 36529 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3653 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39401 | 6008503.02776352 | 2097873.6031148 | 37.7408416720866 | -122.413172749536 | (37.7408416720866, -122.413172749536) | 10 | 7 | 7 | 28859 | 2 | ||
81003 | 188523 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.7333590122106 | -122.382618269437 | (37.7333590122106, -122.382618269437) | 10 | 3 | 8 | 58 | 1 | |||
84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 |
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) );