trees
1,914 rows where qSpecies_id = 45
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1603 | 182661 | DPW Maintained 1 | :: 45 | 2500 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986241.1388 | 2102339.3676 | 37.7518285352163 | -122.490473451437 | (37.7518285352163, -122.490473451437) | 1 | 8 | 3 | 56 | 35 | |||
1755 | 181883 | DPW Maintained 1 | :: 45 | 2362 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986739.9723 | 2099172.336 | 37.7431618411675 | -122.48851569655 | (37.7431618411675, -122.48851569655) | 1 | 8 | 3 | 29491 | 35 | |||
1764 | 184684 | DPW Maintained 1 | :: 45 | 3341 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983838.0977 | 2104243.1006 | 37.7569150061 | -122.498924003867 | (37.7569150061, -122.498924003867) | 1 | 8 | 3 | 56 | 35 | |||
1846 | 182526 | DPW Maintained 1 | :: 45 | 1578 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985626.9415 | 2104489.6047 | 37.7576966023025 | -122.492755756192 | (37.7576966023025, -122.492755756192) | 1 | 8 | 3 | 56 | 35 | |||
1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
1914 | 116946 | Undocumented 4 | :: 45 | 3676 23RD ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
1996 | 183451 | DPW Maintained 1 | :: 45 | 2515 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988280.1843 | 2098179.6898 | 37.7405260477437 | -122.483117374817 | (37.7405260477437, -122.483117374817) | 1 | 8 | 3 | 29491 | 35 | |||
2002 | 182728 | DPW Maintained 1 | :: 45 | 1726 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985974.3316 | 2103468.8168 | 37.7549141067074 | -122.491479220658 | (37.7549141067074, -122.491479220658) | 1 | 8 | 3 | 56 | 35 | |||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
2112 | 183619 | DPW Maintained 1 | :: 45 | 1415 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983065.6286 | 2105470.5181 | 37.7602398080473 | -122.501686253156 | (37.7602398080473, -122.501686253156) | 1 | 8 | 3 | 56 | 35 | |||
2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
2292 | 182145 | DPW Maintained 1 | :: 45 | 1452 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989717.6723 | 2103818.6604 | 37.7560927247983 | -122.478559421541 | (37.7560927247983, -122.478559421541) | 1 | 8 | 3 | 56 | 35 | |||
2338 | 260969 | Permitted Site 7 | :: 45 | 897 37th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11/05/2019 12:00:00 AM | 3 | 10X27 | 5984476.51719 | 2109749.52706 | 37.7720715265353 | -122.497122586729 | (37.7720715265353, -122.497122586729) | 11 | 6 | 2 | 55 | 26 | ||
2448 | 181960 | DPW Maintained 1 | :: 45 | 2455 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985784.4384 | 2098510.2137 | 37.7412880286271 | -122.491770899478 | (37.7412880286271, -122.491770899478) | 1 | 8 | 3 | 29491 | 35 | |||
2459 | 181830 | DPW Maintained 1 | :: 45 | 2319 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987925.2947 | 2099497.0517 | 37.7441225177456 | -122.484441029001 | (37.7441225177456, -122.484441029001) | 1 | 8 | 3 | 29491 | 35 | |||
2464 | 190663 | DPW Maintained 1 | :: 45 | 1360 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6016747.40621 | 2097393.16894 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | 10 | 3 | 8 | 58 | 1 | |||
2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
2737 | 258983 | Permitted Site 7 | :: 45 | 1355 27th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 5.5x17 | Permit Number 782298 | 5987701.73439 | 2106071.48854 | 37.7621611287816 | -122.48569645736 | (37.7621611287816, -122.48569645736) | 1 | 8 | 3 | 56 | 35 | |
2779 | 117319 | Permitted Site 7 | :: 45 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | |||||
2785 | 261137 | DPW Maintained 1 | :: 45 | 2454 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981796.50413 | 2098381.86438 | 37.7407017304597 | -122.505550019662 | (37.7407017304597, -122.505550019662) | 1 | 8 | 3 | 29491 | 35 | |||||
2802 | 181592 | DPW Maintained 1 | :: 45 | 1659 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984670.7327 | 2103886.5941 | 37.7559849420617 | -122.496018183642 | (37.7559849420617, -122.496018183642) | 1 | 8 | 3 | 56 | 35 | |||
2909 | 182639 | DPW Maintained 1 | :: 45 | 1850 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985068.7348 | 2102608.8093 | 37.752499800535 | -122.494547587265 | (37.752499800535, -122.494547587265) | 1 | 8 | 3 | 56 | 35 | |||
2959 | 141420 | DPW Maintained 1 | :: 45 | 550 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004578.5445 | 2111046.5078 | 37.7767902513835 | -122.427680466931 | (37.7767902513835, -122.427680466931) | 7 | 9 | 11 | 28852 | 10 | |||
3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
3262 | 143122 | DPW Maintained 1 | :: 45 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | 13 | 9 | 1 | 57 | 17 | |||
3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
3549 | 141425 | DPW Maintained 1 | :: 45 | 301 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005907.6073 | 2110863.9151 | 37.7763639855674 | -122.423069853164 | (37.7763639855674, -122.423069853164) | 7 | 9 | 11 | 28852 | 10 | |||
3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
3862 | 260676 | DPW Maintained 1 | :: 45 | 108 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2019 12:00:00 AM | 3 | 3x3 | 5992434.1895 | 2114741.52104 | 37.7862413120358 | -122.469960148163 | (37.7862413120358, -122.469960148163) | 11 | 6 | 2 | 54 | 11 | ||
4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
4746 | 67428 | DPW Maintained 1 | :: 45 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.7749321810162 | -122.475173477199 | (37.7749321810162, -122.475173477199) | 11 | 6 | 2 | 54 | 26 | |
4838 | 142080 | DPW Maintained 1 | :: 45 | 560 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000142.3776 | 2110889.4402 | 37.7761070510385 | -122.44301516716 | (37.7761070510385, -122.44301516716) | 15 | 5 | 11 | 29492 | 16 | |||
4931 | 185584 | DPW Maintained 1 | :: 45 | 2066 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986983.4623 | 2101205.4528 | 37.7487584406856 | -122.487823126868 | (37.7487584406856, -122.487823126868) | 1 | 8 | 3 | 29491 | 35 | |||
4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
5154 | 182781 | DPW Maintained 1 | :: 45 | 1742 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985353.0616 | 2103349.1064 | 37.7545490898351 | -122.493618895477 | (37.7545490898351, -122.493618895477) | 1 | 8 | 3 | 56 | 35 | |||
5156 | 182427 | DPW Maintained 1 | :: 45 | 1526 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985304.2975 | 2104805.6353 | 37.7585454628823 | -122.493894864934 | (37.7585454628823, -122.493894864934) | 1 | 8 | 3 | 56 | 35 | |||
5302 | 36500 | Permitted Site 7 | :: 45 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.7418397151309 | -122.41513812883 | (37.7418397151309, -122.41513812883) | 2 | 7 | 7 | 28859 | 2 | ||
5360 | 181929 | DPW Maintained 1 | :: 45 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | 1 | 8 | 3 | 29491 | 35 | |||
5583 | 244247 | Undocumented 4 | :: 45 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005673.0642 | 2110022.689 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | 7 | 9 | 11 | 28852 | 10 | |||
5762 | 182417 | DPW Maintained 1 | :: 45 | 1544 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984999.4264 | 2104687.6498 | 37.758203665255 | -122.494940531373 | (37.758203665255, -122.494940531373) | 1 | 8 | 3 | 56 | 35 | |||
5914 | 254656 | Private 9 | :: 45 | 640 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004524 | 2112776 | 37.781535924842 | -122.427992425483 | (37.781535924842, -122.427992425483) | 7 | 9 | 11 | 29490 | 41 | ||||
5962 | 190650 | DPW Maintained 1 | :: 45 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.7609327945277 | -122.399177878376 | (37.7609327945277, -122.399177878376) | 10 | 3 | 8 | 28856 | 29 | |||
5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
6014 | 38201 | Permitted Site 7 | :: 45 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.7234368466837 | -122.405053190481 | (37.7234368466837, -122.405053190481) | 10 | 3 | 7 | 309 | 28 | ||
6291 | 182272 | DPW Maintained 1 | :: 45 | 1494 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985296.227 | 2105059.6558 | 37.7592424604916 | -122.493941496366 | (37.7592424604916, -122.493941496366) | 1 | 8 | 3 | 56 | 35 | |||
6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
6450 | 184722 | DPW Maintained 1 | :: 45 | 1643 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984666.6891 | 2104002.5093 | 37.7563029761962 | -122.496040718779 | (37.7563029761962, -122.496040718779) | 1 | 8 | 3 | 56 | 35 | |||
6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
6678 | 183829 | DPW Maintained 1 | :: 45 | 2214 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987634.5167 | 2100198.0441 | 37.7460303199634 | -122.485497894293 | (37.7460303199634, -122.485497894293) | 1 | 8 | 3 | 29491 | 35 | |||
6870 | 182679 | DPW Maintained 1 | :: 45 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.491113101083 | (37.7553883964845, -122.491113101083) | 1 | 8 | 3 | 56 | 35 | |||
6909 | 184218 | DPW Maintained 1 | :: 45 | 3441 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984096.8823 | 2104933.319 | 37.758825328706 | -122.49808001485 | (37.758825328706, -122.49808001485) | 1 | 8 | 3 | 56 | 35 | |||
7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
7142 | 183990 | DPW Maintained 1 | :: 45 | 1678 35th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985337.0123 | 2103802.0601 | 37.7557918369667 | -122.493707772777 | (37.7557918369667, -122.493707772777) | 1 | 8 | 3 | 56 | 35 | |||
7154 | 184667 | DPW Maintained 1 | :: 45 | 1675 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984673.0914 | 2103809.4296 | 37.7557732078979 | -122.496004334161 | (37.7557732078979, -122.496004334161) | 1 | 8 | 3 | 56 | 35 | |||
7167 | 120669 | Undocumented 4 | :: 45 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974 | 2096001 | 37.7352743855737 | -122.439071080789 | (37.7352743855737, -122.439071080789) | 2 | 7 | 5 | 63 | 7 | ||
7226 | 139441 | DPW Maintained 1 | :: 45 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | 7 | 9 | 11 | 28852 | 10 | |||
7264 | 182773 | DPW Maintained 1 | :: 45 | 1 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985975.4571 | 2103368.6441 | 37.754639125693 | -122.491467955558 | (37.754639125693, -122.491467955558) | 1 | 8 | 3 | 56 | 35 | |||
7270 | 115892 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
7483 | 116947 | Undocumented 4 | :: 45 | 3676 23RD ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
7500 | 253261 | DPW Maintained 1 | :: 45 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2019 12:00:00 AM | 3 | 3x3 | 5990256 | 2113097 | 37.7815997636542 | -122.477375802178 | (37.7815997636542, -122.477375802178) | 11 | 6 | 2 | 55 | 26 | ||
7525 | 183813 | DPW Maintained 1 | :: 45 | 2101 Rivera St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986596.0486 | 2100254.1602 | 37.7461238416302 | -122.489092856091 | (37.7461238416302, -122.489092856091) | 1 | 8 | 3 | 29491 | 35 | |||
7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
7704 | 140222 | DPW Maintained 1 | :: 45 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003683.3616 | 2110416.1551 | 37.7750087812949 | -122.430732178175 | (37.7750087812949, -122.430732178175) | 7 | 9 | 11 | 29492 | 10 | |||
7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
7740 | 142745 | DPW Maintained 1 | :: 45 | 700x COLUMBUS AVE | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | 3 | 1 | 10 | 308 | 4 | |||
7759 | 181568 | DPW Maintained 1 | :: 45 | 1349 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984597.8609 | 2105995.9427 | 37.7617723563961 | -122.496425834494 | (37.7617723563961, -122.496425834494) | 1 | 8 | 3 | 56 | 35 | |||
7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
7819 | 184095 | DPW Maintained 1 | :: 45 | 1611 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985901.3945 | 2104240.0581 | 37.757027460882 | -122.491788227731 | (37.757027460882, -122.491788227731) | 1 | 8 | 3 | 56 | 35 | |||
7832 | 183984 | DPW Maintained 1 | :: 45 | 2420 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986737.6029 | 2103717.4696 | 37.755641413652 | -122.488857926532 | (37.755641413652, -122.488857926532) | 1 | 8 | 3 | 56 | 35 | |||
7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
7884 | 182867 | DPW Maintained 1 | :: 45 | 1841 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987504.2554 | 2102741.89 | 37.7530074484719 | -122.486135022058 | (37.7530074484719, -122.486135022058) | 1 | 8 | 3 | 56 | 35 | |||
8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
8130 | 261244 | Permitted Site 7 | :: 45 | 1166 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 3 | 3x3 | 6009198.71093 | 2102367.64119 | 37.75322033811 | -122.41108468628 | (37.75322033811, -122.41108468628) | 2 | 4 | 7 | 28859 | 19 | ||
8301 | 114726 | Significant Tree 6 | :: 45 | 520 Townsend St | 2 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
8481 | 70091 | DPW Maintained 1 | :: 45 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | 11 | 6 | 2 | 55 | 26 | ||
8635 | 182608 | DPW Maintained 1 | :: 45 | 1839 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985333.4224 | 2102688.337 | 37.7527336497539 | -122.493638125681 | (37.7527336497539, -122.493638125681) | 1 | 8 | 3 | 56 | 35 | |||
8663 | 258698 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
8688 | 183776 | DPW Maintained 1 | :: 45 | 2042 Santiago St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986449.4639 | 2099625.7878 | 37.7443899427786 | -122.489553521138 | (37.7443899427786, -122.489553521138) | 1 | 8 | 3 | 29491 | 35 | |||
8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
8891 | 182186 | DPW Maintained 1 | :: 45 | 1638 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988430.2421 | 2104156.5357 | 37.75694560898 | -122.483036497181 | (37.75694560898, -122.483036497181) | 1 | 8 | 3 | 56 | 35 | |||
8915 | 253260 | DPW Maintained 1 | :: 45 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993234 | 2110465 | 37.7745453462497 | -122.466882031228 | (37.7745453462497, -122.466882031228) | 11 | 6 | 2 | 54 | 11 | ||||
8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
8983 | 258699 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
9196 | 182652 | DPW Maintained 1 | :: 45 | 1871 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987819.8145 | 2102562.9873 | 37.7525346157683 | -122.485030647048 | (37.7525346157683, -122.485030647048) | 1 | 8 | 3 | 56 | 35 | |||
9359 | 114615 | Undocumented 4 | :: 45 | 2400X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
9389 | 66602 | DPW Maintained 1 | :: 45 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.01912 | 37.7901127525459 | -122.416141207354 | (37.7901127525459, -122.416141207354) | 13 | 1 | 10 | 28858 | 21 | |
9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );