trees
144 rows where SiteOrder = 2 and qSpecies_id = 97 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
3331 | 250313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 772728 | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.458160192637 | (37.7895320612144, -122.458160192637) | 11 | 6 | 1 | 54 | 31 | ||
3343 | 23100 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6006427.47457 | 2101357.75439 | 37.7502916230775 | -122.420596517121 | (37.7502916230775, -122.420596517121) | 2 | 4 | 5 | 28859 | 19 | |||
3962 | 224532 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.414869623533 | (37.7523850181574, -122.414869623533) | 2 | 4 | 7 | 28859 | 19 | |||
4293 | 641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | 2 | 4 | 7 | 28859 | 19 | |||
4358 | 224705 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | 2 | 4 | 7 | 28859 | 19 | |||
5854 | 224657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007803.71411 | 2097712.06394 | 37.7403588367925 | -122.415579287554 | (37.7403588367925, -122.415579287554) | 2 | 7 | 7 | 28859 | 2 | |||
6967 | 224529 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3035 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6008772.64154 | 2102127.57906 | 37.7525372787939 | -122.412541157349 | (37.7525372787939, -122.412541157349) | 2 | 4 | 7 | 28859 | 19 | |||
7669 | 101056 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
8038 | 250803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | 11 | 6 | 1 | 55 | 33 | |||
8711 | 224685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | 2 | 4 | 5 | 28859 | 19 | |||
9655 | 587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3045 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.412706471622 | (37.7525282406021, -122.412706471622) | 2 | 4 | 7 | 28859 | 19 | |||
10134 | 224679 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007366.73942 | 2101988.35955 | 37.7520760119996 | -122.417393153575 | (37.7520760119996, -122.417393153575) | 2 | 4 | 7 | 28859 | 19 | |||
11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 2 | 4 | 7 | 28859 | 19 | ||
11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
13764 | 224696 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.7524624264182 | -122.415583660969 | (37.7524624264182, -122.415583660969) | 2 | 4 | 7 | 28859 | 19 | |||
15993 | 226468 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
18655 | 124424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.7884130822591 | -122.457294185036 | (37.7884130822591, -122.457294185036) | 11 | 6 | 1 | 54 | 31 | |||
19051 | 224694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008827.83828 | 2102168.91217 | 37.7526538678042 | -122.412353198162 | (37.7526538678042, -122.412353198162) | 2 | 4 | 7 | 28859 | 19 | |||
19967 | 101427 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
25118 | 224700 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | 2 | 4 | 7 | 28859 | 19 | |||
25618 | 101054 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
26923 | 101895 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011780 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | 3 | 1 | 10 | 28860 | 4 | ||||
27007 | 224588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008276.68417 | 2106776.83741 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | 8 | 4 | 7 | 28859 | 19 | |||
27124 | 33817 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
27423 | 121150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |||
27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
27917 | 101249 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993518 | 2106670 | 37.764141669108 | -122.465623861668 | (37.764141669108, -122.465623861668) | 11 | 8 | 11 | 56 | 12 | ||||
29430 | 114806 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
30050 | 104403 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 3x3 | Permit Number 24809 | 6002031 | 2107070 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | 15 | 5 | 5 | 28862 | 3 | |
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
32503 | 176413 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001088.39895 | 2089005.35886 | 37.7160724587542 | -122.4381745822 | (37.7160724587542, -122.4381745822) | 9 | 7 | 6 | 28861 | 5 | |||
32764 | 224689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | 2 | 4 | 5 | 28859 | 19 | |||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
34968 | 258294 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
38079 | 53067 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | 13 | 6 | 11 | 29490 | 13 | |||
38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
38823 | 218811 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127697 | (37.7202851197392, -122.45207127697) | 9 | 8 | 6 | 28861 | 24 | |||
39200 | 111610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.7183345981422 | -122.403290521257 | (37.7183345981422, -122.403290521257) | 10 | 7 | 8 | 309 | 39 | |||
39540 | 251008 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995662.21487 | 2115838.76904 | 37.7894401289022 | -122.458871565395 | (37.7894401289022, -122.458871565395) | 11 | 6 | 1 | 54 | 31 | |||
40301 | 218803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.469130812732 | (37.7439598068059, -122.469130812732) | 1 | 8 | 4 | 29491 | 40 | |||
40635 | 24450 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.420651186023 | (37.7507621663522, -122.420651186023) | 2 | 4 | 5 | 28859 | 19 | |||
40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
42896 | 249545 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6006121.63422 | 2114038.60368 | 37.7850929805917 | -122.422555115551 | (37.7850929805917, -122.422555115551) | 13 | 9 | 11 | 28858 | 41 | |||
43482 | 101285 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | 11 | 8 | 11 | 56 | 12 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
46826 | 110117 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 2 | 4 | 7 | 28859 | 19 | |||
50896 | 226475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008399.69622 | 2105072.76604 | 37.7606031552393 | -122.414039206643 | (37.7606031552393, -122.414039206643) | 2 | 4 | 7 | 28859 | 19 | |||
53715 | 108962 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
55915 | 224624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | 15 | 5 | 5 | 28862 | 12 | |||
57015 | 224709 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006609.60192 | 2103216.71936 | 37.7554061772577 | -122.420098619173 | (37.7554061772577, -122.420098619173) | 2 | 4 | 7 | 28859 | 19 | |||
57933 | 224547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | 2 | 4 | 7 | 28859 | 19 | |||
59306 | 176406 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.7130548079177 | -122.446884509935 | (37.7130548079177, -122.446884509935) | 9 | 7 | 6 | 28861 | 25 | |||
60674 | 30533 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
66175 | 99115 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
66528 | 115675 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | 11 | 6 | 2 | 55 | 26 | |||||
70716 | 224492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998346.42262 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | 15 | 5 | 11 | 29492 | 9 | |||
71962 | 199434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014431.27107 | 2095902.06527 | 37.7357592658851 | -122.392537062245 | (37.7357592658851, -122.392537062245) | 10 | 3 | 8 | 58 | 1 | |||
75846 | 32047 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
78159 | 244052 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | 15 | 5 | 11 | 29492 | 9 | |||
78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
79230 | 103152 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
86121 | 224493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | 15 | 5 | 5 | 29492 | 9 | |||
86489 | 126619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996924.84901 | 2116015.00596 | 37.789996524161 | -122.454515752993 | (37.789996524161, -122.454515752993) | 11 | 6 | 1 | 54 | 31 | |||
93302 | 97189 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
94913 | 98531 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
97647 | 602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | 2 | 4 | 7 | 28859 | 19 | |||
98693 | 218808 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | 9 | 7 | 4 | 28861 | 40 | ||||
99319 | 176423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009799.11271 | 2092612.10018 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | 10 | 3 | 7 | 309 | 28 | |||
101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
107337 | 224631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 667 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007655.79797 | 2096256.88725 | 37.7363549264252 | -122.415987700275 | (37.7363549264252, -122.415987700275) | 2 | 7 | 7 | 28859 | 2 | |||
107742 | 121142 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
108921 | 571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.00613 | 2102184.08314 | 37.7527082129358 | -122.411572138748 | (37.7527082129358, -122.411572138748) | 2 | 4 | 7 | 28859 | 19 | ||
111591 | 224669 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.7589657361945 | -122.410724513338 | (37.7589657361945, -122.410724513338) | 2 | 4 | 7 | 28859 | 19 | |||
114821 | 92018 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4182 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001163 | 2105841 | 37.7623034284238 | -122.439122658321 | (37.7623034284238, -122.439122658321) | 15 | 5 | 5 | 28862 | 3 | ||||
118175 | 26002 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | 10 | 3 | 8 | 58 | 1 | |||
118466 | 116773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||||
118944 | 592 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3050 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008558.83929 | 2102157.76802 | 37.752608169649 | -122.413282659187 | (37.752608169649, -122.413282659187) | 2 | 4 | 7 | 28859 | 19 | |||
120892 | 176426 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.7193747846049 | -122.400580899003 | (37.7193747846049, -122.400580899003) | 10 | 7 | 8 | 309 | 28 | |||
120941 | 218832 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | 1 | 8 | 4 | 29491 | 40 | |||
121030 | 101519 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | 3 | 1 | 10 | 308 | 23 | |||
122708 | 224543 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006596.43863 | 2103760.05569 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | 2 | 4 | 7 | 28859 | 19 | |||
123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
124277 | 176402 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998803.89987 | 2087884.30754 | 37.7128641138726 | -122.445990279822 | (37.7128641138726, -122.445990279822) | 9 | 7 | 6 | 28861 | 25 | |||
125218 | 99176 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 300x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008712 | 2122248 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | 3 | 1 | 10 | 308 | 23 | ||||
125743 | 35237 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.14978 | 2119525.96271 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | 5 | 1 | 1 | 28858 | 32 | |
126375 | 48039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
127341 | 224575 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008614.79517 | 2105624.76629 | 37.7621309001374 | -122.413334311737 | (37.7621309001374, -122.413334311737) | 2 | 4 | 7 | 28859 | 19 | |||
127460 | 24447 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006347.02184 | 2102851.32539 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | 2 | 4 | 5 | 28859 | 19 | |||
127886 | 34148 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
129070 | 224489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998519.39636 | 2106289.88206 | 37.7633851666273 | -122.448298178534 | (37.7633851666273, -122.448298178534) | 15 | 5 | 11 | 29492 | 9 | |||
129082 | 126622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5998235.51312 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | 13 | 6 | 1 | 54 | 31 |
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) );