trees
891 rows where qSpecies_id = 75 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22052 | 115353 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.31579 | 37.7872484927813 | -122.39250406973 | (37.7872484927813, -122.39250406973) | 6 | 2 | 9 | 28855 | 6 | |
26350 | 115356 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.392702738938 | (37.7874085478076, -122.392702738938) | 6 | 2 | 9 | 28855 | 6 | |
30147 | 115348 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.78532 | 37.7869832575075 | -122.39216652446 | (37.7869832575075, -122.39216652446) | 6 | 2 | 9 | 28855 | 6 | |
60187 | 115352 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | 6 | 2 | 9 | 28855 | 6 | |
65353 | 115355 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | 6 | 2 | 9 | 28855 | 6 | |
101037 | 115350 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.392290933986 | (37.7870777663613, -122.392290933986) | 6 | 2 | 9 | 28855 | 6 | |
116898 | 115354 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.62773 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | 6 | 2 | 9 | 28855 | 6 | |
152753 | 115349 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.7870350854597 | -122.392234997951 | (37.7870350854597, -122.392234997951) | 6 | 2 | 9 | 28855 | 6 | |
153202 | 115351 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.41874 | 2114606.67601 | 37.7871417890985 | -122.392368086818 | (37.7871417890985, -122.392368086818) | 6 | 2 | 9 | 28855 | 6 | |
33530 | 654 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3255X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007301.14928 | 2102040.7128 | 37.7522160715366 | -122.417623684893 | (37.7522160715366, -122.417623684893) | 2 | 4 | 7 | 28859 | 19 | ||
34900 | 586 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6008691.81998 | 2102185.56005 | 37.7526919453923 | -122.412824751929 | (37.7526919453923, -122.412824751929) | 2 | 4 | 7 | 28859 | 19 | ||
41046 | 7375 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2907X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6009449.8972236 | 2102159.1699056 | 37.7526620055733 | -122.410201312287 | (37.7526620055733, -122.410201312287) | 2 | 4 | 7 | 28859 | 19 | ||
42423 | 220490 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.47366 | 37.7526501625767 | -122.412676557499 | (37.7526501625767, -122.412676557499) | 2 | 4 | 7 | 28859 | 19 | ||
51075 | 28683 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | 10 | 3 | 7 | 309 | 28 | ||
94330 | 658 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3266 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007255.02148 | 2102083.69856 | 37.7523315048963 | -122.417786249056 | (37.7523315048963, -122.417786249056) | 2 | 4 | 7 | 28859 | 19 | ||
44340 | 4154 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3718 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 6 | 3X3 | 6005698.24114 | 2100539.02617 | 37.748002458148 | -122.423060071381 | (37.748002458148, -122.423060071381) | 2 | 4 | 5 | 28859 | 19 | ||
50503 | 50676 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | 6 | 2 | 9 | 28853 | 34 | |
5294 | 8118 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.7777369494126 | -122.430681932079 | (37.7777369494126, -122.430681932079) | 7 | 9 | 11 | 29492 | 10 | ||
57733 | 29065 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138357 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | 7 | 9 | 11 | 29490 | 41 | ||
65770 | 14780 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.428626804528 | (37.7789575666093, -122.428626804528) | 7 | 9 | 11 | 29490 | 41 | ||
69133 | 14784 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1067 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 4X4 | 6004083.6303203 | 2111809.5297481 | 37.7788573137505 | -122.429446949988 | (37.7788573137505, -122.429446949988) | 7 | 9 | 11 | 29490 | 41 | ||
141033 | 29066 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138357 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | 7 | 9 | 11 | 29490 | 41 | ||
142750 | 8105 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 780 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 8 | 3X3 | 6004061.6732 | 2111513.0828 | 37.7780421005615 | -122.429501761419 | (37.7780421005615, -122.429501761419) | 7 | 9 | 11 | 28852 | 41 | ||
191096 | 29063 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1000X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
17628 | 243500 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 957 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773003 | 6009168.25876 | 2103593.36659 | 37.7565841965306 | -122.411276577455 | (37.7565841965306, -122.411276577455) | 2 | 4 | 7 | 28859 | 19 | |
51018 | 671 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3300X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.418469082047 | (37.7523068461089, -122.418469082047) | 2 | 4 | 7 | 28859 | 19 | ||
91434 | 672 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3300X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.418469082047 | (37.7523068461089, -122.418469082047) | 2 | 4 | 7 | 28859 | 19 | ||
42035 | 91046 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | 10 | 3 | 7 | 309 | 28 | ||
180466 | 220498 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.7601387417168 | -122.43922504972 | (37.7601387417168, -122.43922504972) | 2 | 4 | 5 | 28862 | 3 | |
5464 | 66327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.488001017639 | (37.7642819711606, -122.488001017639) | 1 | 8 | 3 | 56 | 35 | |
1240 | 860 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902 | 2095033.66744 | 37.7330190549875 | -122.414497094675 | (37.7330190549875, -122.414497094675) | 2 | 7 | 7 | 28859 | 2 | ||
6991 | 112084 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
17288 | 87548 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2809 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2015 12:00:00 AM | 3 | 3x3 | 6011363.6591 | 2092480.1221 | 37.7261924887101 | -122.402902454386 | (37.7261924887101, -122.402902454386) | 10 | 3 | 7 | 309 | 28 | ||
20764 | 108061 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.04187 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | 6 | 2 | 9 | 28855 | 6 | ||
99183 | 108062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.7876196672567 | -122.392963130455 | (37.7876196672567, -122.392963130455) | 6 | 2 | 9 | 28855 | 6 | ||
127705 | 108060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.49264 | 37.7875236349662 | -122.392848365253 | (37.7875236349662, -122.392848365253) | 6 | 2 | 9 | 28855 | 6 | ||
69882 | 8246 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
86398 | 125408 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 830 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2015 12:00:00 AM | 4 | Width 4ft | 6006361.84102 | 2113219.81406 | 37.7828583334858 | -122.42166589828 | (37.7828583334858, -122.42166589828) | 7 | 9 | 11 | 28858 | 41 | ||
35834 | 122701 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
23670 | 24903 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2810 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2001 12:00:00 AM | 3 | 3X3 | 6011300.9294843 | 2092506.3204879 | 37.7262609211022 | -122.403121150432 | (37.7262609211022, -122.403121150432) | 10 | 3 | 7 | 309 | 28 | ||
142792 | 38959 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | 13 | 6 | 1 | 29490 | 27 | ||
1770 | 122656 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
5536 | 122646 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
7971 | 122653 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
8221 | 122657 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
10505 | 122650 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
11819 | 122647 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
12580 | 122655 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13152 | 122648 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13368 | 122658 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13486 | 122649 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
14226 | 122645 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
14390 | 122652 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
16082 | 122660 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17571 | 122654 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17771 | 122651 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17800 | 122661 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
18374 | 122659 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
100678 | 94790 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | 1 | 8 | 4 | 29491 | 12 | |||
67673 | 8236 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
190666 | 86614 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1070 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010177 | 2109056 | 37.7716398686135 | -122.4081732249 | (37.7716398686135, -122.4081732249) | 14 | 2 | 9 | 28853 | 34 | ||
82230 | 53151 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.386313991736 | (37.7293905172533, -122.386313991736) | 10 | 3 | 8 | 58 | 1 | ||
191487 | 53153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.7294326204666 | -122.386379154297 | (37.7294326204666, -122.386379154297) | 10 | 3 | 8 | 58 | 1 | ||
79164 | 52149 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1566 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48340 | 6015439.23849 | 2096619.2496 | 37.737784433907 | -122.389102155646 | (37.737784433907, -122.389102155646) | 10 | 3 | 8 | 58 | 1 |
147343 | 52126 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 482 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 5 | Permit Number 48311 | 6005097.5281 | 2110773.3561 | 37.7760695863917 | -122.425865698035 | (37.7760695863917, -122.425865698035) | 7 | 9 | 11 | 28852 | 10 | |
77538 | 38793 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | 6 | Permit Number 40642 | 6012718.22828 | 2111411.20954 | 37.7782487018563 | -122.399548292025 | (37.7782487018563, -122.399548292025) | 6 | 2 | 9 | 28856 | 34 | ||
106018 | 60333 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 4051 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1982 12:00:00 AM | Permit Number 19906 | 6002674.88696195 | 2104708.78701715 | 37.7592805573459 | -122.433812685394 | (37.7592805573459, -122.433812685394) | 2 | 4 | 5 | 28862 | 3 | |||
22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
125360 | 92755 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
173673 | 92758 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
175622 | 92757 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
106728 | 64005 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 5x9 | Permit Number 24752 | 6002309.37367781 | 2100887.25267027 | 37.7487667887863 | -122.434803521117 | (37.7487667887863, -122.434803521117) | 2 | 4 | 5 | 28862 | 22 | |
101188 | 251420 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2775 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2018 12:00:00 AM | 3x3 | 6000680 | 2114785 | 37.7868338993394 | -122.441434988756 | (37.7868338993394, -122.441434988756) | 13 | 6 | 1 | 29490 | 27 | |||
60651 | 68389 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.7284208987036 | -122.43531143848 | (37.7284208987036, -122.43531143848) | 9 | 7 | 6 | 28861 | 25 | |
26661 | 56057 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237592 | (37.7558082292146, -122.41140237592) | 2 | 4 | 7 | 28859 | 19 | |||
38677 | 59325 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.422241292597 | (37.7778598467005, -122.422241292597) | 7 | 9 | 11 | 28852 | 10 | ||
66465 | 86610 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1174 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/20/2012 12:00:00 AM | 3 | 3x3 | 6009792 | 2108692 | 37.7706188440328 | -122.409479274697 | (37.7706188440328, -122.409479274697) | 8 | 2 | 9 | 28853 | 34 | ||
17021 | 53357 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.31742 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | 6 | 2 | 9 | 28855 | 6 | ||
42224 | 100778 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
53217 | 100773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
62005 | 100775 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
83821 | 100777 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
104491 | 100779 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
149926 | 100776 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
184236 | 100774 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
16448 | 253390 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
35828 | 48550 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
41561 | 48548 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
47592 | 48549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
114155 | 48551 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
18300 | 24863 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213 | (37.7283158506885, -122.40395790213) | 10 | 3 | 7 | 309 | 28 | ||
41417 | 24862 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2626 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 4 | 3x3 | 6011036.3806 | 2093380.4977 | 37.7286464524247 | -122.404097181781 | (37.7286464524247, -122.404097181781) | 10 | 3 | 7 | 309 | 28 | ||
62526 | 24880 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.7308959524537 | -122.404855607729 | (37.7308959524537, -122.404855607729) | 10 | 3 | 7 | 309 | 28 | ||
92071 | 27312 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2670 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011119.0302 | 2093108.0343 | 37.7279029423042 | -122.403792291485 | (37.7279029423042, -122.403792291485) | 10 | 3 | 7 | 309 | 28 | ||
105112 | 24888 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2774 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 8 | 4x4 | 6011251.1604 | 2092677.7834 | 37.7267289432293 | -122.403305257203 | (37.7267289432293, -122.403305257203) | 10 | 3 | 7 | 309 | 28 | ||
108227 | 24872 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2675 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011136.5589 | 2093211.8894 | 37.7281890860167 | -122.403738998556 | (37.7281890860167, -122.403738998556) | 10 | 3 | 7 | 309 | 28 | ||
147104 | 24887 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2770 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 3 | 4x4 | 6011241.1722 | 2092707.2223 | 37.7268092184902 | -122.403341856394 | (37.7268092184902, -122.403341856394) | 10 | 3 | 7 | 309 | 28 | ||
169367 | 27313 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2684 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6011127.7854 | 2093073.5386 | 37.7278087133965 | -122.403759598129 | (37.7278087133965, -122.403759598129) | 10 | 3 | 7 | 309 | 28 |
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) );