trees
6,344 rows where qSpecies_id = 19 sorted by Location
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 | ||||||||||||||
101319 | 87695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2630 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2008 12:00:00 AM | 3 | 6010495.31841 | 2086065.48531 | 37.7085306829266 | -122.405452712695 | (37.7085306829266, -122.405452712695) | 9 | 7 | 8 | 309 | 39 | |||
64115 | 58008 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 36 Santa Barbara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/1977 12:00:00 AM | 10 | Permit Number 16974 | 5993293.61196 | 2086427.32786 | 37.7085473986128 | -122.464929726936 | (37.7085473986128, -122.464929726936) | 9 | 8 | 6 | 28861 | 25 | ||
117480 | 177329 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2610 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010501.25874 | 2086080.58941 | 37.7085724879009 | -122.405433245075 | (37.7085724879009, -122.405433245075) | 9 | 7 | 8 | 309 | 39 | |||
28227 | 87687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010522.05865 | 2086133.85401 | 37.7087199047792 | -122.405365106141 | (37.7087199047792, -122.405365106141) | 9 | 7 | 8 | 309 | 39 | |||
127697 | 177328 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010526.80865 | 2086149.78348 | 37.7087639094858 | -122.405349810469 | (37.7087639094858, -122.405349810469) | 9 | 7 | 8 | 309 | 39 | |||
11909 | 29249 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010557.0875047 | 2086190.1499449 | 37.7088764405738 | -122.405248002787 | (37.7088764405738, -122.405248002787) | 9 | 7 | 8 | 309 | 39 | ||
119177 | 1865 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2555 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010708.42536 | 2086342.04995 | 37.7093019873752 | -122.404735641836 | (37.7093019873752, -122.404735641836) | 10 | 3 | 8 | 309 | 1 | |||
7764 | 251735 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437 | 2086534 | 37.7093632573177 | -122.433336687258 | (37.7093632573177, -122.433336687258) | 9 | 7 | 6 | 28861 | 5 | ||
41320 | 187485 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | 9 | 7 | 8 | 309 | 39 | |||
44310 | 187486 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | 9 | 7 | 8 | 309 | 39 | |||
105018 | 187487 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 3 | Front Yard : Yard | Tree | Private 2 | 12 | Width 9ft | 6006739.49241 | 2086592.28801 | 37.7097664548381 | -122.418470670891 | (37.7097664548381, -122.418470670891) | 9 | 7 | 8 | 309 | 39 | |||
31404 | 187488 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6006708.59512 | 2086603.96966 | 37.7097967907675 | -122.418578285583 | (37.7097967907675, -122.418578285583) | 9 | 7 | 8 | 309 | 39 | |||
2992 | 187489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6006684.44019 | 2086612.84014 | 37.7098197873211 | -122.418662398253 | (37.7098197873211, -122.418662398253) | 9 | 7 | 8 | 309 | 39 | ||||
57236 | 1872 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010689.18538 | 2086549.45702 | 37.709870410169 | -122.404816731011 | (37.709870410169, -122.404816731011) | 9 | 7 | 8 | 309 | 39 | ||
19479 | 81046 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997413.7835 | 2086913.91099 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | 9 | 7 | 6 | 28861 | 25 | |||
142704 | 31040 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1142 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34799 | 6000861.46493561 | 2086848.36005116 | 37.7101369112208 | -122.438804492218 | (37.7101369112208, -122.438804492218) | 9 | 7 | 6 | 28861 | 5 | ||
31649 | 177325 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 499 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012707.89529 | 2086680.32707 | 37.7103423833654 | -122.397848820678 | (37.7103423833654, -122.397848820678) | 10 | 3 | 8 | 309 | 1 | |||
141888 | 177326 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 499 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012697.69197 | 2086683.76637 | 37.7103512587691 | -122.397884326811 | (37.7103512587691, -122.397884326811) | 10 | 3 | 8 | 309 | 1 | |||
96867 | 177327 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 499 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012676.28456 | 2086691.43858 | 37.7103711329041 | -122.397958853633 | (37.7103711329041, -122.397958853633) | 10 | 3 | 8 | 309 | 1 | |||
140950 | 70302 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50275 | 6008251.84805 | 2086827.40213 | 37.7104970532627 | -122.413260293054 | (37.7104970532627, -122.413260293054) | 9 | 7 | 8 | 309 | 39 | |
157038 | 44401 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1159 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 8 | Permit Number 43755 | 6001322.64573 | 2087056.41932 | 37.7107344230292 | -122.437225450291 | (37.7107344230292, -122.437225450291) | 9 | 7 | 6 | 28861 | 5 | |
5270 | 80931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001747.57084 | 2087049.21095 | 37.710738776642 | -122.435756299834 | (37.710738776642, -122.435756299834) | 9 | 7 | 6 | 28861 | 5 | |||
719 | 80747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | 9 | 7 | 6 | 28861 | 5 | |||
20366 | 1853 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2445 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1991 12:00:00 AM | 6 | 3X3 | 6011002.0813 | 2086868.54548 | 37.7107640475959 | -122.403757736125 | (37.7107640475959, -122.403757736125) | 10 | 3 | 8 | 309 | 1 | ||
108031 | 106453 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 27 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6002753.37537 | 2087052.66681 | 37.7108053471734 | -122.432280260948 | (37.7108053471734, -122.432280260948) | 9 | 7 | 6 | 28861 | 5 | ||||
143848 | 177391 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 27 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6002763.35309 | 2087066.10986 | 37.7108428246043 | -122.432246735124 | (37.7108428246043, -122.432246735124) | 9 | 7 | 6 | 28861 | 5 | |||
95068 | 1847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2401 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/1992 12:00:00 AM | 6 | 3X3 | 6011018.94328 | 2086899.69409 | 37.7108505173993 | -122.403701647223 | (37.7108505173993, -122.403701647223) | 10 | 3 | 8 | 309 | 1 | ||
11917 | 77997 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009714.16253 | 2086968.85209 | 37.7109674364637 | -122.408216166539 | (37.7109674364637, -122.408216166539) | 9 | 7 | 8 | 309 | 39 | |||
92458 | 49780 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 308@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/2006 12:00:00 AM | Permit Number 46566 | 6012576.33668152 | 2087040.28713415 | 37.7113234351738 | -122.398328757165 | (37.7113234351738, -122.398328757165) | 10 | 3 | 8 | 309 | 1 | ||
13114 | 44440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 131 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 11 | Permit Number 43772 | 6001589.30817 | 2087293.58304 | 37.7114007774922 | -122.43632076831 | (37.7114007774922, -122.43632076831) | 9 | 7 | 6 | 28861 | 5 | |
121490 | 92790 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 242 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2009 12:00:00 AM | 3x3 | Permit Number 53007 | 5994587 | 2087471 | 37.7114875681215 | -122.460535223932 | (37.7114875681215, -122.460535223932) | 9 | 8 | 6 | 28861 | 24 | ||
128224 | 177321 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1222 Naples St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 8ft | 6001045.82775 | 2087348.99146 | 37.7115220214042 | -122.438203139287 | (37.7115220214042, -122.438203139287) | 9 | 7 | 6 | 28861 | 5 | |||
31515 | 69415 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33520 | 6001498.01524641 | 2087340.50878812 | 37.7115244375894 | -122.436639656352 | (37.7115244375894, -122.436639656352) | 9 | 7 | 6 | 28861 | 5 | ||
114014 | 95538 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1220 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6001061.1187 | 2087367.06647 | 37.7115725210346 | -122.438151583834 | (37.7115725210346, -122.438151583834) | 9 | 7 | 6 | 28861 | 5 | ||||
119897 | 69403 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1220 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33507 | 6001071.30066 | 2087381.77877 | 37.7116134968267 | -122.438117445581 | (37.7116134968267, -122.438117445581) | 9 | 7 | 6 | 28861 | 5 | |
32989 | 50828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.468348178801 | (37.7117332358721, -122.468348178801) | 9 | 8 | 4 | 64 | 24 | |||
7986 | 180642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 56 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6001992.8038 | 2087466.28016 | 37.7118978840556 | -122.4349385283 | (37.7118978840556, -122.4349385283) | 9 | 7 | 6 | 28861 | 5 | |||
147626 | 177390 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002484.29135 | 2087521.98733 | 37.71207873771 | -122.433243789189 | (37.71207873771, -122.433243789189) | 9 | 7 | 6 | 28861 | 5 | |||
7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
183246 | 81049 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1239 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2015 12:00:00 AM | 3 | Permit Number 773468 | 6001528.59209 | 2087552.56023 | 37.7121084216401 | -122.436549143022 | (37.7121084216401, -122.436549143022) | 9 | 7 | 6 | 28861 | 5 | |
163471 | 44391 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 102 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | 4 | Permit Number 43750 | 6001720.67463 | 2087557.55104 | 37.7121330387771 | -122.435885607952 | (37.7121330387771, -122.435885607952) | 9 | 7 | 6 | 28861 | 5 | |
157052 | 49553 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46443 | 6001403.3817 | 2087572.50991 | 37.7121560830087 | -122.43698333301 | (37.7121560830087, -122.43698333301) | 9 | 7 | 6 | 28861 | 5 | |
151932 | 49554 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 3x3 | Permit Number 46443 | 6001366.47031855 | 2087579.35452031 | 37.7121727787169 | -122.437111399043 | (37.7121727787169, -122.437111399043) | 9 | 7 | 6 | 28861 | 5 | ||
75309 | 177388 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6002480.54707 | 2087582.38696 | 37.7122443694603 | -122.433261043589 | (37.7122443694603, -122.433261043589) | 9 | 7 | 6 | 28861 | 5 | |||
49831 | 177389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Munich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002499.03249 | 2087613.48874 | 37.7123308167966 | -122.433199373453 | (37.7123308167966, -122.433199373453) | 9 | 7 | 6 | 28861 | 5 | |||
75067 | 1836 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2190X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011449.2894285 | 2087454.5820611 | 37.7123981596303 | -122.402253250732 | (37.7123981596303, -122.402253250732) | 10 | 7 | 8 | 309 | 39 | |||
57282 | 251765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Seville St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6001915 | 2087651 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | 9 | 7 | 6 | 28861 | 5 | ||||
69751 | 251767 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Seville St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6001915 | 2087651 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | 9 | 7 | 6 | 28861 | 5 | ||||
100210 | 176854 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6001915 | 2087651 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | 9 | 7 | 6 | 28861 | 5 | |||
133619 | 251766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Seville St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6001915 | 2087651 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | 9 | 7 | 6 | 28861 | 5 | ||||
171671 | 87653 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2180X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6011545.44829 | 2087485.71058 | 37.7124889994373 | -122.401923081412 | (37.7124889994373, -122.401923081412) | 10 | 7 | 8 | 309 | 39 | ||||
88026 | 1831 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6011874.06348 | 2087549.91911 | 37.7126836379108 | -122.400791787333 | (37.7126836379108, -122.400791787333) | 10 | 3 | 8 | 309 | 1 | |||
163264 | 42734 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2155 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 24 | Permit Number 42735 | 6011889.38362 | 2087568.31883 | 37.7127350143717 | -122.400740127574 | (37.7127350143717, -122.400740127574) | 10 | 3 | 8 | 309 | 1 | |
150226 | 1828 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2144 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011802.73897 | 2087632.59723 | 37.7129066769684 | -122.401044114602 | (37.7129066769684, -122.401044114602) | 10 | 7 | 8 | 309 | 39 | |||
37270 | 177320 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 48 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999675.46135 | 2087889.84317 | 37.7129290440003 | -122.442978286612 | (37.7129290440003, -122.442978286612) | 9 | 7 | 6 | 28861 | 5 | |||
70501 | 177323 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 110 Newton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000963.79305 | 2087874.93252 | 37.7129614726723 | -122.438524331244 | (37.7129614726723, -122.438524331244) | 9 | 7 | 6 | 28861 | 5 | |||
40678 | 1827 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2142 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011820.2937054 | 2087653.754231 | 37.712965749133 | -122.400984924928 | (37.712965749133, -122.400984924928) | 10 | 7 | 8 | 309 | 39 | |||
77308 | 177322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 110 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000954.81094 | 2087902.84558 | 37.7130376047797 | -122.438557375049 | (37.7130376047797, -122.438557375049) | 9 | 7 | 6 | 28861 | 5 | |||
37155 | 87649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2132 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2008 12:00:00 AM | 3 | 6011869.04727 | 2087711.09521 | 37.7131259154971 | -122.400820441523 | (37.7131259154971, -122.400820441523) | 10 | 7 | 8 | 309 | 39 | |||
62636 | 31011 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34782 | 6000906.10436 | 2087937.38156 | 37.7131296620864 | -122.438728194053 | (37.7131296620864, -122.438728194053) | 9 | 7 | 6 | 28861 | 5 | |
117880 | 31010 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
163801 | 31012 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
85118 | 1825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2122 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2008 12:00:00 AM | 3 | 3x3 | 6011914.69441 | 2087767.06521 | 37.7132821439374 | -122.400666598098 | (37.7132821439374, -122.400666598098) | 10 | 7 | 8 | 309 | 39 |
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) );