trees
6,344 rows where qSpecies_id = 19 sorted by XCoord
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 | ||||||||||||||
82862 | 119125 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5981604.24423 | 2111607.23903 | 37.7770035165843 | -122.507195675426 | (37.7770035165843, -122.507195675426) | 11 | 6 | 2 | 55 | 26 | |||
162815 | 108667 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 743 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773175 | 5981956.75596 | 2110691.04473 | 37.7745086716833 | -122.505908306981 | (37.7745086716833, -122.505908306981) | 11 | 6 | 2 | 55 | 26 | |
101888 | 68569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 859 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 6 | Permit Number 32459 | 5981982.26484 | 2109895.99725 | 37.7723272048107 | -122.50576111622 | (37.7723272048107, -122.50576111622) | 11 | 6 | 2 | 55 | 26 | |
89973 | 118703 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4237 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5982406.56675 | 2110976.40955 | 37.7753186661316 | -122.504373495781 | (37.7753186661316, -122.504373495781) | 11 | 6 | 2 | 55 | 26 | |||
188064 | 87822 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2274 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50715 | 5982710.3 | 2099649.4 | 37.744235769489 | -122.502484303694 | (37.744235769489, -122.502484303694) | 1 | 8 | 3 | 29491 | 35 | |||
35429 | 183642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1490 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982814.3712 | 2105004.9294 | 37.7589466720393 | -122.502520759166 | (37.7589466720393, -122.502520759166) | 1 | 8 | 3 | 56 | 35 | |||
51927 | 40203 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 567 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1999 12:00:00 AM | 7 | Permit Number 41385 | 5982843.19919 | 2111934.60892 | 37.7779752732797 | -122.50293405873 | (37.7779752732797, -122.50293405873) | 11 | 6 | 2 | 55 | 26 | |
160882 | 113234 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2023 43RD AVE | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5982877 | 2101339 | 37.7488847374588 | -122.502032899239 | (37.7488847374588, -122.502032899239) | 1 | 8 | 3 | 29491 | 35 | |||
164424 | 47434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 610 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45345 | 5982901.04749 | 2111608.73774 | 37.7770839259349 | -122.50270981679 | (37.7770839259349, -122.50270981679) | 11 | 6 | 2 | 55 | 26 | |
133768 | 47436 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 674 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45347 | 5982919.26774055 | 2111199.0450077 | 37.7759600998145 | -122.502616456458 | (37.7759600998145, -122.502616456458) | 11 | 6 | 2 | 55 | 26 | ||
16230 | 46377 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2247 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 2 | Permit Number 44614 | 5982946.355 | 2099827.607 | 37.7447389446862 | -122.501681271429 | (37.7447389446862, -122.501681271429) | 1 | 8 | 3 | 29491 | 35 | |
17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
156879 | 183683 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4109 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982989.6121 | 2106254.8366 | 37.7623888588818 | -122.50200719073 | (37.7623888588818, -122.50200719073) | 1 | 8 | 3 | 56 | 35 | |||
52029 | 183261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983023.9383 | 2106705.6545 | 37.7636286930826 | -122.501921829451 | (37.7636286930826, -122.501921829451) | 1 | 8 | 3 | 56 | 35 | |||
57501 | 63002 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1247 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23410 | 5983025.611 | 2106604.4545 | 37.7633509249525 | -122.501908555809 | (37.7633509249525, -122.501908555809) | 1 | 8 | 3 | 56 | 35 | ||
78593 | 183308 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1278 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.9761 | 2106448.9537 | 37.7629268049938 | -122.501729774074 | (37.7629268049938, -122.501729774074) | 1 | 8 | 3 | 56 | 35 | |||
135974 | 183307 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1278 42nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983074.8909 | 2106436.1459 | 37.7628916921497 | -122.501725662519 | (37.7628916921497, -122.501725662519) | 1 | 8 | 3 | 56 | 35 | |||
81917 | 117923 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 655 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5983173.6456 | 2111340.41093 | 37.7763631945421 | -122.501746972841 | (37.7763631945421, -122.501746972841) | 11 | 6 | 2 | 55 | 26 | |||
115801 | 109172 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 663 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773586 | 5983176.95596 | 2111290.88937 | 37.7762274171819 | -122.501731856866 | (37.7762274171819, -122.501731856866) | 11 | 6 | 2 | 55 | 26 |
194418 | 265072 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5983517.97374 | 2101348.17171 | 37.7489475550359 | -122.499817124771 | (37.7489475550359, -122.499817124771) | 1 | 8 | 3 | 29491 | 35 | ||||
80744 | 117829 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 886 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5983896.94148 | 2109796.46595 | 37.7721664253666 | -122.499130822703 | (37.7721664253666, -122.499130822703) | 11 | 6 | 2 | 55 | 26 | |||
172730 | 182922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2909 Yorba St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983962.6687 | 2096093.6404 | 37.7345461275096 | -122.497891434487 | (37.7345461275096, -122.497891434487) | 1 | 8 | 3 | 29491 | 35 | |||
9972 | 71995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5984088.02561 | 2113084.30818 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | 11 | 6 | 2 | 55 | 26 | |||
135692 | 34812 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 3 | Permit Number 38704 | 5984089.4315 | 2113048.43592 | 37.7811066852081 | -122.498705269197 | (37.7811066852081, -122.498705269197) | 11 | 6 | 2 | 55 | 26 | |
69770 | 118036 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 470 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 5984100.05848 | 2112686.82371 | 37.7801144265426 | -122.498641785255 | (37.7801144265426, -122.498641785255) | 11 | 6 | 2 | 55 | 26 | |||
116897 | 115168 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775038 | 5984326.9 | 2097810.6 | 37.7392817833273 | -122.496758856311 | (37.7392817833273, -122.496758856311) | 1 | 8 | 3 | 29491 | 35 | |||
62234 | 118082 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 7300 Geary Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5984332.1669 | 2112501.37067 | 37.7796188361138 | -122.497825131328 | (37.7796188361138, -122.497825131328) | 11 | 6 | 2 | 55 | 26 | |||
120030 | 51905 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1438 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 2 | Permit Number 48112 | 5984354.7331 | 2105363.9479 | 37.760022829898 | -122.49722004913 | (37.760022829898, -122.49722004913) | 1 | 8 | 3 | 56 | 35 | ||
185066 | 63216 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 499 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33571 | 5984372.470711 | 2112463.62545386 | 37.7795175613562 | -122.497682917511 | (37.7795175613562, -122.497682917511) | 11 | 6 | 2 | 55 | 26 | ||
67967 | 50251 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48647 | 5984388.5406 | 2104356.2375 | 37.7572579198882 | -122.497028745879 | (37.7572579198882, -122.497028745879) | 1 | 8 | 3 | 56 | 35 | |
108045 | 184563 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1714 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984417.5527 | 2103483.9989 | 37.7548646952585 | -122.496864038241 | (37.7548646952585, -122.496864038241) | 1 | 8 | 3 | 56 | 35 | |||
152500 | 183148 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2331 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984516.3306 | 2099293.7848 | 37.7433653047082 | -122.496213301366 | (37.7433653047082, -122.496213301366) | 1 | 8 | 3 | 29491 | 35 | |||
11199 | 73361 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984617.03994 | 2094708.01424 | 37.730779908566 | -122.495526924733 | (37.730779908566, -122.495526924733) | 1 | 8 | 4 | 64 | 35 | |||
14786 | 69030 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1451 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33036 | 5984623.8069 | 2105296.0559 | 37.7598521830846 | -122.496284456968 | (37.7598521830846, -122.496284456968) | 1 | 8 | 3 | 56 | 35 | |
13657 | 73537 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984627.56608 | 2094712.464 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | 1 | 8 | 4 | 64 | 35 | |||
14619 | 20886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1892X Sunset Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
178971 | 20883 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1892X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
179330 | 20885 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1892X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
127809 | 20930 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1992X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
154979 | 20931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1992X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
170408 | 20928 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1992X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
67241 | 21204 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2392X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
110417 | 21201 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
124016 | 21202 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2392X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
14919 | 78301 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 631 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5985028.23693 | 2111540.90163 | 37.7770224459764 | -122.495346307534 | (37.7770224459764, -122.495346307534) | 11 | 6 | 2 | 55 | 26 | |||
14151 | 69802 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 627 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5985028.72707 | 2111563.88652 | 37.7770855845831 | -122.495346307533 | (37.7770855845831, -122.495346307533) | 11 | 6 | 2 | 55 | 26 | |||
180869 | 118204 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985074.67436 | 2111534.85639 | 37.7770085663204 | -122.495185222531 | (37.7770085663204, -122.495185222531) | 11 | 6 | 2 | 55 | 26 | |||
18803 | 181711 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3403 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985126.2438 | 2107009.2181 | 37.7645854668325 | -122.494673101587 | (37.7645854668325, -122.494673101587) | 1 | 8 | 3 | 56 | 35 | |||
170925 | 50241 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 3 | Permit Number 46947 | 5985192.564 | 2106818.2406 | 37.7640649777407 | -122.49442964224 | (37.7640649777407, -122.49442964224) | 1 | 8 | 3 | 56 | 35 | |
85801 | 50242 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 3 | Permit Number 46947 | 5985193.178 | 2106799.8183 | 37.7640144312015 | -122.494426160535 | (37.7640144312015, -122.494426160535) | 1 | 8 | 3 | 56 | 35 | |
150114 | 92539 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1351 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52884 | 5985220.6535 | 2106008.9529 | 37.7618445439072 | -122.494272834312 | (37.7618445439072, -122.494272834312) | 1 | 8 | 3 | 56 | 35 | |
142611 | 50243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1242 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 6 | Permit Number 46948 | 5985238.0051 | 2106741.9575 | 37.7638581850069 | -122.494266853954 | (37.7638581850069, -122.494266853954) | 1 | 8 | 3 | 56 | 35 | |
180916 | 50245 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1282 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 2 | Permit Number 46950 | 5985245.6795 | 2106487.522 | 37.7631600254306 | -122.494221555939 | (37.7631600254306, -122.494221555939) | 1 | 8 | 3 | 56 | 35 | |
124957 | 43852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2708 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51148 | 5985261.6386 | 2096783.5367 | 37.7365164666592 | -122.49345134135 | (37.7365164666592, -122.49345134135) | 1 | 8 | 3 | 29491 | 35 | |
17566 | 89252 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 433 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:00:00 AM | 3 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.49227 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | 11 | 6 | 2 | 55 | 26 | ||
193288 | 55802 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2379 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51126 | 5985455.6616 | 2099044.0741 | 37.7427346444375 | -122.4929469922 | (37.7427346444375, -122.4929469922) | 1 | 8 | 3 | 29491 | 35 | |
65576 | 33160 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2447 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 3 | Permit Number 37383 | 5985473.2595 | 2098547.6093 | 37.7413725147529 | -122.492849584664 | (37.7413725147529, -122.492849584664) | 1 | 8 | 3 | 29491 | 35 | |
80638 | 33161 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2447 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 2 | Permit Number 37383 | 5985473.9364 | 2098563.1767 | 37.7414152982347 | -122.492848390582 | (37.7414152982347, -122.492848390582) | 1 | 8 | 3 | 29491 | 35 | |
76104 | 183797 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985521.5211 | 2099591.0086 | 37.7442402304398 | -122.492759546804 | (37.7442402304398, -122.492759546804) | 1 | 8 | 3 | 29491 | 35 | |||
42314 | 177337 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 Morningside Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5985552.21468 | 2094749.49981 | 37.730948533249 | -122.492296977222 | (37.730948533249, -122.492296977222) | 1 | 8 | 4 | 64 | 35 | |||
143991 | 49461 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1519@ KIRKHAM 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 4 | Permit Number 46391 | 5985568.6393 | 2104859.6745 | 37.758709302234 | -122.492984645694 | (37.758709302234, -122.492984645694) | 1 | 8 | 3 | 56 | 35 | ||
161996 | 182433 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1551 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985573.1425 | 2104667.8354 | 37.7581828284958 | -122.492954940886 | (37.7581828284958, -122.492954940886) | 1 | 8 | 3 | 56 | 35 | |||
79474 | 182434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1551 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985575.3942 | 2104648.4714 | 37.7581297919874 | -122.492945727305 | (37.7581297919874, -122.492945727305) | 1 | 8 | 3 | 56 | 35 |
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) );