trees
6,344 rows where qSpecies_id = 19 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
1118 | 36625 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
1398 | 20032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3ST | |||||||||||||
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3531 | 39973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3892 | 39976 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
4058 | 34900 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
4332 | 30435 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 88 | |||||||||||||
4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8292 | 261770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:05:00 AM | 3 | 4x4 | ||||||||||||
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10686 | 34901 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
11435 | 36622 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
11817 | 33081 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
11841 | 34905 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
12228 | 34902 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13886 | 34906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
14106 | 36623 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14123 | 36635 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15275 | 36627 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15484 | 36610 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15890 | 256718 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 927 Brazil Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782649 | |||||||||||
17350 | 34904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
18716 | 261769 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:00:00 AM | 3 | 4x4 | ||||||||||||
19128 | 36616 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
598 | 142905 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 577 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010143.121 | 2119878.0324 | 37.8013526887848 | -122.409054146394 | (37.8013526887848, -122.409054146394) | 3 | 1 | 10 | 308 | 23 | |||
3258 | 130902 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 810 Mason St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009606.05045 | 2116280.73796 | 37.7914452987052 | -122.410658473411 | (37.7914452987052, -122.410658473411) | 5 | 1 | 10 | 28857 | 21 | |||
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
4127 | 74230 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.7974876128867 | -122.405491940883 | (37.7974876128867, -122.405491940883) | 3 | 1 | 10 | 308 | 23 | ||
4219 | 71431 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | 3 | 1 | 10 | 308 | 23 | |||
5192 | 4661 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:46:00 PM | 3 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.410431363819 | (37.8005811155969, -122.410431363819) | 3 | 1 | 10 | 308 | 23 | ||
6126 | 142586 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2310 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008494.0857 | 2120777.934 | 37.803731078252 | -122.414824283354 | (37.803731078252, -122.414824283354) | 5 | 1 | 10 | 308 | 23 | |||
6719 | 72384 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010697.2489 | 2118956.7107 | 37.7988539907437 | -122.407071630807 | (37.7988539907437, -122.407071630807) | 3 | 1 | 10 | 308 | 23 | |||
7277 | 71773 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007676.74747 | 2115431.38608 | 37.7890048300542 | -122.417273630072 | (37.7890048300542, -122.417273630072) | 13 | 1 | 10 | 28858 | 21 | |||
7659 | 261346 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:42:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
7772 | 74841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6011912.74207 | 2119472.92585 | 37.800339337445 | -122.402901928701 | (37.800339337445, -122.402901928701) | 3 | 1 | 10 | 308 | 23 | |||
8021 | 130909 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008550.55684 | 2117302.71746 | 37.7941921699808 | -122.414382817833 | (37.7941921699808, -122.414382817833) | 5 | 1 | 10 | 28857 | 21 | |||
8096 | 59801 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1981 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | 5 | 1 | 10 | 28858 | 21 | |
8884 | 4658 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:50:00 PM | 3 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | 3 | 1 | 10 | 308 | 23 | ||
9142 | 28298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.47543 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | 5 | 1 | 10 | 28857 | 21 | ||
9683 | 13057 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | 3 | 1 | 10 | 308 | 23 | ||
10262 | 71774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007619.84868 | 2115422.03298 | 37.7889759474427 | -122.417469829771 | (37.7889759474427, -122.417469829771) | 13 | 1 | 10 | 28858 | 21 | |||
10717 | 73755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 4x4 | 6010721.4091 | 2118959.281 | 37.7988624001506 | -122.406988209463 | (37.7988624001506, -122.406988209463) | 3 | 1 | 10 | 308 | 23 | ||
11043 | 73644 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007593.08329 | 2115418.15258 | 37.7889637868037 | -122.417562159565 | (37.7889637868037, -122.417562159565) | 13 | 1 | 10 | 28858 | 21 | |||
13043 | 73643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007653.32796 | 2115427.9906 | 37.7889941892882 | -122.417354417981 | (37.7889941892882, -122.417354417981) | 13 | 1 | 10 | 28858 | 21 | |||
13970 | 92645 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 5 | Permit Number 52936 | 6007592.74468 | 2118879.97123 | 37.7984690641427 | -122.41780881572 | (37.7984690641427, -122.41780881572) | 5 | 1 | 10 | 28858 | 32 | ||
15435 | 21765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/1999 12:00:00 AM | 3 | 3X3 | 6008457.4342459 | 2121063.933871 | 37.8045143025639 | -122.414971372963 | (37.8045143025639, -122.414971372963) | 3 | 1 | 10 | 308 | 23 | ||
15712 | 42849 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1339 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 9 | Permit Number 42779 | 6007122.62792 | 2118418.9864 | 37.7971768480902 | -122.419402847888 | (37.7971768480902, -122.419402847888) | 5 | 1 | 10 | 28858 | 32 | |
15750 | 143434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 614 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010970.3089 | 2116830.9135 | 37.7930323426546 | -122.405976914378 | (37.7930323426546, -122.405976914378) | 3 | 1 | 10 | 28857 | 4 | |||
15897 | 72062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009233.34768 | 2115143.00173 | 37.7883004477513 | -122.411867591225 | (37.7883004477513, -122.411867591225) | 5 | 1 | 10 | 28852 | 21 | |||
16416 | 72471 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6011955.18605 | 2119478.23212 | 37.8003562770843 | -122.402755428236 | (37.8003562770843, -122.402755428236) | 3 | 1 | 10 | 308 | 23 | |||
16454 | 62978 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1127 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23368 | 6008126.82627 | 2118560.34319 | 37.7976214864014 | -122.415938076582 | (37.7976214864014, -122.415938076582) | 5 | 1 | 10 | 28858 | 21 | |
16484 | 65292 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/1990 12:00:00 AM | 14 | Permit Number 29486 | 6010574.9893 | 2116273.6869 | 37.7914802149935 | -122.407305449035 | (37.7914802149935, -122.407305449035) | 5 | 1 | 10 | 28857 | 6 | |
17826 | 98829 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1020 Union St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008023.61787 | 2119295.81426 | 37.7996351035429 | -122.416347326587 | (37.7996351035429, -122.416347326587) | 5 | 1 | 1 | 308 | 32 | |||
19214 | 130942 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2009 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008134.17215 | 2119500.60942 | 37.8002036360374 | -122.415979278142 | (37.8002036360374, -122.415979278142) | 5 | 1 | 1 | 308 | 32 | |||
19881 | 32358 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1660 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36912 | 6010095.76502785 | 2119756.50526668 | 37.8010163522878 | -122.409209439254 | (37.8010163522878, -122.409209439254) | 3 | 1 | 10 | 308 | 23 | |||
20444 | 253771 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 844 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | 3x3 | 6008309.10382 | 2120362.6037 | 37.802580290063 | -122.41543500385 | (37.802580290063, -122.41543500385) | 5 | 1 | 10 | 308 | 32 | ||
21661 | 110678 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1711 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6009160.27531 | 2119152.98868 | 37.7993067916409 | -122.412403963067 | (37.7993067916409, -122.412403963067) | 3 | 1 | 10 | 308 | 32 | |||
21701 | 113690 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 WALTER U LUM PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010972 | 2117336 | 37.7944192831765 | -122.406006661324 | (37.7944192831765, -122.406006661324) | 3 | 1 | 10 | 28857 | 4 | ||||
22326 | 46867 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1901 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44933 | 6009072.28883715 | 2119759.64832211 | 37.8009675906301 | -122.412751340025 | (37.8009675906301, -122.412751340025) | 3 | 1 | 10 | 308 | 32 | ||
22411 | 30461 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 443 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 110 | 6010832.04824719 | 2119620.20470279 | 37.8006833258058 | -122.406651960918 | (37.8006833258058, -122.406651960918) | 3 | 1 | 10 | 308 | 23 | |||
22575 | 46866 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1901 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44933 | 6009072.28883715 | 2119759.64832211 | 37.8009675906301 | -122.412751340025 | (37.8009675906301, -122.412751340025) | 3 | 1 | 10 | 308 | 32 | ||
24857 | 142708 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2449 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008382.691 | 2121245.3002 | 37.8050080885425 | -122.415242876101 | (37.8050080885425, -122.415242876101) | 5 | 1 | 10 | 308 | 23 | |||
25330 | 110679 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1711 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4x4 | 6009159.31462 | 2119143.77616 | 37.7992814424289 | -122.412406635872 | (37.7992814424289, -122.412406635872) | 3 | 1 | 10 | 308 | 32 | |||
25833 | 21756 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.414945591572 | (37.8043254753522, -122.414945591572) | 5 | 1 | 10 | 308 | 23 | |||
27411 | 142700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2450 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008419.2668 | 2121323.1249 | 37.8052238310614 | -122.415121813151 | (37.8052238310614, -122.415121813151) | 5 | 1 | 10 | 308 | 23 | |||
27724 | 30430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 418 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 83 | 6010919.16231667 | 2119684.73214888 | 37.8008653758927 | -122.406355057963 | (37.8008653758927, -122.406355057963) | 3 | 1 | 10 | 308 | 23 | |||
27868 | 143457 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010564.724 | 2116380.3326 | 37.7917724639101 | -122.407348488451 | (37.7917724639101, -122.407348488451) | 5 | 1 | 10 | 28857 | 6 | |||
28737 | 18523 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1751X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6009567.6842 | 2119779.6829 | 37.8010503933376 | -122.411038470249 | (37.8010503933376, -122.411038470249) | 3 | 1 | 10 | 308 | 23 | |||
29083 | 142695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2420 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008443.7789 | 2121154.6753 | 37.8047626883554 | -122.415025055344 | (37.8047626883554, -122.415025055344) | 5 | 1 | 10 | 308 | 23 | |||
29777 | 130910 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008535.61739 | 2117300.68224 | 37.7941857425299 | -122.414434366064 | (37.7941857425299, -122.414434366064) | 5 | 1 | 10 | 28857 | 21 | |||
30857 | 128381 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 127 Trenton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6010059.5029 | 2118032.59603 | 37.7962808885957 | -122.40921320445 | (37.7962808885957, -122.40921320445) | 3 | 1 | 10 | 308 | 4 | |||
32441 | 130921 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008092.1732 | 2118902.72687 | 37.7985596384605 | -122.416082245996 | (37.7985596384605, -122.416082245996) | 5 | 1 | 10 | 28858 | 21 | |||
34474 | 95271 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:36:00 PM | 3 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
34592 | 71432 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 265 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2015 12:00:00 AM | 6 | Permit Number 774166 | 6010066.2856 | 2121257.2948 | 37.805135497346 | -122.409417426777 | (37.805135497346, -122.409417426777) | 3 | 1 | 10 | 308 | 23 | |
34931 | 142699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2440 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008424.9673 | 2121275.5258 | 37.805093456275 | -122.415098714484 | (37.805093456275, -122.415098714484) | 5 | 1 | 10 | 308 | 23 | |||
36170 | 13060 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2013 12:00:00 AM | 3 | 2X2 | 6009601.7098 | 2120500.5639 | 37.8030316618488 | -122.410971671797 | (37.8030316618488, -122.410971671797) | 3 | 1 | 10 | 308 | 23 | ||
36363 | 21824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2741 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6008240.40798 | 2122263.00335 | 37.8077944465112 | -122.415807371838 | (37.8077944465112, -122.415807371838) | 5 | 1 | 10 | 308 | 23 | |||
38471 | 130932 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1249 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007579.81465 | 2118484.19031 | 37.7973816210074 | -122.417825488267 | (37.7973816210074, -122.417825488267) | 5 | 1 | 10 | 28858 | 32 | |||
38661 | 84851 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1218 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | 3 | Permit No. 49297 | 6008088.9992 | 2116695.46262 | 37.7924988589863 | -122.415936840016 | (37.7924988589863, -122.415936840016) | 5 | 1 | 10 | 28858 | 21 | ||
40344 | 130936 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1919 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009064.99565 | 2119815.71098 | 37.8011211154083 | -122.412780543385 | (37.8011211154083, -122.412780543385) | 3 | 1 | 10 | 308 | 32 | |||
41129 | 113251 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 59 Walter U Lum Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011020.1885 | 2117595.4098 | 37.7951342549615 | -122.405858204458 | (37.7951342549615, -122.405858204458) | 3 | 1 | 10 | 28857 | 4 | |||
41569 | 130894 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 835 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009891.71417 | 2116089.21746 | 37.7909354415545 | -122.409656554 | (37.7909354415545, -122.409656554) | 5 | 1 | 10 | 28857 | 21 | |||
41599 | 130954 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 107 Alta St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011295.76733 | 2119886.82464 | 37.8014413324994 | -122.405066077061 | (37.8014413324994, -122.405066077061) | 3 | 1 | 10 | 308 | 23 | |||
41797 | 130956 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 159 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011155.36791 | 2121057.17715 | 37.804646983936 | -122.405634403599 | (37.804646983936, -122.405634403599) | 3 | 1 | 10 | 28860 | 23 | |||
41854 | 35679 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 888 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 4 | Permit Number 38985 | 6007117.3304 | 2120899.52807 | 37.803987491295 | -122.419597262408 | (37.803987491295, -122.419597262408) | 5 | 1 | 1 | 28858 | 32 | ||
42170 | 130931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1249 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007564.14542 | 2118483.19446 | 37.7973780048356 | -122.417879637362 | (37.7973780048356, -122.417879637362) | 5 | 1 | 10 | 28858 | 32 | |||
42790 | 142565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008509.1559 | 2121042.1339 | 37.8044573515499 | -122.414790841135 | (37.8044573515499, -122.414790841135) | 3 | 1 | 10 | 308 | 23 |
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) );