trees
979 rows where qSpecies_id = 13 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
6589 | 44716 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/2020 12:00:00 AM | 3 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.478600649693 | (37.7527256083507, -122.478600649693) | 1 | 8 | 3 | 56 | 35 | |
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
8586 | 50836 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
11428 | 122390 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x2 | 5991007 | 2102078 | 37.7513881006776 | -122.473973545995 | (37.7513881006776, -122.473973545995) | 1 | 8 | 4 | 29491 | 12 | |||
12150 | 31352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2020 11:52:00 AM | 3 | Permit Number 34962 | 5992611.19724 | 2099415.50216 | 37.7441703551938 | -122.468232424195 | (37.7441703551938, -122.468232424195) | 1 | 8 | 4 | 29491 | 40 | |
12397 | 264812 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2270 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 3x3 | 5989815 | 2099915 | 37.745379953303 | -122.477937465434 | (37.745379953303, -122.477937465434) | 1 | 8 | 3 | 29491 | 35 | ||
18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
22578 | 108523 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773674 | 5990561.39992 | 2104128.43771 | 37.7569922406164 | -122.475664177859 | (37.7569922406164, -122.475664177859) | 1 | 8 | 4 | 56 | 12 |
27335 | 50837 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
32475 | 255482 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1559 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | 3x5 | 5993958 | 2104895 | 37.7592933500003 | -122.463973185629 | (37.7592933500003, -122.463973185629) | 1 | 8 | 4 | 56 | 12 | ||
32930 | 83189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992811.58181355 | 2104100.90541778 | 37.7570468381941 | -122.467880263564 | (37.7570468381941, -122.467880263564) | 1 | 8 | 4 | 56 | 12 | ||
33124 | 218387 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 50 San Marcos Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5993857.52408 | 2100226.90247 | 37.7464701590844 | -122.463981819901 | (37.7464701590844, -122.463981819901) | 1 | 8 | 4 | 29491 | 40 | |||
35612 | 255646 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1542 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | 3x5 | Permit Number 779777 | 5989956.05847 | 2104865.26605 | 37.7589802621415 | -122.477811515827 | (37.7589802621415, -122.477811515827) | 1 | 8 | 3 | 56 | 35 | |
38675 | 109898 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1786 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775112 | 5987249.9 | 2103123.1 | 37.7540393206485 | -122.487042615101 | (37.7540393206485, -122.487042615101) | 1 | 8 | 3 | 56 | 35 |
42827 | 253341 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1935 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 769984 | 5981944.68101 | 2101921.14451 | 37.7504283278742 | -122.505299944249 | (37.7504283278742, -122.505299944249) | 1 | 8 | 3 | 29491 | 35 | |
47632 | 208834 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1669 18th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990551.61783 | 2104055.61326 | 37.7567917168824 | -122.475692689987 | (37.7567917168824, -122.475692689987) | 1 | 8 | 4 | 56 | 12 | |||
57445 | 94819 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.7592951275131 | -122.467193784759 | (37.7592951275131, -122.467193784759) | 1 | 8 | 4 | 56 | 12 | |
64385 | 109276 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1558 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773739 | 5982234.4 | 2104492.8 | 37.7575064130321 | -122.504488595501 | (37.7575064130321, -122.504488595501) | 1 | 8 | 3 | 56 | 35 |
67384 | 112573 | Section 143 10 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 56 ROCKWOOD CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685 | 2098946 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | 1 | 8 | 4 | 59 | 40 | ||
70704 | 208841 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2134 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993696.59277 | 2101147.80807 | 37.7489894559968 | -122.46460515623 | (37.7489894559968, -122.46460515623) | 1 | 8 | 4 | 29491 | 40 | |||
73635 | 98412 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
76660 | 98411 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 3 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
80624 | 98410 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
86762 | 208850 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994846.41703 | 2099381.92654 | 37.7442070079607 | -122.46050114503 | (37.7442070079607, -122.46050114503) | 1 | 8 | 4 | 59 | 40 | |||
95009 | 173748 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1259 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773489 | 5989520 | 2106786 | 37.7642287625639 | -122.479460118399 | (37.7642287625639, -122.479460118399) | 1 | 8 | 3 | 56 | 35 | |
96765 | 208842 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993717.6087 | 2099811.01881 | 37.7453201833801 | -122.46443543704 | (37.7453201833801, -122.46443543704) | 1 | 8 | 4 | 29491 | 40 | |||
97176 | 106368 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 426 Country Club Dr | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 770073 | 5984817.1 | 2094918.3 | 37.731369010287 | -122.494850794258 | (37.731369010287, -122.494850794258) | 1 | 8 | 4 | 64 | 35 | ||||
99358 | 83188 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1664 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53557 | 5992810.26262937 | 2104140.01708709 | 37.7571541524742 | -122.467887670443 | (37.7571541524742, -122.467887670443) | 1 | 8 | 4 | 56 | 12 | ||
101820 | 69097 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1652 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992497.75001654 | 2104207.48539143 | 37.7573213517081 | -122.468973359701 | (37.7573213517081, -122.468973359701) | 1 | 8 | 4 | 56 | 12 | |
102182 | 253344 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2586 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780063 | 5987098.36417 | 2097677.28593 | 37.7390777358027 | -122.487166705945 | (37.7390777358027, -122.487166705945) | 1 | 8 | 3 | 29491 | 35 | |
102332 | 208836 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1677 18th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990563.73281 | 2104000.71919 | 37.7566416946684 | -122.475646784065 | (37.7566416946684, -122.475646784065) | 1 | 8 | 4 | 56 | 12 | |||
107998 | 108994 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1819 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773341 | 5993399.9 | 2103085.8 | 37.7542935760975 | -122.465771900659 | (37.7542935760975, -122.465771900659) | 1 | 8 | 4 | 56 | 12 |
114639 | 218385 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 50 San Marcos Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993842.10795 | 2100214.10934 | 37.7464341439306 | -122.46403419822 | (37.7464341439306, -122.46403419822) | 1 | 8 | 4 | 29491 | 40 | |||
121503 | 108525 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773676 | 5990565.37747 | 2104011.47717 | 37.7566713285758 | -122.475641881825 | (37.7566713285758, -122.475641881825) | 1 | 8 | 4 | 56 | 12 |
125740 | 109037 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1306 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772801 | 5987138.4 | 2106347.4 | 37.7628858653346 | -122.487665061189 | (37.7628858653346, -122.487665061189) | 1 | 8 | 3 | 56 | 35 |
129178 | 208837 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990984.78596 | 2102065.3313 | 37.7513520289909 | -122.474049439736 | (37.7513520289909, -122.474049439736) | 1 | 8 | 4 | 29491 | 12 | |||
139250 | 208851 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994827.47674 | 2099365.31036 | 37.7441602944536 | -122.460565432153 | (37.7441602944536, -122.460565432153) | 1 | 8 | 4 | 59 | 40 | |||
142885 | 87269 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4109 Irving St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2008 12:00:00 AM | 3x3 | Permit Number 50292 | 5983031 | 2106268 | 37.7624274331393 | -122.50186502168 | (37.7624274331393, -122.50186502168) | 1 | 8 | 3 | 56 | 35 | |||
144718 | 112574 | Section 143 10 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 56 ROCKWOOD CT | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685 | 2098946 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | 1 | 8 | 4 | 59 | 40 | ||
147161 | 208833 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990561.21502 | 2104064.77483 | 37.7568174285108 | -122.475660168683 | (37.7568174285108, -122.475660168683) | 1 | 8 | 4 | 56 | 12 | |||
155325 | 208838 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1450 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991176.37038 | 2105519.18149 | 37.7608464875004 | -122.473638846178 | (37.7608464875004, -122.473638846178) | 1 | 8 | 4 | 56 | 12 | |||
157008 | 215064 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1446 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993686.72935 | 2105638.95065 | 37.7613204077437 | -122.464965394043 | (37.7613204077437, -122.464965394043) | 1 | 8 | 11 | 56 | 12 | |||
158850 | 94144 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992831.3 | 2104104.9 | 37.7570589448864 | -122.467812361688 | (37.7570589448864, -122.467812361688) | 1 | 8 | 4 | 56 | 12 | ||
160765 | 108524 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1669 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773675 | 5990564.49357 | 2104037.4684 | 37.7567426423615 | -122.475646836483 | (37.7567426423615, -122.475646836483) | 1 | 8 | 4 | 56 | 12 |
161402 | 217796 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991264.94517 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | 1 | 8 | 4 | 64 | 40 | |||
163303 | 208849 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Santa Rita Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5993729.602 | 2100694.18749 | 37.7477458321253 | -122.464458079273 | (37.7477458321253, -122.464458079273) | 1 | 8 | 4 | 29491 | 40 | |||
170390 | 203239 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 115 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995169.40317 | 2099688.3978 | 37.7450670773024 | -122.459406527086 | (37.7450670773024, -122.459406527086) | 1 | 8 | 4 | 59 | 40 | |
180821 | 208839 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | 1 | 8 | 4 | 59 | 40 | |||
186900 | 208835 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990563.36006 | 2104017.9082 | 37.7566888695243 | -122.475649328274 | (37.7566888695243, -122.475649328274) | 1 | 8 | 4 | 56 | 12 | |||
187522 | 109253 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.506124767382 | (37.7612466017789, -122.506124767382) | 1 | 8 | 3 | 56 | 35 |
194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
9101 | 149740 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5x5 | 6010932.22924 | 2105459.16725 | 37.7618060416252 | -122.405307491047 | (37.7618060416252, -122.405307491047) | 10 | 3 | 8 | 28856 | 29 | |||
9116 | 229637 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009018.53484 | 2097336.36234 | 37.7393954533353 | -122.411352367829 | (37.7393954533353, -122.411352367829) | 10 | 7 | 7 | 28859 | 2 | |||
9598 | 99292 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
10033 | 80634 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6013018.0309 | 2104352.7115 | 37.7588843520526 | -122.398015861652 | (37.7588843520526, -122.398015861652) | 10 | 3 | 8 | 28856 | 29 | |||
11103 | 149739 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6010931.02944 | 2105481.85704 | 37.7618682756098 | -122.405313238612 | (37.7618682756098, -122.405313238612) | 10 | 3 | 8 | 28856 | 29 | |||
12009 | 162257 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011373.11147 | 2091245.9028 | 37.7228041046152 | -122.402783015826 | (37.7228041046152, -122.402783015826) | 10 | 3 | 7 | 309 | 28 | |||
12319 | 149738 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6010928.54307 | 2105503.65431 | 37.7619279870025 | -122.405323373095 | (37.7619279870025, -122.405323373095) | 10 | 3 | 8 | 28856 | 29 | |||
12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
13984 | 115980 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.7227881560287 | -122.402019710862 | (37.7227881560287, -122.402019710862) | 10 | 3 | 7 | 309 | 28 | |||
15129 | 102443 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | 10 | 3 | 8 | 28856 | 29 | ||
16524 | 84225 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | 10 | 7 | 8 | 309 | 39 | ||
18550 | 116935 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.35588 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | 10 | 3 | 8 | 28856 | 29 | ||
20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
21174 | 177436 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.407172691281 | (37.7232785896114, -122.407172691281) | 10 | 3 | 7 | 309 | 28 | |||
22156 | 150165 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014460.64342 | 2105255.76526 | 37.7614441832169 | -122.39308978288 | (37.7614441832169, -122.39308978288) | 10 | 3 | 8 | 28856 | 29 | ||
24379 | 84492 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857 | -122.392490121246 | (37.733048399857, -122.392490121246) | 10 | 3 | 8 | 58 | 1 | |
25069 | 193337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015308.47907 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | 10 | 3 | 8 | 28856 | 29 | |||
26858 | 193333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | 10 | 3 | 8 | 28856 | 29 | |||
26931 | 37803 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | 10 | 3 | 7 | 309 | 28 | ||
30093 | 98453 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.45619 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | 10 | 3 | 8 | 28856 | 29 | |
30764 | 97025 | Property Tree 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
32359 | 193327 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015585.42977 | 2102602.25227 | 37.7542206208044 | -122.389014307158 | (37.7542206208044, -122.389014307158) | 10 | 3 | 8 | 28856 | 29 | |||
32889 | 193331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015302.57075 | 2102682.83592 | 37.754426203129 | -122.38999814121 | (37.754426203129, -122.38999814121) | 10 | 3 | 8 | 28856 | 29 | |||
33479 | 116924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.7541011242826 | -122.389159972153 | (37.7541011242826, -122.389159972153) | 10 | 3 | 8 | 28856 | 29 | ||
34828 | 116927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.389326559889 | (37.7540938262957, -122.389326559889) | 10 | 3 | 8 | 28856 | 29 | ||
39488 | 177445 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.7235998004623 | -122.405800920297 | (37.7235998004623, -122.405800920297) | 10 | 3 | 7 | 309 | 28 | |||
39534 | 8225 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
40320 | 177441 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010258.66598 | 2091491.87018 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | 10 | 3 | 7 | 309 | 28 | |||
41563 | 108933 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773146 | 6008530.3 | 2096373.5 | 37.7367242478568 | -122.41297241357 | (37.7367242478568, -122.41297241357) | 10 | 7 | 7 | 28859 | 2 |
41578 | 193336 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015307.25652 | 2102573.04925 | 37.7541250120819 | -122.389974267815 | (37.7541250120819, -122.389974267815) | 10 | 3 | 8 | 28856 | 29 | |||
45035 | 88479 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | 10 | 3 | 8 | 58 | 1 | ||
45858 | 88076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 674 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51071 | 6011923.03733 | 2094336.64392 | 37.7313213328046 | -122.401099095547 | (37.7313213328046, -122.401099095547) | 10 | 3 | 8 | 58 | 1 | |
47704 | 108089 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010157.47788 | 2105483.07585 | 37.7618283430246 | -122.407988746007 | (37.7618283430246, -122.407988746007) | 10 | 4 | 8 | 28859 | 19 | ||
48719 | 116933 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015369.14789 | 2102590.92817 | 37.7541775360745 | -122.389761479208 | (37.7541775360745, -122.389761479208) | 10 | 3 | 8 | 28856 | 29 | ||
49171 | 94884 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) | 10 | 3 | 8 | 58 | 1 |
50336 | 94885 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.08413 | 37.736769849332 | -122.397340238786 | (37.736769849332, -122.397340238786) | 10 | 3 | 8 | 58 | 1 |
51580 | 109211 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.72328 | 2090968.52831 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | 10 | 3 | 7 | 309 | 28 | |
52659 | 6741 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.88159 | 37.7396174392826 | -122.384012840031 | (37.7396174392826, -122.384012840031) | 10 | 3 | 8 | 58 | 1 | ||
53411 | 114722 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 |
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) );