trees
261 rows where qSpecies_id = 177
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63720 | 13009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 378 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 02:11:00 PM | 3 | 4X4 | 6010539.0395 | 2120665.4782 | 37.8035369920045 | -122.407739641802 | (37.8035369920045, -122.407739641802) | 3 | 1 | 10 | 308 | 23 | ||
66436 | 98847 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
66864 | 117270 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6002050 | 2101440 | 37.7502697725383 | -122.435739974128 | (37.7502697725383, -122.435739974128) | 2 | 4 | 5 | 28862 | 22 | |||
68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
68237 | 13015 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686 | 2120602.2788 | 37.8033519082048 | -122.408449280112 | (37.8033519082048, -122.408449280112) | 3 | 1 | 10 | 308 | 23 | ||
69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
70827 | 13016 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | 3 | 1 | 10 | 308 | 23 | ||
72042 | 13024 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801149 | (37.8032939775537, -122.40885801149) | 3 | 1 | 10 | 308 | 23 | ||
72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
72976 | 13010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.8035349377887 | -122.407866624342 | (37.8035349377887, -122.407866624342) | 3 | 1 | 10 | 308 | 23 | ||
74050 | 103596 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
74355 | 115438 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | 5 | 9 | 1 | 28858 | 32 | ||
74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
76277 | 24659 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.45264 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | 11 | 6 | 2 | 54 | 16 | |
76872 | 13011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524598 | (37.8035195251148, -122.40795524598) | 3 | 1 | 10 | 308 | 23 | ||
77118 | 100396 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 500X Oak Park Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/18/2012 12:00:00 AM | 3 | 3x9 | Permit Number 769101 | 5994983.3 | 2103652.8 | 37.7559416221353 | -122.460337221652 | (37.7559416221353, -122.460337221652) | 1 | 5 | 4 | 63 | 12 | |
77164 | 17862 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.430996333749 | (37.7882072868246, -122.430996333749) | 13 | 9 | 11 | 29490 | 27 | ||
77303 | 100044 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1250 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 3x3 | Permit Number 768984 | 6012201 | 2102568.4 | 37.7539394855375 | -122.400716201774 | (37.7539394855375, -122.400716201774) | 10 | 3 | 8 | 28856 | 29 | ||
77723 | 55923 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | 1 | 8 | 4 | 56 | 12 | |
77781 | 115289 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.7613911460485 | -122.47167612106 | (37.7613911460485, -122.47167612106) | 1 | 8 | 4 | 56 | 12 | |||
77866 | 13055 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 08:41:00 AM | 3 | 3x3 | 6009605.5749 | 2120542.0431 | 37.8031457701614 | -122.410961227909 | (37.8031457701614, -122.410961227909) | 3 | 1 | 10 | 308 | 23 | ||
78246 | 143041 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2000 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780933 | 6009568.471 | 2120534.3867 | 37.8031226669303 | -122.411089086343 | (37.8031226669303, -122.411089086343) | 3 | 1 | 10 | 308 | 23 | |
80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
83725 | 13075 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |
83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
85994 | 76813 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
87120 | 107140 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 250X Roosevelt Way | Median : Cutout | Tree | Private 2 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.7660055827084 | -122.440493678393 | (37.7660055827084, -122.440493678393) | 15 | 5 | 5 | 29492 | 3 | |||
88367 | 95578 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||||
88961 | 252853 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
90969 | 115004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1050 MCALLISTER ST | 5 | Front Yard : Cutout | Tree | Office of Mayor 9 | DPW | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148 | 2111858 | 37.7789940453007 | -122.429227726914 | (37.7789940453007, -122.429227726914) | 7 | 9 | 11 | 29490 | 41 | |
91107 | 102914 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | 13 | 9 | 1 | 57 | 17 | ||
91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
91598 | 76793 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
92159 | 55721 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 62 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1973 12:00:00 AM | 30 | Permit Number 11744 | 6003135.04861118 | 2107940.94065447 | 37.768181370821 | -122.432452080859 | (37.768181370821, -122.432452080859) | 15 | 5 | 5 | 28862 | 3 | ||
92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
94001 | 143039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | 3 | 1 | 10 | 308 | 23 | |||
94231 | 258514 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
94466 | 255395 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
95489 | 103593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
100244 | 115008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.7751307960032 | -122.492038018346 | (37.7751307960032, -122.492038018346) | 11 | 6 | 2 | 55 | 26 | |||
101932 | 116717 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | ||
102162 | 216685 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.87199 | 37.7202447887441 | -122.462335661261 | (37.7202447887441, -122.462335661261) | 9 | 8 | 6 | 28861 | 24 | ||
102218 | 252854 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
102904 | 258517 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
104430 | 53808 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997126.8655565 | 2112925.05365722 | 37.7815239200353 | -122.453593590958 | (37.7815239200353, -122.453593590958) | 11 | 6 | 2 | 54 | 16 | ||
105519 | 97293 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2011 12:00:00 AM | 3x3 | Permit Number 768386 | 5989030.8 | 2106542.7 | 37.7635322996796 | -122.481134285356 | (37.7635322996796, -122.481134285356) | 1 | 8 | 3 | 56 | 35 | ||
106404 | 76809 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
107470 | 112520 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
108273 | 93575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
108474 | 63786 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4035 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52930 | 6003624.27213054 | 2101252.89355661 | 37.7498453184987 | -122.43028269297 | (37.7498453184987, -122.43028269297) | 2 | 4 | 5 | 28862 | 22 | ||
109612 | 55389 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11326 | 5993364.66899649 | 2106056.80614716 | 37.762449154491 | -122.466109621957 | (37.762449154491, -122.466109621957) | 1 | 8 | 11 | 56 | 12 | ||
109870 | 112779 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
110398 | 90511 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.726692 | 2112113.510215 | 37.7787749594642 | -122.484707869401 | (37.7787749594642, -122.484707869401) | 11 | 6 | 2 | 55 | 26 | |
111732 | 12989 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 325 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780097 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | |
113350 | 116238 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
114150 | 104604 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
114886 | 50468 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.458950895655 | (37.7465436862786, -122.458950895655) | 1 | 8 | 4 | 59 | 40 | |
114910 | 102005 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
114926 | 116249 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
115031 | 122520 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 250 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | 2 | 7 | 5 | 63 | 7 | ||||
116521 | 143019 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) | 3 | 1 | 10 | 308 | 23 | |||
116618 | 43627 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.492966865959 | (37.7454355618475, -122.492966865959) | 1 | 8 | 3 | 29491 | 35 |
119291 | 93577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | |
120038 | 116245 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120178 | 116251 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
120674 | 124797 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.7957629573367 | -122.446414930702 | (37.7957629573367, -122.446414930702) | 13 | 9 | 1 | 57 | 17 | |
123252 | 162764 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.40289 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | 9 | 8 | 6 | 28861 | 24 | ||
123771 | 116260 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
123811 | 13034 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 490 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:07:00 PM | 3 | 3x3 | 6010037.8987 | 2120598.0598 | 37.8033238110836 | -122.409469108899 | (37.8033238110836, -122.409469108899) | 3 | 1 | 10 | 308 | 23 | ||
123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
124462 | 17911 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.483 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | 13 | 9 | 11 | 29490 | 27 | ||
125035 | 255253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2178 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6003537 | 2115267 | 37.7883196953611 | -122.43158486312 | (37.7883196953611, -122.43158486312) | 13 | 9 | 1 | 29490 | 27 | ||
125406 | 104605 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
126183 | 13014 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010352 | 2120661 | 37.8035142236954 | -122.408386587386 | (37.8035142236954, -122.408386587386) | 3 | 1 | 10 | 308 | 23 | ||
128647 | 255530 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 301 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | ||||
128671 | 13042 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | 3 | 1 | 10 | 308 | 23 | ||
128713 | 255394 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
129328 | 92913 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 87 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2009 12:00:00 AM | 3 | 6x12 | Permit Number 53113 | 6005252.7 | 2107310.7 | 37.7665707358936 | -122.425082484344 | (37.7665707358936, -122.425082484344) | 8 | 4 | 5 | 28853 | 19 | |
131941 | 9116 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.481186169595 | (37.7801152084298, -122.481186169595) | 11 | 6 | 2 | 55 | 26 | ||
132601 | 39630 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1568 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 5x3 | Permit Number 53204 | 5997924.75387781 | 2105264.0077583 | 37.7605343603066 | -122.450280891235 | (37.7605343603066, -122.450280891235) | 15 | 5 | 11 | 29492 | 12 | ||
132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
133250 | 76766 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
134325 | 60027 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 41 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/2013 12:00:00 AM | Permit Number 769856 | 6014655.81368733 | 2112837.99803451 | 37.7822741509003 | -122.392945269869 | (37.7822741509003, -122.392945269869) | 6 | 2 | 9 | 28856 | 6 | ||
135717 | 112521 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
137875 | 13025 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | 3 | 1 | 10 | 308 | 23 | ||
137970 | 121488 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 750 Parnassus Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5994725.72352 | 2106063.15709 | 37.7625450220518 | -122.461402729778 | (37.7625450220518, -122.461402729778) | 15 | 5 | 11 | 56 | 12 | ||||
138508 | 13083 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | 3 | 1 | 10 | 308 | 23 | ||
141100 | 55048 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3791 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | Permit Number 768924 | 6003127.14535424 | 2103564.68904381 | 37.7561647909862 | -122.432166852953 | (37.7561647909862, -122.432166852953) | 2 | 4 | 5 | 28862 | 22 | |||
142116 | 99931 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.7562064244422 | -122.432259777723 | (37.7562064244422, -122.432259777723) | 2 | 4 | 5 | 28862 | 22 |
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) );