trees
253 rows where Police Districts = 8 and qSpecies_id = 6 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2908 | 93406 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2015 11:15:00 AM | 3 | 3x3 | 5988828.0589 | 2099030.2661 | 37.7428933746541 | -122.48128533094 | (37.7428933746541, -122.48128533094) | 1 | 8 | 3 | 29491 | 35 | ||
| 9692 | 183446 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | 1 | 8 | 3 | 29491 | 35 | ||
| 10037 | 183693 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | 1 | 8 | 3 | 56 | 35 | ||
| 10383 | 264872 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 06:03:00 PM | 3 | 4x6 | 5985846 | 2098694 | 37.7417962544182 | -122.491571569344 | (37.7417962544182, -122.491571569344) | 1 | 8 | 3 | 29491 | 35 | |
| 12204 | 164659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785596 | 5994533.58351 | 2098539.8464 | 37.7418768645301 | -122.461521809887 | (37.7418768645301, -122.461521809887) | 1 | 8 | 4 | 59 | 40 | |
| 12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
| 13074 | 264871 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2430 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2020 12:00:00 AM | 3 | 4x6 | 5985228 | 2098648 | 37.7416338152793 | -122.493704989969 | (37.7416338152793, -122.493704989969) | 1 | 8 | 3 | 29491 | 35 | ||
| 13541 | 60816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2110 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 4 | Permit Number 20494 | 5989779.2235 | 2100978.3623 | 37.7482975910503 | -122.478138904702 | (37.7482975910503, -122.478138904702) | 1 | 8 | 3 | 29491 | 35 | |
| 13622 | 207003 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992355.41935 | 2099194.17897 | 37.7435478822362 | -122.469100735806 | (37.7435478822362, -122.469100735806) | 1 | 8 | 4 | 29491 | 40 | |||
| 16581 | 258150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2485 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5989205.22412 | 2098441.55094 | 37.7412988370865 | -122.479938140892 | (37.7412988370865, -122.479938140892) | 1 | 8 | 3 | 29491 | 35 | |||
| 19297 | 58021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971657 | (37.7625717348083, -122.50121971657) | 1 | 8 | 3 | 56 | 35 | ||
| 19468 | 95897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.480765700813 | (37.7555618218669, -122.480765700813) | 1 | 8 | 3 | 56 | 35 |
| 19993 | 182699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.7558399109499 | -122.480728726959 | (37.7558399109499, -122.480728726959) | 1 | 8 | 3 | 56 | 35 | |||
| 20055 | 206989 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | 1 | 8 | 11 | 56 | 12 | |||
| 23262 | 51411 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.480966595693 | (37.7581930050331, -122.480966595693) | 1 | 8 | 3 | 56 | 35 | |
| 25168 | 83917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50173 | 5981576.71105327 | 2104986.37444115 | 37.7588229209977 | -122.506799717054 | (37.7588229209977, -122.506799717054) | 1 | 8 | 3 | 56 | 35 | |
| 25751 | 182700 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.480679561224 | (37.7558407372502, -122.480679561224) | 1 | 8 | 3 | 56 | 35 | |||
| 27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 29174 | 183692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | 1 | 8 | 3 | 56 | 35 | ||
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 30373 | 184599 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | 1 | 8 | 3 | 56 | 35 | |||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 30582 | 183121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | 1 | 8 | 3 | 29491 | 35 | |||
| 32050 | 92441 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) | 1 | 8 | 3 | 56 | 35 |
| 32976 | 207036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990861.16949 | 2098351.90974 | 37.7411487751831 | -122.474205983836 | (37.7411487751831, -122.474205983836) | 1 | 8 | 4 | 29491 | 40 | |||
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 34355 | 80237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.493852234736 | (37.7558298048279, -122.493852234736) | 1 | 8 | 3 | 56 | 35 | |||
| 35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 36793 | 95431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) | 1 | 8 | 3 | 29491 | 35 |
| 37185 | 83309 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.7582079811023 | -122.503696933051 | (37.7582079811023, -122.503696933051) | 1 | 8 | 3 | 56 | 35 | |
| 37491 | 95899 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) | 1 | 8 | 3 | 56 | 35 |
| 39271 | 37722 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3001 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 04:53:00 PM | 3 | 3x3 | Permit Number 774917 | 5983850.6165 | 2098795.1757 | 37.7419572424052 | -122.498478312402 | (37.7419572424052, -122.498478312402) | 1 | 8 | 3 | 29491 | 35 | |
| 39349 | 98850 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 39727 | 182826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136929 | (37.7539396409234, -122.48943136929) | 1 | 8 | 3 | 56 | 35 | |||
| 40337 | 254524 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/10/2015 07:56:00 AM | 3 | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |
| 41606 | 207031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1528 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992776.06817 | 2105054.20165 | 37.7596622898883 | -122.468072424026 | (37.7596622898883, -122.468072424026) | 1 | 8 | 4 | 56 | 12 | |||
| 41781 | 207002 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992354.33739 | 2099175.8386 | 37.7434974617379 | -122.469103142406 | (37.7434974617379, -122.469103142406) | 1 | 8 | 4 | 29491 | 40 | |||
| 42322 | 24532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.507091481475 | (37.7607233666377, -122.507091481475) | 1 | 8 | 3 | 56 | 35 | ||
| 44272 | 92401 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.7643199783579 | -122.494515603708 | (37.7643199783579, -122.494515603708) | 1 | 8 | 3 | 56 | 35 |
| 44650 | 206994 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992653.289 | 2105901.13559 | 37.761980656709 | -122.468558674846 | (37.761980656709, -122.468558674846) | 1 | 8 | 4 | 56 | 12 | |||
| 44798 | 184494 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | 1 | 8 | 3 | 56 | 35 | |||
| 48643 | 98849 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 48766 | 207033 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.7491407714503 | -122.466516461993 | (37.7491407714503, -122.466516461993) | 1 | 8 | 4 | 29491 | 12 | |||
| 50062 | 254193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1265 Monterey Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781221 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 |
| 50194 | 183672 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | 1 | 8 | 3 | 56 | 35 | |||
| 50370 | 109275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) | 1 | 8 | 3 | 56 | 35 |
| 51774 | 184549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.500349218821 | (37.754982490057, -122.500349218821) | 1 | 8 | 3 | 56 | 35 | |||
| 52327 | 835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1396X 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:55:00 AM | 3 | 3X3 | 5981242.3727 | 2105595.8151 | 37.7604765764936 | -122.5080012238 | (37.7604765764936, -122.5080012238) | 1 | 8 | 3 | 56 | 35 | ||
| 52445 | 251444 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545 | 2088436 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | 9 | 8 | 6 | 28861 | 24 | ||
| 52571 | 182607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1867 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781588 | 5986269.2088 | 2102542.1488 | 37.7523869566931 | -122.49039129916 | (37.7523869566931, -122.49039129916) | 1 | 8 | 3 | 56 | 35 | |
| 52675 | 37717 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3001 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 04:45:00 PM | 3 | 3x3 | Permit Number 774917 | 5983817.4661 | 2098794.1609 | 37.7419525119456 | -122.498592859082 | (37.7419525119456, -122.498592859082) | 1 | 8 | 3 | 29491 | 35 | |
| 53815 | 207037 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2642 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990833.84583 | 2097410.6031 | 37.7385626055711 | -122.474231788985 | (37.7385626055711, -122.474231788985) | 1 | 8 | 4 | 29491 | 40 | |||
| 54340 | 840 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.4206842 | 2105445.3666043 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | 1 | 8 | 3 | 56 | 35 | ||
| 55470 | 11606 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.7604509471428 | -122.507135818078 | (37.7604509471428, -122.507135818078) | 1 | 8 | 3 | 56 | 35 | ||
| 56104 | 182307 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | 1 | 8 | 3 | 56 | 35 | |||
| 56885 | 207029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.470555641023 | (37.7160401362134, -122.470555641023) | 9 | 8 | 6 | 64 | 24 | |||
| 56938 | 206999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 404 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991570.38275 | 2099794.54343 | 37.7451509372588 | -122.471858917877 | (37.7451509372588, -122.471858917877) | 1 | 8 | 4 | 29491 | 40 | |||
| 58640 | 11589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.3567285 | 2105594.1635633 | 37.7605162040396 | -122.505407296146 | (37.7605162040396, -122.505407296146) | 1 | 8 | 3 | 56 | 35 | ||
| 59117 | 184544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3425 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781517 | 5983632.4928 | 2103556.7404 | 37.7550183908439 | -122.499584326949 | (37.7550183908439, -122.499584326949) | 1 | 8 | 3 | 56 | 35 | |
| 59213 | 115174 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | 1 | 8 | 3 | 56 | 35 | |||
| 59994 | 11598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.7604834464148 | -122.506543543521 | (37.7604834464148, -122.506543543521) | 1 | 8 | 3 | 56 | 35 | ||
| 60258 | 184208 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.7593533930501 | -122.49932723943 | (37.7593533930501, -122.49932723943) | 1 | 8 | 3 | 56 | 35 | |||
| 63550 | 93407 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2015 11:09:00 AM | 3 | 3x3 | 5988810.4689 | 2099030.2661 | 37.7428923519808 | -122.481346151554 | (37.7428923519808, -122.481346151554) | 1 | 8 | 3 | 29491 | 35 | ||
| 63727 | 207043 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752637 | (37.7274289275879, -122.46264752637) | 9 | 8 | 4 | 59 | 40 | |||
| 68252 | 106608 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 69798 | 207032 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1672 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992498.79373 | 2104084.7245 | 37.7569843426628 | -122.468960816591 | (37.7569843426628, -122.468960816591) | 1 | 8 | 4 | 56 | 12 | |||
| 70295 | 11573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | ||
| 71829 | 206984 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.91026 | 2105249.91359 | 37.7600898599821 | -122.474651424322 | (37.7600898599821, -122.474651424322) | 1 | 8 | 4 | 56 | 12 | |||
| 72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
| 72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
| 79084 | 207006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992316.05801 | 2097825.56846 | 37.7397877510963 | -122.469137249186 | (37.7397877510963, -122.469137249186) | 1 | 8 | 4 | 59 | 40 | |||
| 80153 | 183694 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | 1 | 8 | 3 | 56 | 35 | ||
| 80376 | 184160 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3538 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/28/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781479 | 5983222.1931 | 2104276.0104 | 37.7569692214498 | -122.50105643195 | (37.7569692214498, -122.50105643195) | 1 | 8 | 3 | 56 | 35 | |
| 80475 | 92440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1352 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52830 | 5982162.934 | 2105885.2573 | 37.7613255007309 | -122.504838927947 | (37.7613255007309, -122.504838927947) | 1 | 8 | 3 | 56 | 35 |
| 80907 | 98851 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
| 85415 | 207038 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994641.46146 | 2100307.89339 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | 1 | 8 | 4 | 29491 | 40 | |||
| 87952 | 207035 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.7491376139164 | -122.466645051533 | (37.7491376139164, -122.466645051533) | 1 | 8 | 4 | 29491 | 12 | |||
| 88773 | 216845 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.7141050056202 | -122.458764825742 | (37.7141050056202, -122.458764825742) | 9 | 8 | 6 | 28861 | 24 | ||
| 91141 | 37721 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3001 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 05:19:00 PM | 3 | 3x3 | Permit Number 774917 | 5983882.4138 | 2098796.867 | 37.7419637508928 | -122.498368494175 | (37.7419637508928, -122.498368494175) | 1 | 8 | 3 | 29491 | 35 | |
| 92387 | 184697 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | 1 | 8 | 3 | 56 | 35 | |||
| 92547 | 106331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:38:00 PM | 3 | 3x3 | 5988118.12003 | 2098953.52216 | 37.7426413556222 | -122.483734446336 | (37.7426413556222, -122.483734446336) | 1 | 8 | 3 | 29491 | 35 | ||
| 93431 | 11602 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | 1 | 8 | 3 | 56 | 35 | ||
| 93687 | 206996 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993365.5475 | 2104527.17443 | 37.7582492355186 | -122.465995428957 | (37.7582492355186, -122.465995428957) | 1 | 8 | 4 | 56 | 12 | |||
| 96117 | 184640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | 1 | 8 | 3 | 56 | 35 | |||
| 97071 | 183696 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.501762940556 | (37.7612468805065, -122.501762940556) | 1 | 8 | 3 | 56 | 35 | ||
| 98323 | 37723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3001 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 05:05:00 PM | 3 | 3x3 | Permit Number 774917 | 5983867.1917 | 2098797.5436 | 37.7419647160194 | -122.498421176446 | (37.7419647160194, -122.498421176446) | 1 | 8 | 3 | 29491 | 35 | |
| 98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 99461 | 216848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | 9 | 8 | 6 | 28861 | 24 | ||
| 102267 | 207020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.7224841734802 | -122.455061523672 | (37.7224841734802, -122.455061523672) | 9 | 8 | 4 | 28861 | 24 | |||
| 102966 | 206997 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531524 | (37.7640822509305, -122.46838531524) | 11 | 8 | 11 | 56 | 12 | |||
| 104950 | 183303 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | 1 | 8 | 3 | 56 | 35 | |||
| 106816 | 181949 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | 1 | 8 | 3 | 29491 | 35 | |||
| 109442 | 206995 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | 1 | 8 | 4 | 56 | 12 | |||
| 109495 | 184723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | 1 | 8 | 3 | 56 | 35 | |||
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 111974 | 206992 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 633 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992553.59441 | 2105897.35752 | 37.761964523762 | -122.468903201544 | (37.761964523762, -122.468903201544) | 1 | 8 | 4 | 56 | 12 | |||
| 112582 | 207022 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.7200365066592 | -122.452230901246 | (37.7200365066592, -122.452230901246) | 9 | 8 | 6 | 28861 | 24 | |||
| 112687 | 207000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 404 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991556.48203 | 2099793.0654 | 37.7451460746357 | -122.471906875997 | (37.7451460746357, -122.471906875997) | 1 | 8 | 4 | 29491 | 40 | |||
| 114221 | 95521 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.493907267319 | (37.7587753414156, -122.493907267319) | 1 | 8 | 3 | 56 | 35 |
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) );