Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 5259 | 5259 | 42922 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 5550 | 5550 | 37365 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 12187 | 12187 | 50191 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46897 | ||||||||
| 75998 | 75998 | 118388 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981070.6492099995 | 2111666.32883 | 37.7771343173465 | -122.50904590130502 | (37.7771343173465, -122.509045901305) | |||
| 38238 | 38238 | 118387 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981104.69221 | 2111668.01683 | 37.7771409589636 | -122.508928263307 | (37.7771409589636, -122.508928263307) | |||
| 104785 | 104785 | 109134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 833 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773415 | 5981360.00156 | 2110051.11927 | 37.77271648064389 | -122.507925058041 | (37.7727164806439, -122.507925058041) |
| 13274 | 13274 | 187630 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2015 05:35:00 PM | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | ||
| 98682 | 98682 | 837 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4255X Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:35:00 PM | 3 | 3X3 | 5981362.6566223 | 2105522.5911084 | 37.7602826110734 | -122.50757979099501 | (37.7602826110734, -122.507579790995) | ||
| 186773 | 186773 | 31937 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1334 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 13 | Permit Number 35352 | 5981537.7523 | 2105991.1857 | 37.761579550806 | -122.50700898865801 | (37.761579550806, -122.507008988658) | |
| 52236 | 52236 | 31936 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1334 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35352 | 5981539.5189 | 2105974.0494 | 37.76153260348389 | -122.507001607611 | (37.7615326034839, -122.507001607611) | |
| 26194 | 26194 | 31939 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1370 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35354 | 5981544.9955 | 2105760.2879 | 37.7609459982399 | -122.50696680963199 | (37.7609459982399, -122.506966809632) | |
| 152804 | 152804 | 30869 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1487 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 10 | Permit Number 34704 | 5981530.1892 | 2104969.8095 | 37.7587746987585 | -122.50695937959298 | (37.7587746987585, -122.506959379593) | ||
| 96941 | 96941 | 115180 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2019 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775162 | 5981635.3 | 2101323.4 | 37.7487688795742 | -122.50632546718799 | (37.7487688795742, -122.506325467188) | |||
| 104720 | 104720 | 108666 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 687 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.6776799997 | 37.7755749935311 | -122.50598122863501 | (37.7755749935311, -122.505981228635) | |
| 172125 | 172125 | 67259 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 598 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 12 | Permit Number 30726 | 5981962.87368 | 2111727.5260900003 | 37.7773549056891 | -122.50596400700898 | (37.7773549056891, -122.505964007009) | |
| 65184 | 65184 | 46417 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1261 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 8 | Permit Number 44642 | 5982096.4112 | 2106511.6182 | 37.763041394868004 | -122.50511541937901 | (37.763041394868, -122.505115419379) | ||
| 134491 | 134491 | 118741 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 616 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5982283.91795 | 2111534.27882 | 37.776843197495396 | -122.50483910608801 | (37.7768431974954, -122.504839106088) | |||
| 72319 | 72319 | 104419 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 622 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5982284.66916 | 2111506.09662 | 37.776765861623105 | -122.50483441868201 | (37.7767658616231, -122.504834418682) | ||||
| 47925 | 47925 | 68551 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 616 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 12 | Permit Number 32440 | 5982284.92923 | 2111518.2345 | 37.7767992039857 | -122.504834418664 | (37.7767992039857, -122.504834418664) | |
| 30543 | 30543 | 104420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.776744114760106 | -122.504756894571 | (37.7767441147601, -122.504756894571) | ||||
| 150535 | 150535 | 69167 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1357 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 8 | Permit Number 33204 | 5982738.1126 | 2105902.9753 | 37.7614079699737 | -122.50285097164101 | (37.7614079699737, -122.502850971641) | |
| 133888 | 133888 | 46373 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1783 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 3 | Permit Number 44610 | 5982837.4613 | 2103013.2542 | 37.7534794493994 | -122.502293509119 | (37.7534794493994, -122.502293509119) | |
| 178880 | 178880 | 117826 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 639 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5983481.30251 | 2111445.18055 | 37.776668928038504 | -122.500690467806 | (37.7766689280385, -122.500690467806) | |||
| 45556 | 45556 | 184921 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1990 41st Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983531.9028 | 2102160.6005 | 37.7511790768162 | -122.499829000947 | (37.7511790768162, -122.499829000947) | |||
| 95296 | 95296 | 29229 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1902X 41st Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 98384 | 98384 | 29239 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1902X 41st Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 122613 | 122613 | 29234 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1902X 41st Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 50225 | 50225 | 184917 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1990 41st Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983534.6102 | 2102074.9798 | 37.750944145009896 | -122.49981331071999 | (37.7509441450099, -122.49981331072) | |||
| 72603 | 72603 | 184914 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1990 41st Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983535.9639 | 2102008.3107 | 37.750761169592295 | -122.49980370235201 | (37.7507611695923, -122.499803702352) | |||
| 93871 | 93871 | 39805 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 119161 | 119161 | 39799 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 125083 | 125083 | 39806 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 127510 | 127510 | 39798 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 128751 | 128751 | 39807 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 37227 | 37227 | 184909 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1990 41st Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983540.025 | 2101883.0946 | 37.750417599209996 | -122.4997804049 | (37.75041759921, -122.4997804049) | |||
| 121172 | 121172 | 41348 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1383 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 42001 | 5983671.837646401 | 2105751.17864295 | 37.7610460110157 | -122.499610437774 | (37.7610460110157, -122.499610437774) | |||
| 89194 | 89194 | 99308 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.49918869137501 | (37.7494969779561, -122.499188691375) | ||
| 167265 | 167265 | 43045 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2222 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 4 | Permit Number 42899 | 5984225.3291 | 2100029.5584 | 37.7453684881571 | -122.49727379799299 | (37.7453684881571, -122.497273797993) | |
| 42982 | 42982 | 39843 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 85252 | 85252 | 39851 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 95179 | 95179 | 39842 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 102727 | 102727 | 39850 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 106014 | 106014 | 39837 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 109994 | 109994 | 39844 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 110840 | 110840 | 39853 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 117898 | 117898 | 39848 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 118740 | 118740 | 39847 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 119920 | 119920 | 39852 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 122106 | 122106 | 39845 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 142053 | 142053 | 39846 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 144100 | 144100 | 39849 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 41221 | 41221 | 62602 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 790 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22910 | 5984500.58062 | 2110524.7697400004 | 37.774201531153004 | -122.49709658414 | (37.774201531153, -122.49709658414) | |
| 12523 | 12523 | 66532 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3722 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 18 | 3x3 | Permit Number 29707 | 5984457.3026 | 2098196.9463 | 37.7403502256776 | -122.496336488295 | (37.7403502256776, -122.496336488295) | |
| 160033 | 160033 | 47209 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 459 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52407 | 5985293.070180001 | 2112783.3768 | 37.780449428341 | -122.49452179604799 | (37.780449428341, -122.494521796048) | |
| 61683 | 61683 | 96073 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767699 | 5985419.194 | 2110615.45577 | 37.7745043190564 | -122.493925666827 | (37.7745043190564, -122.493925666827) |
| 183792 | 183792 | 115271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1735 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775651 | 5985600.1 | 2103401.6 | 37.754707671568106 | -122.492768449756 | (37.7547076715681, -122.492768449756) | ||
| 30854 | 30854 | 96684 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985882.68379 | 2113417.37347 | 37.7822246913621 | -122.492528778473 | (37.7822246913621, -122.492528778473) | ||
| 186807 | 186807 | 96685 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985883.85851 | 2113362.06041 | 37.782072886304704 | -122.492520639753 | (37.7820728863047, -122.492520639753) | ||
| 74642 | 74642 | 119410 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.78180786995821 | -122.49250029292101 | (37.7818078699582, -122.492500292921) | |||
| 81323 | 81323 | 96690 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 83262 | 83262 | 96691 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 89617 | 89617 | 96689 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 96958 | 96958 | 96688 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 59874 | 59874 | 115272 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1938 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775650 | 5985734.3 | 2102018.9 | 37.750919002128704 | -122.49220255028 | (37.7509190021287, -122.49220255028) | ||
| 34713 | 34713 | 33176 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3245 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 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) |
| 38461 | 38461 | 72501 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3245 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1996 12:00:00 AM | 8 | 3.5x5 | 5985932.8363 | 2098188.2054 | 37.74041255212379 | -122.491234105912 | (37.7404125521238, -122.491234105912) | |
| 118974 | 118974 | 33175 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3245 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2012 12:00:00 AM | 3x3 | Permit Number 768714 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) | ||
| 187906 | 187906 | 119504 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 751 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986297.2178 | 2110799.61932 | 37.7750613132821 | -122.490902009459 | (37.7750613132821, -122.490902009459) | |||
| 59220 | 59220 | 42875 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2514 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42799 | 5986155.7749 | 2098104.3113 | 37.7401952251885 | -122.490457112219 | (37.7401952251885, -122.490457112219) | |
| 63689 | 63689 | 78931 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2701 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 6 | 5986423.7343 | 2105012.1654 | 37.75917797058621 | -122.49003859224301 | (37.7591779705862, -122.490038592243) | ||
| 69944 | 69944 | 78930 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2701 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 6 | 5986452.1466 | 2105013.3251 | 37.7591828139052 | -122.48994041552 | (37.7591828139052, -122.48994041552) | ||
| 129537 | 129537 | 183575 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2016 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986696.5899 | 2097592.9419 | 37.7388227133187 | -122.488549642302 | (37.7388227133187, -122.488549642302) | |||
| 144855 | 144855 | 42859 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2599 31st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2000 12:00:00 AM | Permit Number 42787 | 5986745.41813509 | 2097587.07290157 | 37.7388094476944 | -122.488380388139 | (37.7388094476944, -122.488380388139) | |||
| 164938 | 164938 | 250939 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987146.614630001 | 2114364.81328 | 37.7848999087463 | -122.488225846149 | (37.7848999087463, -122.488225846149) | |||
| 80961 | 80961 | 104879 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
| 115865 | 115865 | 104878 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
| 55705 | 55705 | 56920 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1215 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 6 | Permit Number 775369 | 5987049.1527 | 2106973.4458 | 37.764599608453004 | -122.488019735539 | (37.764599608453, -122.488019735539) | ||
| 83018 | 83018 | 30859 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1256 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34699 | 5987105.97158028 | 2106720.29614463 | 37.7639078438446 | -122.48780461650401 | (37.7639078438446, -122.487804616504) | |||
| 22679 | 22679 | 9226 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 6332 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987316.8892 | 2112613.5319 | 37.7801013217352 | -122.487508066232 | (37.7801013217352, -122.487508066232) | |||
| 88135 | 88135 | 42271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 95450 | 95450 | 42270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 98258 | 98258 | 42272 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 102055 | 102055 | 42269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 133321 | 133321 | 182293 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2471 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987174.7926 | 2105038.9232 | 37.7592952697891 | -122.487443071965 | (37.7592952697891, -122.487443071965) | |||
| 33090 | 33090 | 182294 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2461 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987213.1035 | 2105040.2293 | 37.7593010901644 | -122.487310671955 | (37.7593010901644, -122.487310671955) | |||
| 44225 | 44225 | 33255 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37433 | 5987086.6782 | 2098088.9597 | 37.740207401723396 | -122.48723733917299 | (37.7402074017234, -122.487237339173) | |
| 83633 | 83633 | 33254 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2518 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37432 | 5987089.34275763 | 2098119.32468859 | 37.7402909313254 | -122.487230356038 | (37.7402909313254, -122.487230356038) | ||
| 48478 | 48478 | 182295 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2451 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987239.2246 | 2105041.5354 | 37.759306199580294 | -122.487220429623 | (37.7593061995803, -122.487220429623) | |||
| 133175 | 133175 | 120049 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 303 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5987427.70616 | 2113860.74401 | 37.7835322738524 | -122.48721633683701 | (37.7835322738524, -122.487216336837) | |||
| 44911 | 44911 | 67700 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 16 | Permit Number 31310 | 5987428.34051 | 2113876.38168 | 37.7835752474242 | -122.4872152912 | (37.7835752474242, -122.4872152912) | ||
| 76188 | 76188 | 87826 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 303 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50717 | 5987430.26293 | 2113824.57227 | 37.7834331056608 | -122.487204833897 | (37.7834331056608, -122.487204833897) | |
| 134178 | 134178 | 42895 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1855 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42812 | 5987077.2623 | 2096876.2879 | 37.7368771758363 | -122.487180850437 | (37.7368771758363, -122.487180850437) | |
| 46898 | 46898 | 182296 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2441 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987257.074 | 2105042.4061 | 37.7593096311122 | -122.487158762484 | (37.7593096311122, -122.487158762484) | |||
| 85210 | 85210 | 31613 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 367 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | Permit Number 35134 | 5987438.17691479 | 2113501.64932662 | 37.782546912742504 | -122.48715372973 | (37.7825469127425, -122.48715372973) | |||
| 58104 | 58104 | 34017 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 323 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | 12 | Permit Number 37952 | 5987592.7116 | 2115291.45684 | 37.787470222719605 | -122.48675058279801 | (37.7874702227196, -122.486750582798) | ||
| 108013 | 108013 | 32126 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2235 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35488 | 5987281.75836178 | 2100063.48060061 | 37.7456402857361 | -122.486707790985 | (37.7456402857361, -122.486707790985) | |||
| 58183 | 58183 | 34018 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 323 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | 7 | Permit Number 37952 | 5987618.80889 | 2115290.48543 | 37.787469076903896 | -122.486660221281 | (37.7874690769039, -122.486660221281) | ||
| 32765 | 32765 | 70201 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | ||
| 174078 | 174078 | 119938 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2500 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5987749.91083 | 2111234.09886 | 37.77633903201821 | -122.48590878771401 | (37.7763390320182, -122.485908787714) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");