trees
6,344 rows where qSpecies_id = 19 sorted by Longitude
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 | ||||||||||||||
193302 | 52147 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 991 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 3 | Permit Number 48338 | 6018752.39982 | 2094769.7701 | 37.7328892306529 | -122.377518518074 | (37.7328892306529, -122.377518518074) | 10 | 3 | 8 | 58 | 1 | |
187429 | 193297 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018142.28211 | 2093130.97171 | 37.7283557769992 | -122.379514069636 | (37.7283557769992, -122.379514069636) | 10 | 3 | 8 | 58 | 1 | |||
10334 | 193296 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018120.52005 | 2093146.99774 | 37.728398581107 | -122.379590415761 | (37.728398581107, -122.379590415761) | 10 | 3 | 8 | 58 | 1 | |||
81951 | 10841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1139X Hudson Ave | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6018009.01401 | 2094605.73201 | 37.7323978299879 | -122.380077225848 | (37.7323978299879, -122.380077225848) | 10 | 3 | 8 | 58 | 1 | ||
40448 | 10840 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1139X Hudson Ave | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6017999.90001 | 2094605.73201 | 37.7323973271712 | -122.380108735409 | (37.7323973271712, -122.380108735409) | 10 | 3 | 8 | 58 | 1 | ||
151495 | 193287 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1333 Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017994.80207 | 2094589.40818 | 37.7323522238796 | -122.380125226414 | (37.7323522238796, -122.380125226414) | 10 | 3 | 8 | 58 | 1 | |||
37674 | 193286 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1333 Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017977.93865 | 2094591.23202 | 37.7323563014062 | -122.380183654476 | (37.7323563014062, -122.380183654476) | 10 | 3 | 8 | 58 | 1 | |||
98107 | 85593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017785.7597 | 2093054.1055 | 37.7281250477035 | -122.380741255703 | (37.7281250477035, -122.380741255703) | 10 | 3 | 8 | 58 | 1 | ||
149746 | 85592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017759.3783 | 2093071.6931 | 37.7281718838379 | -122.380833680203 | (37.7281718838379, -122.380833680203) | 10 | 3 | 8 | 58 | 1 | ||
82447 | 85594 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1039 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017732.9969 | 2093089.2807 | 37.7282187198994 | -122.38092610482 | (37.7282187198994, -122.38092610482) | 10 | 3 | 8 | 58 | 1 | ||
128893 | 85595 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1043 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017691.776 | 2093118.9598 | 37.7282979376858 | -122.381070671174 | (37.7282979376858, -122.381070671174) | 10 | 3 | 8 | 58 | 1 | ||
181071 | 85596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1081 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017650.0054 | 2093150.2876 | 37.7283816519577 | -122.381217252784 | (37.7283816519577, -122.381217252784) | 10 | 3 | 8 | 58 | 1 | ||
162360 | 6711 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 05:42:00 PM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
40594 | 193298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1040 Palou Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6017507.81667 | 2093329.78992 | 37.7288666800305 | -122.38172129012 | (37.7288666800305, -122.38172129012) | 10 | 3 | 8 | 58 | 1 | |||
7062 | 60350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.7287441803863 | -122.381867009636 | (37.7287441803863, -122.381867009636) | 10 | 3 | 8 | 58 | 1 | |
15957 | 4906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | 10 | 3 | 8 | 58 | 1 | ||
2024 | 190143 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 10:47:00 AM | 3 | Width 4ft | 6017523.52148 | 2096815.65975 | 37.7384390567147 | -122.381909364434 | (37.7384390567147, -122.381909364434) | 10 | 3 | 8 | 58 | 1 | ||
20671 | 193295 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017437.79116 | 2093660.55631 | 37.7297710328838 | -122.38198637428 | (37.7297710328838, -122.38198637428) | 10 | 3 | 8 | 58 | 1 | |||
25931 | 193290 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017463.55131 | 2095291.12818 | 37.734249684563 | -122.382010696451 | (37.734249684563, -122.382010696451) | 10 | 3 | 8 | 58 | 1 | |||
187988 | 193291 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017457.59567 | 2095286.93969 | 37.7342378548914 | -122.382030995952 | (37.7342378548914, -122.382030995952) | 10 | 3 | 8 | 58 | 1 | |||
31592 | 193294 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017423.21493 | 2093673.93611 | 37.729806966204 | -122.382037696797 | (37.729806966204, -122.382037696797) | 10 | 3 | 8 | 58 | 1 | |||
73028 | 193293 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017403.28681 | 2093687.42356 | 37.7298428995102 | -122.382107529135 | (37.7298428995102, -122.382107529135) | 10 | 3 | 8 | 58 | 1 | |||
9417 | 203065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:10:00 PM | 3 | Width 3ft | 6017458.84969 | 2097245.24162 | 37.7396150308979 | -122.382162846439 | (37.7396150308979, -122.382162846439) | 10 | 3 | 8 | 58 | 1 | ||
117868 | 1399 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 54 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017410.5516844 | 2095373.0690166 | 37.7344717507601 | -122.382199633479 | (37.7344717507601, -122.382199633479) | 10 | 3 | 8 | 58 | 1 | ||
156526 | 193314 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1215 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017437.09281 | 2096794.30817 | 37.7383756563231 | -122.382206710884 | (37.7383756563231, -122.382206710884) | 10 | 3 | 8 | 58 | 1 | |||
151177 | 6748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1215 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017436.89509 | 2096796.05164 | 37.7383804326225 | -122.382207515766 | (37.7383804326225, -122.382207515766) | 10 | 3 | 8 | 58 | 1 | ||
26664 | 199882 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1131 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017363.6575 | 2093361.8884 | 37.728946855007 | -122.382221895551 | (37.728946855007, -122.382221895551) | 10 | 3 | 8 | 58 | 1 | |||
40209 | 193100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 Fairfax Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6017433.94384 | 2096880.5876 | 37.7386123884484 | -122.382223599248 | (37.7386123884484, -122.382223599248) | 10 | 3 | 8 | 58 | 1 | |||
8087 | 188688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816544 | -122.382223941884 | (37.739646816544, -122.382223941884) | 10 | 3 | 8 | 58 | 1 | ||
163466 | 193289 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017396.94192 | 2095313.39296 | 37.7343071404432 | -122.382242537166 | (37.7343071404432, -122.382242537166) | 10 | 3 | 8 | 58 | 1 | |||
19103 | 193292 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017364.44288 | 2093716.31678 | 37.7299200892409 | -122.382243827706 | (37.7299200892409, -122.382243827706) | 10 | 3 | 8 | 58 | 1 | |||
157971 | 1405 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 63 Ardath Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017388.8354209 | 2095314.9218023 | 37.7343108905935 | -122.382270670557 | (37.7343108905935, -122.382270670557) | 10 | 3 | 8 | 58 | 1 | ||
11058 | 188442 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6017408.67942 | 2097282.36848 | 37.7397142027529 | -122.382338897719 | (37.7397142027529, -122.382338897719) | 10 | 3 | 8 | 58 | 1 | ||
139562 | 85600 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1139 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017318.5893 | 2093398.7124 | 37.7290454771777 | -122.382380262149 | (37.7290454771777, -122.382380262149) | 10 | 3 | 8 | 58 | 1 | ||
69331 | 193101 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 4ft | 6017385.96084 | 2096915.0483 | 37.7387043603066 | -122.382391900165 | (37.7387043603066, -122.382391900165) | 10 | 3 | 8 | 58 | 1 | |||
22848 | 1398 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2004 12:00:00 AM | 3 | 3X4 | 6017352.5573683 | 2095370.395604 | 37.7344612068158 | -122.382399955055 | (37.7344612068158, -122.382399955055) | 10 | 3 | 8 | 58 | 1 | ||
2415 | 153966 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6017369.99484 | 2096847.10054 | 37.7385169074393 | -122.382442377325 | (37.7385169074393, -122.382442377325) | 10 | 3 | 8 | 58 | 1 | |||
164927 | 85601 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1155 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017239.4451 | 2093453.6736 | 37.7291920178595 | -122.382657695444 | (37.7291920178595, -122.382657695444) | 10 | 3 | 8 | 58 | 1 | ||
184880 | 193299 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1040 Palou Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017230.76066 | 2093531.80574 | 37.7294060736082 | -122.382693153289 | (37.7294060736082, -122.382693153289) | 10 | 3 | 8 | 58 | 1 | |||
66565 | 193300 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1040 Palou Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017214.21978 | 2093544.85541 | 37.7294409916083 | -122.382751244983 | (37.7294409916083, -122.382751244983) | 10 | 3 | 8 | 58 | 1 | |||
70092 | 193288 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017236.66649 | 2095426.16645 | 37.7346079402901 | -122.382804511829 | (37.7346079402901, -122.382804511829) | 10 | 3 | 8 | 58 | 1 | |||
7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
59127 | 85564 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1180 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017158.96801 | 2093588.13352 | 37.7295567721058 | -122.38294526831 | (37.7295567721058, -122.38294526831) | 10 | 3 | 8 | 58 | 1 | ||
168502 | 6758 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1355 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046 | 37.7388469269577 | -122.382978527185 | (37.7388469269577, -122.382978527185) | 10 | 3 | 8 | 58 | 1 | ||
8140 | 26662 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.7388160650952 | -122.382981244792 | (37.7388160650952, -122.382981244792) | 10 | 3 | 8 | 58 | 1 | ||
54653 | 6760 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017216.38852 | 2096959.46054 | 37.7388169392625 | -122.382981296967 | (37.7388169392625, -122.382981296967) | 10 | 3 | 8 | 58 | 1 | ||
114839 | 85602 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1179 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017122.3777 | 2093542.7108 | 37.7294300284364 | -122.383068605832 | (37.7294300284364, -122.383068605832) | 10 | 3 | 8 | 58 | 1 | ||
10462 | 85563 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.04426 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | 10 | 3 | 8 | 58 | 1 | ||
148906 | 193099 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6017167.81158 | 2096994.83854 | 37.7389113959363 | -122.383151716704 | (37.7389113959363, -122.383151716704) | 10 | 3 | 8 | 58 | 1 | |||
172611 | 6778 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2015 12:46:00 PM | 3 | 3x3 | 6017160.06774 | 2096999.60334 | 37.738924051197 | -122.383178823138 | (37.738924051197, -122.383178823138) | 10 | 3 | 8 | 58 | 1 | ||
90027 | 85603 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1187 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017079.5079 | 2093574.5883 | 37.7295151888321 | -122.383219030253 | (37.7295151888321, -122.383219030253) | 10 | 3 | 8 | 58 | 1 | ||
186092 | 193313 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1353 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017070.664 | 2097068.65347 | 37.7391087080946 | -122.383492748586 | (37.7391087080946, -122.383492748586) | 10 | 3 | 8 | 58 | 1 | |||
48390 | 193098 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1301 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6017070.0677 | 2097067.7936 | 37.7391063141074 | -122.383494750497 | (37.7391063141074, -122.383494750497) | 10 | 3 | 8 | 58 | 1 | |||
15831 | 59843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 3 | Permit Number 19298 | 6016839.42379 | 2093825.06532 | 37.730189678993 | -122.384066468412 | (37.730189678993, -122.384066468412) | 10 | 3 | 8 | 58 | 1 | |
35159 | 6743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016859.78768 | 2097310.83297 | 37.7397620268834 | -122.384238731741 | (37.7397620268834, -122.384238731741) | 10 | 3 | 8 | 58 | 1 | |||
107781 | 85571 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1252 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016751.40122 | 2093891.75216 | 37.7303679210377 | -122.384375419698 | (37.7303679210377, -122.384375419698) | 10 | 3 | 8 | 58 | 1 | ||
108386 | 193301 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1252 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016734.51502 | 2093904.28274 | 37.7304013937892 | -122.384434670625 | (37.7304013937892, -122.384434670625) | 10 | 3 | 8 | 58 | 1 | |||
151255 | 6783 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2008 12:00:00 AM | 4 | 3x3 | 6016785.69492 | 2097365.6274 | 37.7399083843537 | -122.384498731152 | (37.7399083843537, -122.384498731152) | 10 | 3 | 8 | 58 | 1 | ||
117049 | 193302 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1252 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016713.98205 | 2093918.10551 | 37.730438212946 | -122.3845066191 | (37.730438212946, -122.3845066191) | 10 | 3 | 8 | 58 | 1 | |||
10827 | 193103 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.7399452071057 | -122.384567672275 | (37.7399452071057, -122.384567672275) | 10 | 3 | 8 | 58 | 1 | |||
42848 | 34235 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1997 12:00:00 AM | Permit Number 38048 | 6016895.91787464 | 2103845.69851644 | 37.7577074184489 | -122.384568876102 | (37.7577074184489, -122.384568876102) | 10 | 3 | 8 | 28856 | 29 | ||||
17955 | 60377 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19957 | 6016692.94797 | 2093937.42445 | 37.7304900957418 | -122.384580682763 | (37.7304900957418, -122.384580682763) | 10 | 3 | 8 | 58 | 1 | |
4673 | 60356 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.7302945678233 | -122.384613110545 | (37.7302945678233, -122.384613110545) | 10 | 3 | 8 | 58 | 1 |
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) );