trees
1,121 rows where qSpecies_id = 6 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
2939 | 262442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
15310 | 262443 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
15599 | 262439 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
131707 | 52954 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.11633 | 37.7224704120511 | -122.439451120374 | (37.7224704120511, -122.439451120374) | 9 | 7 | 6 | 28861 | 25 | |
16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
164870 | 87861 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | 2 | 4 | 5 | 28862 | 3 | ||
151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
94732 | 88465 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
133452 | 181027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.24811 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | 9 | 7 | 6 | 28861 | 5 | ||
14691 | 69919 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
53141 | 71841 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
127633 | 52071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.410515038747 | (37.7954949369081, -122.410515038747) | 3 | 1 | 10 | 28857 | 4 | ||
194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 | ||
74010 | 129386 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | 5 | 1 | 10 | 28857 | 21 | |||
47209 | 165132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995776.8676 | 2094560.79185 | 37.7310228361347 | -122.456935228771 | (37.7310228361347, -122.456935228771) | 9 | 7 | 4 | 28861 | 40 |
92269 | 165133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995820.38989 | 2094571.40487 | 37.731054476063 | -122.456785533051 | (37.731054476063, -122.456785533051) | 9 | 7 | 4 | 28861 | 40 |
664 | 262379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 925 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5998032 | 2106999 | 37.7653043483693 | -122.450035028723 | (37.7653043483693, -122.450035028723) | 15 | 5 | 11 | 29492 | 9 | |
15133 | 129382 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008704.56308 | 2112447.63135 | 37.7808699297471 | -122.413506401504 | (37.7808699297471, -122.413506401504) | 7 | 10 | 9 | 28852 | 36 | |||
20503 | 129384 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008749.2926 | 2112454.62361 | 37.7808916402666 | -122.413352154294 | (37.7808916402666, -122.413352154294) | 7 | 10 | 9 | 28852 | 36 | |||
107699 | 129383 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008721.10925 | 2112450.33412 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | 7 | 10 | 9 | 28852 | 36 | |||
109623 | 227566 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6000468.02748 | 2104951.63177 | 37.7598218728073 | -122.441462479323 | (37.7598218728073, -122.441462479323) | 2 | 4 | 5 | 28862 | 3 | |||
150091 | 129390 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.412262888224 | (37.798209676283, -122.412262888224) | 3 | 1 | 10 | 308 | 21 | |||
115205 | 191229 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 901 Newhall St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6015272.35005 | 2096832.51763 | 37.7383607716336 | -122.389694066038 | (37.7383607716336, -122.389694066038) | 10 | 3 | 8 | 58 | 1 | |||
121429 | 191228 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 901 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6015254.00871 | 2096807.91476 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | 10 | 3 | 8 | 58 | 1 | |||
100533 | 27048 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | 9 | 3 | 7 | 309 | 5 | ||
139170 | 27314 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 884 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3 | 3X3 | 6007123.27309 | 2093533.58449 | 37.7288473779044 | -122.417635904868 | (37.7288473779044, -122.417635904868) | 9 | 3 | 7 | 309 | 5 | ||
83077 | 119164 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | 11 | 6 | 2 | 55 | 26 | |||
13775 | 68397 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 88 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2020 12:00:00 AM | 3 | Permit Number 785230 | 6003105.95459 | 2094517.30646 | 37.7313215783119 | -122.43159424368 | (37.7313215783119, -122.43159424368) | 9 | 7 | 5 | 28861 | 25 | |
132775 | 180842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.451155786013 | (37.710473721248, -122.451155786013) | 9 | 7 | 6 | 28861 | 25 | ||
113649 | 117934 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982916.92515 | 2109877.96567 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | 11 | 6 | 2 | 55 | 26 | |||
192805 | 115237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.7723677654738 | -122.502584200594 | (37.7723677654738, -122.502584200594) | 11 | 6 | 2 | 55 | 26 | |||
63206 | 115239 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | 11 | 6 | 2 | 55 | 26 | |||
186887 | 119083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | 11 | 6 | 2 | 55 | 26 | |||
140514 | 95742 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.44311 | 2091416.58174 | 37.7229052675357 | -122.425411786848 | (37.7229052675357, -122.425411786848) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
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 | |||
120285 | 207025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.7201500460637 | -122.452156656813 | (37.7201500460637, -122.452156656813) | 9 | 8 | 6 | 28861 | 24 | |||
151234 | 207023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997061.02366 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | 9 | 8 | 6 | 28861 | 24 | |||
190265 | 227118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.7438987545141 | -122.422358119057 | (37.7438987545141, -122.422358119057) | 2 | 7 | 7 | 28859 | 2 | |||
168688 | 227572 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 841 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004362.06253 | 2104151.54801 | 37.7578461063327 | -122.427937906015 | (37.7578461063327, -122.427937906015) | 2 | 4 | 5 | 28862 | 3 | |||
101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
139435 | 43740 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
5680 | 227559 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6000741.27617 | 2104538.3206 | 37.7587025846742 | -122.44048780488 | (37.7587025846742, -122.44048780488) | 2 | 4 | 5 | 28862 | 38 | |||
71720 | 227560 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.7587502280493 | -122.440503723791 | (37.7587502280493, -122.440503723791) | 2 | 4 | 5 | 28862 | 38 | |||
144465 | 227561 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | 2 | 4 | 5 | 28862 | 38 | |||
61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
185300 | 207030 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.7160432712657 | -122.470505441771 | (37.7160432712657, -122.470505441771) | 9 | 8 | 6 | 64 | 24 | |||
43518 | 114818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 825 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2018 12:00:00 AM | 3 | Permit Number 774480 | 5986555.6 | 2110296.1 | 37.773693882861 | -122.489971179067 | (37.773693882861, -122.489971179067) | 11 | 6 | 2 | 55 | 26 | ||
69435 | 114895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | 11 | 6 | 2 | 55 | 26 | |||
45396 | 227112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | 2 | 7 | 7 | 28859 | 2 | |||
186958 | 120000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 818 30th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5986676.70436 | 2110336.54693 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | 11 | 6 | 2 | 55 | 26 | |||
6021 | 260882 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 810 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985734.50152 | 2110356.92333 | 37.7738129057539 | -122.492815926544 | (37.7738129057539, -122.492815926544) | 11 | 6 | 2 | 55 | 26 | |||
5588 | 227150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008185.20329 | 2095640.92661 | 37.7346933830922 | -122.414113755053 | (37.7346933830922, -122.414113755053) | 2 | 7 | 7 | 28859 | 2 | |||
2502 | 84554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | 11 | 6 | 2 | 55 | 26 | |||
146035 | 84332 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | 11 | 6 | 2 | 55 | 26 | ||
177211 | 102935 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 801X Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
84471 | 27064 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 801 Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 1 | 4 | 6007054.44286 | 2093598.36831 | 37.7290213868102 | -122.417878446659 | (37.7290213868102, -122.417878446659) | 9 | 3 | 7 | 309 | 28 | ||
29694 | 248531 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997658.268 | 2107761.8815 | 37.7673776340728 | -122.451382700243 | (37.7673776340728, -122.451382700243) | 15 | 5 | 11 | 29492 | 9 | |||
41094 | 51607 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) | 15 | 5 | 11 | 29492 | 9 |
31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
156893 | 27081 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
181974 | 227119 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001473.16561 | 2099668.76787 | 37.7453736076231 | -122.437607869022 | (37.7453736076231, -122.437607869022) | 2 | 7 | 5 | 63 | 22 | |||
192824 | 227120 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6001486.23397 | 2099669.55813 | 37.7453765205103 | -122.43756273743 | (37.7453765205103, -122.43756273743) | 2 | 7 | 5 | 63 | 22 | |||
23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
73269 | 92664 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
122415 | 92665 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
72338 | 227121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 791 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001433.87774 | 2099966.59062 | 37.7461891245209 | -122.437765046244 | (37.7461891245209, -122.437765046244) | 2 | 7 | 5 | 63 | 22 | |||
106660 | 27046 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 790 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6006496.08217 | 2093583.10222 | 37.7289480300179 | -122.419807663316 | (37.7289480300179, -122.419807663316) | 9 | 7 | 7 | 309 | 5 | ||
49974 | 73594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.7875805296608 | -122.414547298434 | (37.7875805296608, -122.414547298434) | 5 | 1 | 10 | 28858 | 21 | |
131191 | 71549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.414625660841 | (37.7875672592553, -122.414625660841) | 5 | 1 | 10 | 28858 | 21 |
158967 | 79726 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | 5 | 1 | 10 | 28858 | 21 | ||
154133 | 227547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001390.11593 | 2102052.79607 | 37.7519148588942 | -122.438065782205 | (37.7519148588942, -122.438065782205) | 2 | 4 | 5 | 28862 | 22 | |||
109581 | 27083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 773 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006444.73415 | 2093622.02758 | 37.7290520177348 | -122.419987938702 | (37.7290520177348, -122.419987938702) | 9 | 7 | 7 | 309 | 5 | ||
189609 | 227083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6008514.34527 | 2104071.33726 | 37.7578598992273 | -122.41357185686 | (37.7578598992273, -122.41357185686) | 2 | 4 | 7 | 28859 | 19 | |||
106563 | 95938 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.7747452702656 | -122.488574294001 | (37.7747452702656, -122.488574294001) | 11 | 6 | 2 | 55 | 26 |
172005 | 227579 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | 8 | 4 | 5 | 28862 | 3 | |||
48121 | 227587 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006751.41341 | 2109490.52204 | 37.7726405574578 | -122.420053398542 | (37.7726405574578, -122.420053398542) | 8 | 2 | 9 | 28853 | 19 | |||
29761 | 176907 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006492.03782 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | 9 | 7 | 7 | 309 | 5 | |||
137268 | 176906 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | 9 | 7 | 7 | 309 | 5 | |||
10151 | 146941 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 763 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5982269.93422 | 2110578.75305 | 37.7742187803997 | -122.504816658869 | (37.7742187803997, -122.504816658869) | 11 | 6 | 2 | 55 | 26 | ||
35644 | 117055 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.493860404631 | (37.7747038750392, -122.493860404631) | 11 | 6 | 2 | 55 | 26 | |||
139164 | 118188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.493943116599 | (37.7747152280145, -122.493943116599) | 11 | 6 | 2 | 55 | 26 | |||
155044 | 52456 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.7741102732547 | -122.469236887906 | (37.7741102732547, -122.469236887906) | 11 | 6 | 2 | 54 | 11 | |
29952 | 137671 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | 15 | 5 | 11 | 29490 | 16 |
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) );