trees
6,344 rows where qSpecies_id = 19 sorted by Supervisor 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 | ||||||||||||||
76 | 34164 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2500 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38230 | 6001594.91074 | 2117340.13182 | 37.7939017096586 | -122.438452751501 | (37.7939017096586, -122.438452751501) | 13 | 9 | 1 | 57 | 27 | ||
510 | 138618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1844 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000524.7294 | 2115065.5231 | 37.787595296239 | -122.441992330061 | (37.787595296239, -122.441992330061) | 13 | 6 | 1 | 29490 | 27 | |||
867 | 130823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004083.73489 | 2117213.2991 | 37.7936947127019 | -122.429832130065 | (37.7936947127019, -122.429832130065) | 13 | 9 | 1 | 29490 | 27 | |||
924 | 168125 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999732.18095 | 2116962.81225 | 37.7927595589676 | -122.444870818143 | (37.7927595589676, -122.444870818143) | 13 | 6 | 1 | 29490 | 27 | |||
1296 | 114159 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.7953963109343 | -122.434341453993 | (37.7953963109343, -122.434341453993) | 13 | 9 | 1 | 57 | 17 | |
1464 | 130824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004088.29924 | 2117192.3041 | 37.7936373242572 | -122.429814838808 | (37.7936373242572, -122.429814838808) | 13 | 9 | 1 | 29490 | 27 | |||
1624 | 70261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3828 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5996527.35216 | 2114976.82048 | 37.7871231398678 | -122.455815970326 | (37.7871231398678, -122.455815970326) | 11 | 6 | 1 | 54 | 31 | |||
1682 | 3092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2980 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000114.43818 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | 13 | 6 | 1 | 29490 | 27 | |||
2078 | 168123 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999728.56043 | 2116992.74288 | 37.792841533961 | -122.444885497769 | (37.792841533961, -122.444885497769) | 13 | 6 | 1 | 29490 | 27 | |||
3006 | 130736 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2456 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000252.0898 | 2117051.94751 | 37.793033958294 | -122.443078320911 | (37.793033958294, -122.443078320911) | 13 | 6 | 1 | 29490 | 27 | |||
3139 | 130835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2707 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003954.12542 | 2118159.05361 | 37.7962841720447 | -122.430348098084 | (37.7962841720447, -122.430348098084) | 13 | 9 | 1 | 57 | 17 | |||
3209 | 130852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004581.36981 | 2117470.78611 | 37.7944298743033 | -122.42812862796 | (37.7944298743033, -122.42812862796) | 13 | 9 | 1 | 28858 | 27 | |||
3661 | 130497 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3536 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000731.95465 | 2120687.25683 | 37.8030429054598 | -122.441678975811 | (37.8030429054598, -122.441678975811) | 13 | 9 | 1 | 57 | 17 | |||
3833 | 130643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2596 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002472.36463 | 2115758.47109 | 37.7896087481804 | -122.435303491175 | (37.7896087481804, -122.435303491175) | 13 | 9 | 1 | 29490 | 27 | |||
4024 | 114160 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.434397600465 | (37.7953804657925, -122.434397600465) | 13 | 9 | 1 | 57 | 17 | |
4030 | 65762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3002 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 13 | Permit Number 28725 | 6003868.45772 | 2119096.10509 | 37.7988522212082 | -122.43071142781 | (37.7988522212082, -122.43071142781) | 13 | 9 | 1 | 57 | 17 | |
4264 | 130484 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 148 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002643.1953 | 2119039.17059 | 37.7986264014436 | -122.434947157292 | (37.7986264014436, -122.434947157292) | 13 | 9 | 1 | 57 | 17 | |||
4515 | 130841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2140 Pacific Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003916.87009 | 2117324.15419 | 37.7939896417495 | -122.430417409747 | (37.7939896417495, -122.430417409747) | 13 | 9 | 1 | 29490 | 27 | |||
4555 | 130513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 213 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998527.12413 | 2115621.30489 | 37.7890072896931 | -122.448943670531 | (37.7890072896931, -122.448943670531) | 13 | 6 | 1 | 54 | 31 | |||
4860 | 168126 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999733.55538 | 2116947.29263 | 37.7927170246219 | -122.444864946464 | (37.7927170246219, -122.444864946464) | 13 | 6 | 1 | 29490 | 27 | |||
5002 | 138596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1997 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001444.315 | 2115232.308 | 37.788105604547 | -122.438822708512 | (37.788105604547, -122.438822708512) | 13 | 6 | 1 | 29490 | 27 | |||
5545 | 130743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2505 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6000699.35516 | 2116964.23908 | 37.7928186255236 | -122.441524465083 | (37.7928186255236, -122.441524465083) | 13 | 6 | 1 | 29490 | 27 | |||
5873 | 168127 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999736.35511 | 2116932.30675 | 37.7926760371256 | -122.444854181598 | (37.7926760371256, -122.444854181598) | 13 | 6 | 1 | 29490 | 27 | |||
5892 | 261243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 840 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||||
5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
6152 | 68969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3343 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32959 | 5999787.27845 | 2120075.09917 | 37.8013082157737 | -122.44490400674 | (37.8013082157737, -122.44490400674) | 13 | 9 | 1 | 57 | 17 | |
6574 | 65759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3016 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 13 | Permit Number 28722 | 6003857.62455 | 2119183.89761 | 37.7990926630433 | -122.430755182511 | (37.7990926630433, -122.430755182511) | 13 | 9 | 1 | 57 | 17 | |
6588 | 46352 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 13 | Permit Number 44595 | 6000732.4975 | 2116220.35681 | 37.7907780071577 | -122.441356390798 | (37.7907780071577, -122.441356390798) | 13 | 6 | 1 | 29490 | 27 | ||
6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
7297 | 130697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2311 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999746.50713 | 2116862.80854 | 37.7924857927226 | -122.444814057435 | (37.7924857927226, -122.444814057435) | 13 | 6 | 1 | 29490 | 27 | |||
7596 | 137880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2148 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003654.0545 | 2115274.6949 | 37.7883474575543 | -122.431180423335 | (37.7883474575543, -122.431180423335) | 13 | 9 | 1 | 29490 | 27 | |||
8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
9118 | 120468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988384.0014 | 2115083.94801 | 37.7869465618324 | -122.483997692017 | (37.7869465618324, -122.483997692017) | 11 | 6 | 1 | 55 | 33 | |||
9273 | 28375 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.59092 | 2115494.6796 | 37.7887579085949 | -122.442978542939 | (37.7887579085949, -122.442978542939) | 13 | 6 | 1 | 29490 | 27 | |
9614 | 130665 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3152 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999642.12267 | 2116065.45546 | 37.7902905134552 | -122.445117879904 | (37.7902905134552, -122.445117879904) | 13 | 6 | 1 | 29490 | 27 | |||
9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
9660 | 94240 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2517 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 53613 | 6001913.77798 | 2116990.99637 | 37.7929612067506 | -122.437324430597 | (37.7929612067506, -122.437324430597) | 13 | 6 | 1 | 29490 | 27 | |
9882 | 110280 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2845 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5999937.93955 | 2117050.91929 | 37.7930132181276 | -122.444165220867 | (37.7930132181276, -122.444165220867) | 13 | 9 | 1 | 29490 | 27 | |||
9977 | 12786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1926X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5989360.57879 | 2114746.40468 | 37.7860765689348 | -122.480594276512 | (37.7860765689348, -122.480594276512) | 11 | 6 | 1 | 55 | 33 | |||
9988 | 87741 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2536 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50404 | 6001459.44727 | 2117322.47349 | 37.7938455182068 | -122.438920201115 | (37.7938455182068, -122.438920201115) | 13 | 9 | 1 | 57 | 27 | |
11241 | 30330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2820 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | 9 | Permit Number 28881 | 5999458.41568 | 2118085.66723 | 37.795826993587 | -122.445898848463 | (37.795826993587, -122.445898848463) | 13 | 9 | 1 | 57 | 17 | ||
11555 | 250317 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3800 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995989.81412 | 2115885.19527 | 37.789586427918 | -122.457741476398 | (37.789586427918, -122.457741476398) | 11 | 6 | 1 | 54 | 31 | |||
11668 | 140846 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996563.342 | 2113760.0078 | 37.7837841621477 | -122.455603469395 | (37.7837841621477, -122.455603469395) | 11 | 6 | 1 | 54 | 31 | |||
11758 | 41190 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2020 12:00:00 AM | 3 | Permit Number 782407 | 6003669.72123 | 2117044.16503 | 37.7932068601533 | -122.431252574158 | (37.7932068601533, -122.431252574158) | 13 | 9 | 1 | 29490 | 27 | ||
12039 | 130797 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2420 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002334.43206 | 2117092.48928 | 37.7932637845338 | -122.435876212726 | (37.7932637845338, -122.435876212726) | 13 | 9 | 1 | 29490 | 27 | |||
12132 | 88765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2661 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51686 | 6000918.40593 | 2117193.70791 | 37.7934611641623 | -122.440783009137 | (37.7934611641623, -122.440783009137) | 13 | 9 | 1 | 29490 | 27 | |
12554 | 130859 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1890 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004541.87026 | 2118099.91409 | 37.7961550644564 | -122.428310161511 | (37.7961550644564, -122.428310161511) | 13 | 9 | 1 | 57 | 17 | |||
12557 | 168124 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999730.18853 | 2116975.80992 | 37.7927951334346 | -122.444878646726 | (37.7927951334346, -122.444878646726) | 13 | 6 | 1 | 29490 | 27 | |||
12707 | 72459 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 414 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997210.21776 | 2114935.94674 | 37.7870500780436 | -122.45345046559 | (37.7870500780436, -122.45345046559) | 11 | 6 | 1 | 54 | 31 | |||
13039 | 130815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2225 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003300.13476 | 2117178.12968 | 37.7935537412686 | -122.432540939311 | (37.7935537412686, -122.432540939311) | 13 | 9 | 1 | 29490 | 27 | |||
13133 | 130551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3333 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998274.96024 | 2116157.53474 | 37.7904652103522 | -122.449854780897 | (37.7904652103522, -122.449854780897) | 13 | 6 | 1 | 54 | 31 | |||
13166 | 46255 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2161 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 44539 | 6000416.49604 | 2120605.00843 | 37.802799094759 | -122.442764714729 | (37.802799094759, -122.442764714729) | 13 | 9 | 1 | 57 | 17 | |||
13367 | 132936 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6003117.4123 | 2117569.74013 | 37.794618639305 | -122.433201167605 | (37.794618639305, -122.433201167605) | 13 | 9 | 1 | 29490 | 27 | |||
13442 | 95317 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2870@Divisadero Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54638 | 6000958.18903 | 2116249.84914 | 37.790871839718 | -122.440577627377 | (37.790871839718, -122.440577627377) | 13 | 6 | 1 | 29490 | 27 | |
13914 | 130707 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2878 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999875.30316 | 2117112.77625 | 37.7931794874933 | -122.444386392923 | (37.7931794874933, -122.444386392923) | 13 | 9 | 1 | 57 | 27 | |||
13932 | 130564 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 290 Maple St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996653.21029 | 2115422.72042 | 37.7883546840652 | -122.455412770106 | (37.7883546840652, -122.455412770106) | 11 | 6 | 1 | 54 | 31 | |||
14303 | 125106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3167 Jackson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/01/2019 12:00:00 AM | 3 | Width 5ft | 5999044.89731 | 2116267.38185 | 37.7908108440947 | -122.447198767233 | (37.7908108440947, -122.447198767233) | 13 | 6 | 1 | 29490 | 31 | ||
14464 | 44040 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.74454 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | 13 | 6 | 1 | 29490 | 27 | ||
14523 | 130701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2897 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999786.03622 | 2117022.81208 | 37.7929273760386 | -122.444688791774 | (37.7929273760386, -122.444688791774) | 13 | 9 | 1 | 29490 | 27 | |||
14575 | 30998 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34777 | 6003940.50328 | 2117270.99344 | 37.7938450145991 | -122.430331841946 | (37.7938450145991, -122.430331841946) | 13 | 9 | 1 | 29490 | 27 | |
14610 | 138609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1731 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999525.0921 | 2114915.5372 | 37.7871264588152 | -122.445440076619 | (37.7871264588152, -122.445440076619) | 15 | 6 | 1 | 29490 | 31 | |||
15944 | 94239 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2517 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 53613 | 6001890.99196 | 2116983.84316 | 37.792940270518 | -122.437402758825 | (37.792940270518, -122.437402758825) | 13 | 6 | 1 | 29490 | 27 | |
16013 | 108100 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2390X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 |
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) );