trees
891 rows where qSpecies_id = 75 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2135 | 187956 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014829.80215 | 2114536.31276 | 37.7869469986487 | -122.392462171218 | (37.7869469986487, -122.392462171218) | 6 | 2 | 9 | 28855 | 6 | |||
3170 | 38792 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.7782184558633 | -122.399595224034 | (37.7782184558633, -122.399595224034) | 6 | 2 | 9 | 28856 | 34 | |
5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
9269 | 71335 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011311.01378 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | 14 | 2 | 9 | 28856 | 34 | |||
9905 | 187906 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011990.7752 | 2114556.67649 | 37.7868448464448 | -122.402286048678 | (37.7868448464448, -122.402286048678) | 12 | 2 | 9 | 28855 | 6 | |||
11352 | 73737 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013232.29052 | 2111907.2745 | 37.7796394233505 | -122.397804754791 | (37.7796394233505, -122.397804754791) | 6 | 2 | 9 | 28856 | 34 | |||
11492 | 187952 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014738.2491 | 2114633.83833 | 37.7872096969197 | -122.392785751786 | (37.7872096969197, -122.392785751786) | 6 | 2 | 9 | 28855 | 6 | |||
14551 | 72302 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013261.50947 | 2111935.00833 | 37.7797172012305 | -122.397705618927 | (37.7797172012305, -122.397705618927) | 6 | 2 | 9 | 28856 | 34 | |||
16780 | 85805 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 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 | ||
17046 | 189066 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 521 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013735.14278 | 2112387.07191 | 37.7809848280366 | -122.396098793052 | (37.7809848280366, -122.396098793052) | 6 | 2 | 9 | 28856 | 34 | |||
17355 | 258161 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 335 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009797.86626 | 2110165.76552 | 37.7746657903123 | -122.409563015883 | (37.7746657903123, -122.409563015883) | 8 | 2 | 9 | 28853 | 34 | |||
17501 | 251213 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
17637 | 187932 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015226.56568 | 2115767.07954 | 37.7903484270771 | -122.391175510261 | (37.7903484270771, -122.391175510261) | 6 | 2 | 9 | 28855 | 6 | |||
19345 | 101991 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
19613 | 187949 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | ||
20904 | 189063 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011103.55748 | 2108718.67114 | 37.7707654781809 | -122.40494443566 | (37.7707654781809, -122.40494443566) | 14 | 2 | 9 | 28853 | 34 | |||
21266 | 187936 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 255 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014368.82149 | 2115126.24847 | 37.7885412160406 | -122.394098386929 | (37.7885412160406, -122.394098386929) | 6 | 2 | 9 | 28855 | 6 | |||
21732 | 121544 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |
23360 | 189070 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009807.62506 | 2108635.36026 | 37.7704641998942 | -122.409421229304 | (37.7704641998942, -122.409421229304) | 8 | 2 | 9 | 28853 | 34 | |||
24322 | 187931 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | 6 | 2 | 9 | 28855 | 6 | |||
24868 | 71898 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | 7 | 10 | 9 | 28858 | 36 | |
24954 | 255884 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |
26680 | 187919 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | 12 | 2 | 9 | 28855 | 6 | |||
27552 | 187948 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | ||||
28512 | 101993 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
28570 | 187924 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013555.31002 | 2115180.42433 | 37.7886447217118 | -122.396916831643 | (37.7886447217118, -122.396916831643) | 12 | 2 | 9 | 28855 | 6 | |||
28605 | 88152 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
29533 | 187958 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 43 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014361.38404 | 2114182.65198 | 37.7859499041048 | -122.394058036143 | (37.7859499041048, -122.394058036143) | 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 | |
30239 | 121540 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
31665 | 189088 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 693 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009010.6716 | 2111090.12277 | 37.7771597163869 | -122.412351439063 | (37.7771597163869, -122.412351439063) | 8 | 2 | 9 | 28853 | 34 | |||
32175 | 187928 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013614.18616 | 2115234.9562 | 37.7887977305714 | -122.396716951919 | (37.7887977305714, -122.396716951919) | 12 | 2 | 9 | 28855 | 6 | |||
32270 | 118379 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
34271 | 251211 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
34491 | 187942 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015080.74918 | 2115307.92538 | 37.7890796023783 | -122.391647913344 | (37.7890796023783, -122.391647913344) | 6 | 2 | 9 | 28855 | 6 | ||||
34543 | 187929 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013625.5813 | 2115247.15828 | 37.7888318688552 | -122.396678381805 | (37.7888318688552, -122.396678381805) | 12 | 2 | 9 | 28855 | 6 | |||
35800 | 121504 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.394000660325 | (37.7884522533286, -122.394000660325) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
36599 | 187905 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011979.98788 | 2114548.14877 | 37.7868208291727 | -122.402322770701 | (37.7868208291727, -122.402322770701) | 12 | 2 | 9 | 28855 | 6 | |||
37173 | 187933 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | 6 | 2 | 9 | 28855 | 6 | |||
37189 | 121502 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | 6 | 2 | 9 | 28855 | 6 | |||
37618 | 189085 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 350 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011651.36739 | 2112788.81807 | 37.7819717701308 | -122.403335914547 | (37.7819717701308, -122.403335914547) | 6 | 2 | 9 | 28853 | 34 | |||
40161 | 88150 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
40751 | 121505 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
42019 | 88168 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675 | 2112537 | 37.7812816562818 | -122.403236436508 | (37.7812816562818, -122.403236436508) | 6 | 2 | 9 | 28853 | 34 | ||
42633 | 118377 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
42965 | 49242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
43780 | 187954 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014772.69279 | 2114599.27503 | 37.7871167070277 | -122.392664164317 | (37.7871167070277, -122.392664164317) | 6 | 2 | 9 | 28855 | 6 | |||
44124 | 187938 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 235 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6014012.10729 | 2114977.49045 | 37.7881129283138 | -122.395322147516 | (37.7881129283138, -122.395322147516) | 6 | 2 | 9 | 28855 | 6 | |||
46552 | 187907 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012037.39416 | 2114599.46395 | 37.7869649329299 | -122.402127766205 | (37.7869649329299, -122.402127766205) | 12 | 2 | 9 | 28855 | 6 | |||
46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
47304 | 256005 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |||
47707 | 254263 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 6 | 2 | 9 | 28855 | 6 | ||||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
48410 | 255900 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3x3 | 6012744.76196 | 2111515.06694 | 37.7785353494244 | -122.399463794931 | (37.7785353494244, -122.399463794931) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |
52360 | 189059 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 925 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011015.17329 | 2109787.29138 | 37.7736947229667 | -122.405325426246 | (37.7736947229667, -122.405325426246) | 14 | 2 | 9 | 28853 | 34 | |||
53211 | 49231 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
56780 | 189071 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | 8 | 2 | 9 | 28853 | 34 | |||
58649 | 88170 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011731.58168 | 2112591.71808 | 37.781435059217 | -122.403044540485 | (37.781435059217, -122.403044540485) | 6 | 2 | 9 | 28853 | 34 | |
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 | |
60353 | 187962 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | 14 | 2 | 9 | 28856 | 34 | |||
61065 | 189076 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010179.59918 | 2108995.88933 | 37.7714749641405 | -122.408159994002 | (37.7714749641405, -122.408159994002) | 14 | 2 | 9 | 28853 | 34 | |||
63463 | 189060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011065.32352 | 2108759.62205 | 37.7708757827119 | -122.405079572281 | (37.7708757827119, -122.405079572281) | 14 | 2 | 9 | 28853 | 34 | |||
64187 | 107152 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | |||
64723 | 118378 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
64870 | 255402 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
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 | |
65557 | 189072 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1111 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009937.54757 | 2108756.65629 | 37.7708045294385 | -122.408980384349 | (37.7708045294385, -122.408980384349) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||
66507 | 121501 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.393841081021 | (37.7883300516388, -122.393841081021) | 6 | 2 | 9 | 28855 | 6 | |||
66781 | 187921 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013082.09278 | 2115028.00052 | 37.7881998495857 | -122.398543403948 | (37.7881998495857, -122.398543403948) | 12 | 2 | 9 | 28855 | 6 | |||
67060 | 88172 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011709.51547 | 2112571.62711 | 37.7813786618321 | -122.403119465684 | (37.7813786618321, -122.403119465684) | 6 | 2 | 9 | 28853 | 34 | |
68507 | 255556 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
68525 | 86683 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 925 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011000.86666 | 2109774.4042 | 37.7736585378513 | -122.405374007613 | (37.7736585378513, -122.405374007613) | 14 | 2 | 9 | 28853 | 34 | ||
70059 | 118374 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x6 | 6014693.17098 | 2114681.80971 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | 6 | 2 | 9 | 28855 | 6 | |||
71462 | 187943 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015093.73077 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | 6 | 2 | 9 | 28855 | 6 | ||||
72419 | 255414 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
73578 | 187945 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015129.76051 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | 6 | 2 | 9 | 28855 | 6 | ||||
73605 | 189062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011094.42559 | 2108729.00589 | 37.7707933445767 | -122.404976750984 | (37.7707933445767, -122.404976750984) | 14 | 2 | 9 | 28853 | 34 | |||
73712 | 121545 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
73863 | 255534 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
75283 | 118380 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
76630 | 187902 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 47 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6013611.03319 | 2115912.70701 | 37.790658500748 | -122.396775394381 | (37.790658500748, -122.396775394381) | 12 | 2 | 9 | 28855 | 6 | |||
76990 | 255558 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | ||
78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
79448 | 88153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
79511 | 116155 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167X Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777681 | 6011953.87529 | 2114523.89639 | 37.7867527801633 | -122.402411408766 | (37.7867527801633, -122.402411408766) | 12 | 2 | 9 | 28855 | 6 | |
81119 | 187951 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015307.96603 | 2115072.71193 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | 6 | 2 | 9 | 28855 | 6 | ||||
81278 | 187904 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011967.30497 | 2114536.37936 | 37.7867878051538 | -122.402365823018 | (37.7867878051538, -122.402365823018) | 12 | 2 | 9 | 28855 | 6 | |||
84101 | 255881 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 |
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) );