trees
274 rows where Supervisor Districts = 9 and qLegalStatus_id = 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
72432 | 122594 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
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 | ||||
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 | ||||
74052 | 201694 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009941.3987 | 2109939.6045 | 37.7740528464887 | -122.409050544971 | (37.7740528464887, -122.409050544971) | 8 | 2 | 9 | 28853 | 34 | |
74410 | 201698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010000.12901 | 2109874.7171 | 37.7738779706193 | -122.408842806955 | (37.7738779706193, -122.408842806955) | 8 | 2 | 9 | 28853 | 34 | |
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 | ||||
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
77658 | 94315 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122 | 2112982 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | 7 | 10 | 9 | 28852 | 36 | |
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 | ||
79696 | 253247 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
80342 | 121514 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
80358 | 121522 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
81347 | 117017 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | 7 | 10 | 9 | 28852 | 36 | |
81393 | 121521 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
84511 | 109468 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013267.70036 | 2109332.73182 | 37.7725722854256 | -122.397501645497 | (37.7725722854256, -122.397501645497) | 14 | 2 | 9 | 310 | 20 | ||
84600 | 117455 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 236 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776408 | 6011503.45491 | 2111758.78759 | 37.7791352841027 | -122.403775126323 | (37.7791352841027, -122.403775126323) | 14 | 2 | 9 | 28856 | 34 | ||
84993 | 253492 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
85377 | 253490 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
85953 | 201697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009987.20299 | 2109888.7351 | 37.7739157367544 | -122.408888509595 | (37.7739157367544, -122.408888509595) | 8 | 2 | 9 | 28853 | 34 | |
87472 | 255403 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 2 | 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 | ||
88035 | 113653 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
88090 | 85806 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 2 | 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 | |
90566 | 120518 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 520 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010156 | 2108818 | 37.7709851997146 | -122.408229076629 | (37.7709851997146, -122.408229076629) | 8 | 2 | 9 | 28853 | 34 | ||||
91455 | 85807 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 3 | 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 | |
93105 | 253487 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
93218 | 113240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 2 | 3x4 | Permit Number 770912 | 6014728.70394 | 2112464.72966 | 37.7812532891345 | -122.392666980121 | (37.7812532891345, -122.392666980121) | 6 | 2 | 9 | 28856 | 6 | |
93518 | 115534 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.7775284833993 | -122.418420222514 | (37.7775284833993, -122.418420222514) | 7 | 9 | 9 | 28852 | 36 | ||
94254 | 121506 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012227.3168 | 2112699.1751 | 37.7817577819585 | -122.401337080379 | (37.7817577819585, -122.401337080379) | 6 | 2 | 9 | 28856 | 34 | |||
95654 | 253488 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
95774 | 105277 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.28649 | 37.7811718861147 | -122.38996007562 | (37.7811718861147, -122.38996007562) | 6 | 2 | 9 | 28856 | 6 | |
96128 | 73589 | Planning Code 138.1 required 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 468 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 770905 | 6010928.13640467 | 2111848.51157587 | 37.7793494887795 | -122.405771720076 | (37.7793494887795, -122.405771720076) | 14 | 2 | 9 | 28853 | 34 | |
96508 | 115347 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854 | 2114630 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | 6 | 2 | 9 | 28855 | 6 | |
97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
98537 | 196590 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 2 | : | Tree | Private 2 | 10 | Width 3ft | Permit Number 772992 | 6007565.69447 | 2109618.27361 | 37.7730371773558 | -122.417245760983 | (37.7730371773558, -122.417245760983) | 8 | 2 | 9 | 28853 | 19 | ||
98758 | 101942 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.29372 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | 14 | 2 | 9 | 28853 | 34 | |
98874 | 255694 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
99698 | 113643 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
100384 | 122598 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
100470 | 121527 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
101009 | 121510 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 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 | |
102091 | 121512 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
102133 | 113329 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770912 | 6014656.6559 | 2112395.64308 | 37.7810595913673 | -122.392911397837 | (37.7810595913673, -122.392911397837) | 6 | 2 | 9 | 28856 | 6 | |
103030 | 121533 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
103456 | 121525 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | |||
104520 | 105275 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | 6 | 2 | 9 | 28856 | 6 | |
105665 | 253493 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
105773 | 255696 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
106371 | 121516 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
106809 | 29017 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 120 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | 8 | 2 | 9 | 28853 | 34 | |
107192 | 201696 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009973.11931 | 2109904.86997 | 37.773959250457 | -122.408938366227 | (37.773959250457, -122.408938366227) | 8 | 2 | 9 | 28853 | 34 | |
107276 | 121511 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
108346 | 255693 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
108535 | 255409 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 5 | 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 | ||
109022 | 255406 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 2 | 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 | ||
109444 | 255700 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 510 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
110801 | 187940 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.391761444649 | (37.7891719160015, -122.391761444649) | 6 | 2 | 9 | 28855 | 6 | ||||
111086 | 122596 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
112760 | 196591 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 3 | : | Tree | Private 2 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | 8 | 2 | 9 | 28853 | 19 | ||
115539 | 109460 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013412.32492 | 2109471.0252 | 37.7729600595772 | -122.397011068921 | (37.7729600595772, -122.397011068921) | 14 | 2 | 9 | 310 | 20 | ||
115603 | 251289 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
115681 | 115533 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | 7 | 9 | 9 | 28852 | 36 | ||
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 | |
117291 | 113647 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
117838 | 121542 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
118733 | 72480 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 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 | |||
120636 | 121503 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.393943755694 | (37.7884053276005, -122.393943755694) | 6 | 2 | 9 | 28855 | 6 | |||
121157 | 257909 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
121557 | 113652 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
121637 | 253479 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
122606 | 187947 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | 6 | 2 | 9 | 28855 | 6 | ||||
122740 | 115096 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | 14 | 2 | 9 | 28853 | 34 | |
123746 | 117456 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 236 SHIPLEY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | ||
124352 | 255410 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 6 | 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 | ||
124736 | 251212 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 5 | 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 | |
124821 | 113644 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
125850 | 113335 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | 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 | ||
126119 | 85804 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | 14 | 2 | 9 | 28856 | 34 | |
126344 | 109462 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013376.015 | 2109435.75899 | 37.7728612052211 | -122.3971341969 | (37.7728612052211, -122.3971341969) | 14 | 2 | 9 | 310 | 20 | ||
127231 | 109459 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013430.92674 | 2109487.72122 | 37.7730069385559 | -122.396947893341 | (37.7730069385559, -122.396947893341) | 14 | 2 | 9 | 310 | 20 | ||
128069 | 104819 | Planning Code 138.1 required 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | 14 | 2 | 9 | 28853 | 34 | |
128513 | 199503 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.98308 | 2111924.50305 | 37.7795342467397 | -122.407254787701 | (37.7795342467397, -122.407254787701) | 14 | 2 | 9 | 28853 | 34 | |
128863 | 253475 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
130074 | 255415 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 11 | 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 | ||
130377 | 113654 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
132587 | 199504 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | 14 | 2 | 9 | 28853 | 34 | |
132870 | 118376 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
133882 | 187944 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | 6 | 2 | 9 | 28855 | 6 | ||||
134197 | 201699 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010014.86815 | 2109861.25987 | 37.7738418457656 | -122.408790872027 | (37.7738418457656, -122.408790872027) | 8 | 2 | 9 | 28853 | 34 | |
134726 | 113241 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3 | 3x4 | Permit Number 770912 | 6014742.36618 | 2112476.99378 | 37.7812877223957 | -122.39262057329 | (37.7812877223957, -122.39262057329) | 6 | 2 | 9 | 28856 | 6 | |
134827 | 255697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
135281 | 253476 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
135842 | 115529 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | 7 | 9 | 9 | 28852 | 36 | |
136714 | 65940 | Planning Code 138.1 required 2 | Liquidambar styraciflua :: American Sweet Gum 37 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.7833233693217 | -122.417975883707 | (37.7833233693217, -122.417975883707) | 7 | 9 | 9 | 28858 | 36 | |
137539 | 113649 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
138609 | 251178 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 |
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) );