trees
1,746 rows where qSpecies_id = 10 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13 | 264822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | ||||||||||||
16 | 264823 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | ||||||||||||
91 | 260225 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
566 | 260237 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
1944 | 260235 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
2034 | 260230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
3589 | 254266 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
5794 | 255199 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
5942 | 37366 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
6785 | 255190 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7375 | 260231 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
9925 | 255197 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10071 | 255198 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10131 | 255195 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10267 | 255196 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11957 | 260232 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
12198 | 260226 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
12500 | 255191 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
13119 | 42922 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42829 | ||||||||||||||
13782 | 50191 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46897 | |||||||||||||
14989 | 37365 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
14990 | 260236 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
15383 | 260234 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
15406 | 255194 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16307 | 254265 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
16476 | 260228 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
16501 | 255192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16625 | 259862 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300x Brussels St | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
16807 | 255193 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18477 | 260227 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
19341 | 260229 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
19612 | 260233 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
175310 | 118388 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5640 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981070.64921 | 2111666.32883 | 37.7771343173465 | -122.509045901305 | (37.7771343173465, -122.509045901305) | 11 | 6 | 2 | 55 | 26 | |||
12383 | 118387 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5640 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5981104.69221 | 2111668.01683 | 37.7771409589636 | -122.508928263307 | (37.7771409589636, -122.508928263307) | 11 | 6 | 2 | 55 | 26 | |||
159974 | 187630 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/23/2015 05:35:00 PM | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | ||
88506 | 109134 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 833 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773415 | 5981360.00156 | 2110051.11927 | 37.7727164806439 | -122.507925058041 | (37.7727164806439, -122.507925058041) | 11 | 6 | 2 | 55 | 26 |
102103 | 837 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4255X Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 05:35:00 PM | 3 | 3X3 | 5981362.6566223 | 2105522.5911084 | 37.7602826110734 | -122.507579790995 | (37.7602826110734, -122.507579790995) | 1 | 8 | 3 | 56 | 35 | ||
145274 | 30869 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1487 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 10 | Permit Number 34704 | 5981530.1892 | 2104969.8095 | 37.7587746987585 | -122.506959379593 | (37.7587746987585, -122.506959379593) | 1 | 8 | 3 | 56 | 35 | ||
167009 | 31937 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1334 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 13 | Permit Number 35352 | 5981537.7523 | 2105991.1857 | 37.761579550806 | -122.507008988658 | (37.761579550806, -122.507008988658) | 1 | 8 | 3 | 56 | 35 | |
127908 | 31936 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1334 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 9 | Permit Number 35352 | 5981539.5189 | 2105974.0494 | 37.7615326034839 | -122.507001607611 | (37.7615326034839, -122.507001607611) | 1 | 8 | 3 | 56 | 35 | |
57952 | 31939 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1370 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35354 | 5981544.9955 | 2105760.2879 | 37.7609459982399 | -122.506966809632 | (37.7609459982399, -122.506966809632) | 1 | 8 | 3 | 56 | 35 | |
43556 | 115180 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2019 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775162 | 5981635.3 | 2101323.4 | 37.7487688795742 | -122.506325467188 | (37.7487688795742, -122.506325467188) | 1 | 8 | 3 | 29491 | 35 | |||
18315 | 261539 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 723 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5981936 | 2110809 | 37.7748313206063 | -122.505988851899 | (37.7748313206063, -122.505988851899) | 11 | 6 | 2 | 55 | 26 | ||
132585 | 108666 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 687 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.67768 | 37.7755749935311 | -122.505981228635 | (37.7755749935311, -122.505981228635) | 11 | 6 | 2 | 55 | 26 | |
103734 | 67259 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 598 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 12 | Permit Number 30726 | 5981962.87368 | 2111727.52609 | 37.7773549056891 | -122.505964007009 | (37.7773549056891, -122.505964007009) | 11 | 6 | 2 | 55 | 26 | |
677 | 144274 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 668 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981986.54358 | 2111243.64346 | 37.77602769926 | -122.505846244117 | (37.77602769926, -122.505846244117) | 11 | 6 | 2 | 55 | 26 | ||
130163 | 46417 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1261 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 8 | Permit Number 44642 | 5982096.4112 | 2106511.6182 | 37.763041394868 | -122.505115419379 | (37.763041394868, -122.505115419379) | 1 | 8 | 3 | 56 | 35 | ||
6560 | 118741 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 616 44th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5982283.91795 | 2111534.27882 | 37.7768431974954 | -122.504839106088 | (37.7768431974954, -122.504839106088) | 11 | 6 | 2 | 55 | 26 | |||
186464 | 104419 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 622 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5982284.66916 | 2111506.09662 | 37.7767658616231 | -122.504834418682 | (37.7767658616231, -122.504834418682) | 11 | 6 | 2 | 55 | 26 | ||||
100680 | 68551 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 616 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 12 | Permit Number 32440 | 5982284.92923 | 2111518.2345 | 37.7767992039857 | -122.504834418664 | (37.7767992039857, -122.504834418664) | 11 | 6 | 2 | 55 | 26 | |
4677 | 104420 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.7767441147601 | -122.504756894571 | (37.7767441147601, -122.504756894571) | 11 | 6 | 2 | 55 | 26 | ||||
17795 | 144230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 696 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:47:00 PM | 0 | Width 4ft | 5982610.26029 | 2111073.90375 | 37.7755983350405 | -122.503676106264 | (37.7755983350405, -122.503676106264) | 11 | 6 | 2 | 55 | 26 | ||
4719 | 144225 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 790 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982634.037 | 2110415.4626 | 37.7737918452551 | -122.503545088531 | (37.7737918452551, -122.503545088531) | 11 | 6 | 2 | 55 | 26 | ||
16295 | 69167 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1357 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33204 | 5982738.1126 | 2105902.9753 | 37.7614079699737 | -122.502850971641 | (37.7614079699737, -122.502850971641) | 1 | 8 | 3 | 56 | 35 | |
1711 | 261518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 515 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | Width 3ft | 5982833.25943 | 2112233.81526 | 37.7787962221578 | -122.50299059962 | (37.7787962221578, -122.50299059962) | 11 | 6 | 2 | 55 | 26 | |||
96300 | 46373 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1783 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 3 | Permit Number 44610 | 5982837.4613 | 2103013.2542 | 37.7534794493994 | -122.502293509119 | (37.7534794493994, -122.502293509119) | 1 | 8 | 3 | 56 | 35 | |
181953 | 117826 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 639 40th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5983481.30251 | 2111445.18055 | 37.7766689280385 | -122.500690467806 | (37.7766689280385, -122.500690467806) | 11 | 6 | 2 | 55 | 26 | |||
26714 | 184921 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983531.9028 | 2102160.6005 | 37.7511790768162 | -122.499829000947 | (37.7511790768162, -122.499829000947) | 1 | 8 | 3 | 29491 | 35 | |||
78211 | 29229 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
112968 | 29239 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
152791 | 29234 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
160544 | 184917 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 36 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983534.6102 | 2102074.9798 | 37.7509441450099 | -122.49981331072 | (37.7509441450099, -122.49981331072) | 1 | 8 | 3 | 29491 | 35 | |||
16035 | 184914 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983535.9639 | 2102008.3107 | 37.7507611695923 | -122.499803702352 | (37.7507611695923, -122.499803702352) | 1 | 8 | 3 | 29491 | 35 | |||
22298 | 39806 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
31648 | 39798 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
37238 | 39807 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
79548 | 39805 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
170543 | 39799 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
169605 | 41348 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1383 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 42001 | 5983671.8376464 | 2105751.17864295 | 37.7610460110157 | -122.499610437774 | (37.7610460110157, -122.499610437774) | 1 | 8 | 3 | 56 | 35 | |||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
37131 | 43045 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2222 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 4 | Permit Number 42899 | 5984225.3291 | 2100029.5584 | 37.7453684881571 | -122.497273797993 | (37.7453684881571, -122.497273797993) | 1 | 8 | 3 | 29491 | 35 | |
9960 | 39843 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
58457 | 39851 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
93386 | 39842 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
95668 | 39850 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
116386 | 39844 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
123172 | 39837 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
142083 | 39853 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
157620 | 39847 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
160122 | 39848 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
162085 | 39852 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
168755 | 39845 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
173960 | 39846 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
186679 | 39849 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
35994 | 66532 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3722 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1991 12:00:00 AM | 18 | 3x3 | Permit Number 29707 | 5984457.3026 | 2098196.9463 | 37.7403502256776 | -122.496336488295 | (37.7403502256776, -122.496336488295) | 1 | 8 | 3 | 29491 | 35 | |
2587 | 62602 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 790 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22910 | 5984500.58062 | 2110524.76974 | 37.774201531153 | -122.49709658414 | (37.774201531153, -122.49709658414) | 11 | 6 | 2 | 55 | 26 | |
63697 | 256906 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2821 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782747 | 5984938.23332 | 2096099.36709 | 37.7346189965322 | -122.4945190539 | (37.7346189965322, -122.4945190539) | 1 | 8 | 3 | 29491 | 35 | |
7061 | 259664 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1850 36th Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5985092 | 2102600 | 37.7524769742467 | -122.494466484126 | (37.7524769742467, -122.494466484126) | 1 | 8 | 3 | 56 | 35 | ||||
37389 | 47209 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 459 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52407 | 5985293.07018 | 2112783.3768 | 37.780449428341 | -122.494521796048 | (37.780449428341, -122.494521796048) | 11 | 6 | 2 | 55 | 26 | |
71609 | 96073 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767699 | 5985419.194 | 2110615.45577 | 37.7745043190564 | -122.493925666827 | (37.7745043190564, -122.493925666827) | 11 | 6 | 2 | 55 | 26 |
113570 | 115271 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1735 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775651 | 5985600.1 | 2103401.6 | 37.7547076715681 | -122.492768449756 | (37.7547076715681, -122.492768449756) | 1 | 8 | 3 | 56 | 35 | ||
59118 | 115272 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1938 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775650 | 5985734.3 | 2102018.9 | 37.7509190021287 | -122.49220255028 | (37.7509190021287, -122.49220255028) | 1 | 8 | 3 | 29491 | 35 | ||
96942 | 33176 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3245 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | 3.5x6 | Permit Number 37389 | 5985863.4598 | 2098187.5285 | 37.74040663959 | -122.491473929368 | (37.74040663959, -122.491473929368) | 1 | 8 | 3 | 29491 | 35 |
165552 | 96684 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 375@32nd Ave 32nd Ave | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985882.68379 | 2113417.37347 | 37.7822246913621 | -122.492528778473 | (37.7822246913621, -122.492528778473) | 11 | 6 | 2 | 55 | 26 | ||
93312 | 96685 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 375@32nd Ave 32nd Ave | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985883.85851 | 2113362.06041 | 37.7820728863047 | -122.492520639753 | (37.7820728863047, -122.492520639753) | 11 | 6 | 2 | 55 | 26 | ||
125780 | 119410 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.7818078699582 | -122.492500292921 | (37.7818078699582, -122.492500292921) | 11 | 6 | 2 | 55 | 26 | |||
50012 | 96691 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
54824 | 96690 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
63309 | 96689 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 |
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) );