Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78372 | 78372 | 38127 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2601 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40291 | 5987686.55551532 | 2107103.11265871 | 37.7649928008384 | -122.485824675941 | (37.7649928008384, -122.485824675941) | ||
| 155913 | 155913 | 46684 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1507 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 7 | Permit Number 44813 | 5988045.9304 | 2105005.4012 | 37.7592539929409 | -122.484427833563 | (37.7592539929409, -122.484427833563) | |
| 55773 | 55773 | 46683 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1507 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 6 | Permit Number 44813 | 5988046.3658 | 2105023.2506 | 37.7593030278965 | -122.484427636933 | (37.7593030278965, -122.484427636933) | |
| 149089 | 149089 | 44803 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1559 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 10 | Permit Number 43897 | 5988058.1203 | 2104685.418 | 37.7583761157648 | -122.484362206936 | (37.7583761157648, -122.484362206936) | |
| 149877 | 149877 | 34639 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1526 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | Permit Number 38319 | 5988094.3754 | 2104901.5335 | 37.758971621306294 | -122.48425267185101 | (37.7589716213063, -122.484252671851) | |
| 43165 | 43165 | 86404 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1739 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.813015 | 2103468.563864 | 37.755037507379 | -122.48412186397499 | (37.755037507379, -122.484121863975) | ||
| 11661 | 11661 | 86405 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1751 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.9893 | 2103387.0665 | 37.7548137478444 | -122.48411527814501 | (37.7548137478444, -122.484115278145) | ||
| 80048 | 80048 | 86406 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1755 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 04:50:00 PM | 3 | 3x3 | 5988105.375705 | 2103364.12029 | 37.7547509408949 | -122.484101884538 | (37.7547509408949, -122.484101884538) | ||
| 11892 | 11892 | 86407 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1767 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988104.9226 | 2103286.9146 | 37.7545389284857 | -122.48409779006599 | (37.7545389284857, -122.484097790066) | ||
| 12264 | 12264 | 86408 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1801X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 6 | 3x3 | 5988118.8805 | 2102991.671 | 37.753729081636 | -122.484027871479 | (37.753729081636, -122.484027871479) | ||
| 13117 | 13117 | 86409 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1803X 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 01:51:00 PM | 3 | 3x3 | 5988119.1620000005 | 2102979.6826 | 37.7536961811016 | -122.48402601894699 | (37.7536961811016, -122.484026018947) | ||
| 43181 | 43181 | 45110 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1628 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43972 | 5988064.267000001 | 2100358.3682 | 37.7464955561969 | -122.48402364747801 | (37.7464955561969, -122.484023647478) | |
| 121887 | 121887 | 85928 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1714 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988136.4457290005 | 2103626.592871 | 37.7554734287439 | -122.484013683245 | (37.7554734287439, -122.484013683245) | ||
| 11050 | 11050 | 86410 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1823 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988122.3065 | 2102871.1988 | 37.7533984968143 | -122.484007190165 | (37.7533984968143, -122.484007190165) | ||
| 125595 | 125595 | 86411 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1827 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988122.3314660005 | 2102866.63393 | 37.75338596436129 | -122.48400676911301 | (37.7533859643613, -122.484006769113) | ||
| 125048 | 125048 | 86412 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1837X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988124.549971 | 2102801.454812 | 37.7532071291716 | -122.483994317971 | (37.7532071291716, -122.483994317971) | ||
| 34984 | 34984 | 182861 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1839 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988124.6648 | 2102778.1754 | 37.7531432168441 | -122.483992213945 | (37.7531432168441, -122.483992213945) | |||
| 111945 | 111945 | 85924 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1742 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 04:45:00 PM | 3 | 3x3 | 5988142.680436 | 2103443.816611 | 37.7549719373756 | -122.483978719858 | (37.7549719373756, -122.483978719858) | ||
| 12056 | 12056 | 85925 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1730 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103504.7685 | 37.7551394419513 | -122.483974450282 | (37.7551394419513, -122.483974450282) | ||
| 116801 | 116801 | 85923 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1750 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988144.461781 | 2103391.5948240003 | 37.754828654122 | -122.483968730406 | (37.754828654122, -122.483968730406) | ||
| 52636 | 52636 | 182731 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1746 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988150.5839 | 2103404.0565 | 37.7548632269384 | -122.48394847241501 | (37.7548632269384, -122.483948472415) | |||
| 10393 | 10393 | 85922 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1750 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988150.1283 | 2103379.9075 | 37.754796893765395 | -122.483948277297 | (37.7547968937654, -122.483948277297) | ||
| 12222 | 12222 | 85921 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1754 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988153.7734 | 2103347.5571 | 37.754708280483605 | -122.483933299665 | (37.7547082804836, -122.483933299665) | ||
| 11245 | 11245 | 85919 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1792 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988158.7855 | 2103127.4828 | 37.7541043074668 | -122.483899830474 | (37.7541043074668, -122.483899830474) | ||
| 95805 | 95805 | 85918 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1822 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 04:55:00 PM | 3 | 3x3 | 5988161.420914 | 2102894.066268 | 37.7534635618366 | -122.483873602572 | (37.7534635618366, -122.483873602572) | ||
| 11561 | 11561 | 85917 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1830 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988168.9979 | 2102827.2497 | 37.7532805425745 | -122.48384250118299 | (37.7532805425745, -122.483842501183) | ||
| 10576 | 10576 | 85916 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1838 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988170.1375 | 2102775.399 | 37.753138240815204 | -122.48383475868201 | (37.7531382408152, -122.483834758682) | ||
| 72302 | 72302 | 67568 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 362 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1992 12:00:00 AM | 12 | Permit Number 31121 | 5988414.98731 | 2113567.23421 | 37.78278390002829 | -122.48377923972099 | (37.7827839000283, -122.483779239721) | ||
| 78412 | 78412 | 85913 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1898X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988178.281547 | 2102398.705021 | 37.7521044142719 | -122.48377897775299 | (37.7521044142719, -122.483778977753) | ||
| 10566 | 10566 | 85914 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1882 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988180.9701 | 2102501.3004 | 37.7523862701891 | -122.483777202176 | (37.7523862701891, -122.483777202176) | ||
| 153347 | 153347 | 182643 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1850 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988184.4082 | 2102424.8547 | 37.752176570923794 | -122.48375970825899 | (37.7521765709238, -122.483759708259) | |||
| 75365 | 75365 | 55279 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1227 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1972 12:00:00 AM | 5 | Permit Number 11205 | 5988291.3507 | 2106938.6555 | 37.76457647032 | -122.483720807179 | (37.76457647032, -122.483720807179) | ||
| 97258 | 97258 | 86288 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1227 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988292.680622 | 2106958.643896 | 37.76463143039629 | -122.48371767303499 | (37.7646314303963, -122.483717673035) | ||
| 12932 | 12932 | 86289 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1305X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988311.167 | 2106360.1458 | 37.762989194328 | -122.483609852071 | (37.762989194328, -122.483609852071) | ||
| 11977 | 11977 | 86290 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1323 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988313.8725 | 2106295.7544 | 37.7628125505969 | -122.483595773705 | (37.7628125505969, -122.483595773705) | ||
| 18679 | 18679 | 86291 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1339 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | |||
| 56089 | 56089 | 182046 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1339 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988319.2835 | 2106177.7939 | 37.7624889781976 | -122.483568410633 | (37.7624889781976, -122.483568410633) | |||
| 13035 | 13035 | 86292 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1355 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988320.3657 | 2106091.7584 | 37.762252811164295 | -122.483558359909 | (37.7622528111643, -122.483558359909) | ||
| 13120 | 13120 | 86293 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1367 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988324.1535 | 2106004.0997 | 37.762012344734 | -122.48353883273701 | (37.762012344734, -122.483538832737) | ||
| 12353 | 12353 | 86294 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1375 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2007 12:00:00 AM | 3 | 3x3 | 5988325.7768 | 2105957.0237 | 37.7618831813474 | -122.48352976705799 | (37.7618831813474, -122.483529767058) | ||
| 181556 | 181556 | 182061 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1385 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988327.9412 | 2105916.982 | 37.7617733637233 | -122.48351934570101 | (37.7617733637233, -122.483519345701) | |||
| 53967 | 53967 | 182062 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1389 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988330.1056 | 2105870.9882 | 37.7616472032503 | -122.48350848800301 | (37.7616472032503, -122.483508488003) | |||
| 184418 | 184418 | 182063 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1391 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988331.1878 | 2105848.2619 | 37.761584866006295 | -122.483503079006 | (37.7615848660063, -122.483503079006) | |||
| 83860 | 83860 | 86297 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1399X 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988332.320158 | 2105806.423168 | 37.7614700541453 | -122.48349609534701 | (37.7614700541453, -122.483496095347) | ||
| 102264 | 102264 | 86295 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1399X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988332.320158 | 2105806.423168 | 37.7614700541453 | -122.48349609534701 | (37.7614700541453, -122.483496095347) | ||
| 127869 | 127869 | 86296 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1399X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988332.320158 | 2105806.423168 | 37.7614700541453 | -122.48349609534701 | (37.7614700541453, -122.483496095347) | ||
| 12405 | 12405 | 86416 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2227 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988214.8811 | 2100128.059 | 37.74587195560729 | -122.483485965678 | (37.7458719556073, -122.483485965678) | ||
| 128851 | 128851 | 86286 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1300 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988350.35796 | 2106445.496749 | 37.763225825829004 | -122.483480563078 | (37.763225825829, -122.483480563078) | ||
| 75512 | 75512 | 60228 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1419 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1982 12:00:00 AM | 7 | Permit Number 19778 | 5988337.2114 | 2105628.2708 | 37.760981180898796 | -122.48346611801901 | (37.7609811808988, -122.483466118019) | |
| 109439 | 109439 | 86298 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1419 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988337.768852 | 2105648.043099 | 37.7610355026995 | -122.48346563960199 | (37.7610355026995, -122.483465639602) | ||
| 89198 | 89198 | 86417 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988219.183677 | 2100043.4529810003 | 37.7456399003067 | -122.48346488679701 | (37.7456399003067, -122.483464886797) | ||
| 179252 | 179252 | 182031 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1300 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988354.9964 | 2106399.6463 | 37.763100202981896 | -122.483461158979 | (37.7631002029819, -122.483461158979) | |||
| 58541 | 58541 | 60052 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1427 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 5 | Permit Number 19551 | 5988338.7048 | 2105586.102 | 37.76086548376 | -122.483457861607 | (37.76086548376, -122.483457861607) | |
| 141427 | 141427 | 86299 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1429 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988340.016392 | 2105582.712636 | 37.760856253825395 | -122.483453076967 | (37.7608562538254, -122.483453076967) | ||
| 13126 | 13126 | 86287 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1300 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2015 08:24:00 AM | 3 | 3x3 | 5988357.1608 | 2106342.2893 | 37.76294284228629 | -122.48344946811301 | (37.7629428422863, -122.483449468113) | ||
| 11857 | 11857 | 86285 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1326 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.7019 | 2106271.4048 | 37.762748244281795 | -122.483442399915 | (37.7627482442818, -122.483442399915) | ||
| 12891 | 12891 | 86300 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1443 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988341.8236 | 2105477.7745 | 37.760568227410495 | -122.483439133627 | (37.7605682274105, -122.483439133627) | ||
| 11255 | 11255 | 86284 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1330 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988359.3252 | 2106249.2195 | 37.762687423978 | -122.483435159107 | (37.762687423978, -122.483435159107) | ||
| 12941 | 12941 | 86283 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988360.9485 | 2106155.0675 | 37.7624290027378 | -122.48342264230301 | (37.7624290027378, -122.483422642303) | ||
| 12691 | 12691 | 86301 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1459 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988345.5662 | 2105396.6847 | 37.7603457946748 | -122.48342024517 | (37.7603457946748, -122.48342024517) | ||
| 34330 | 34330 | 182135 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1463 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988347.2296 | 2105350.1101 | 37.7602180102839 | -122.483411077972 | (37.7602180102839, -122.483411077972) | |||
| 11961 | 11961 | 86303 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1467 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988346.8137 | 2105325.1594 | 37.7601494782311 | -122.48341068724599 | (37.7601494782311, -122.483410687246) | ||
| 82756 | 82756 | 86302 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988347.658031 | 2105360.5890470003 | 37.7602468075616 | -122.48341036445 | (37.7602468075616, -122.48341036445) | ||
| 12950 | 12950 | 86281 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.654 | 2106078.2308 | 37.7622181875649 | -122.483407652112 | (37.7622181875649, -122.483407652112) | ||
| 123718 | 123718 | 60047 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1471 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1989 12:00:00 AM | 6 | Permit Number 28334 | 5988349.3088 | 2105301.4563 | 37.7600845411705 | -122.483400320347 | (37.7600845411705, -122.483400320347) | |
| 144478 | 144478 | 86304 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1471 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988349.456064 | 2105308.324648 | 37.7601034083602 | -122.48340031454501 | (37.7601034083602, -122.483400314545) | ||
| 11872 | 11872 | 86305 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1475 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988348.892999999 | 2105280.6641 | 37.7600274272341 | -122.483400234139 | (37.7600274272341, -122.483400234139) | ||
| 11485 | 11485 | 86280 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1366 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988366.3595 | 2106019.7917 | 37.7620578871803 | -122.483394010737 | (37.7620578871803, -122.483394010737) | ||
| 11299 | 11299 | 86306 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1483 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988351.387999999 | 2105239.4954 | 37.7599145343681 | -122.483388587245 | (37.7599145343681, -122.483388587245) | ||
| 10916 | 10916 | 86279 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1370 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988367.4417 | 2105985.7022 | 37.761964349683396 | -122.48338776877199 | (37.7619643496834, -122.483387768772) | ||
| 11502 | 11502 | 86307 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1491 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988352.2197 | 2105195.8317 | 37.7597946941019 | -122.483382509952 | (37.7597946941019, -122.483382509952) | ||
| 11583 | 11583 | 86277 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1390 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988371.7706 | 2105858.0017 | 37.761613970822 | -122.48336343539101 | (37.761613970822, -122.483363435391) | ||
| 11830 | 11830 | 86278 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1386 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988372.3117 | 2105874.2348 | 37.761658573987496 | -122.483362753995 | (37.7616585739875, -122.483362753995) | ||
| 124032 | 124032 | 85910 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988256.502181 | 2100122.915005 | 37.7458602539478 | -122.483341670527 | (37.7458602539478, -122.483341670527) | ||
| 12495 | 12495 | 85911 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2226 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988257.1282 | 2100144.275 | 37.745918939271604 | -122.483341071389 | (37.7459189392716, -122.483341071389) | ||
| 12692 | 12692 | 86310 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1523 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988361.5167 | 2104922.9048 | 37.759045851915396 | -122.48333034952499 | (37.7590458519154, -122.483330349525) | ||
| 13054 | 13054 | 86311 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1527 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.4596 | 2104894.2478 | 37.758967280631 | -122.483321529451 | (37.758967280631, -122.483321529451) | ||
| 11211 | 11211 | 85907 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2246 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988262.6758 | 2100024.3615 | 37.7455900114068 | -122.48331310017299 | (37.7455900114068, -122.483313100173) | ||
| 12995 | 12995 | 85903 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2270 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988266.5164 | 2099871.5891 | 37.745170762324705 | -122.483288623432 | (37.7451707623247, -122.483288623432) | ||
| 10552 | 10552 | 86314 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1563 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988370.7453 | 2104668.8777 | 37.758348899365394 | -122.483279812102 | (37.7583488993654, -122.483279812102) | ||
| 13195 | 13195 | 85902 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2278 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099821.6607 | 37.7450337963146 | -122.483277586342 | (37.7450337963146, -122.483277586342) | ||
| 11405 | 11405 | 86274 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1470 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988390.8371 | 2105304.6829 | 37.7600958174171 | -122.48325693207899 | (37.7600958174171, -122.483256932079) | ||
| 67215 | 67215 | 182502 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1589 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988377.5452 | 2104499.8501 | 37.7578851910226 | -122.48324390544902 | (37.7578851910226, -122.483243905449) | |||
| 39952 | 39952 | 182139 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1489 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988394.5038 | 2105191.4729 | 37.759785186860796 | -122.483235952305 | (37.7597851868608, -122.483235952305) | |||
| 89989 | 89989 | 86316 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1599X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988379.131198 | 2104445.743891 | 37.7577367222966 | -122.48323445447599 | (37.7577367222966, -122.483234454476) | ||
| 168177 | 168177 | 182138 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1492 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988395.4205 | 2105161.6809 | 37.759703439457 | -122.48323059812 | (37.759703439457, -122.48323059812) | |||
| 114557 | 114557 | 86317 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1611 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988382.64724 | 2104340.049698 | 37.757446719218294 | -122.48321454739201 | (37.7574467192183, -122.483214547392) | ||
| 12535 | 12535 | 86270 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1506 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988399.8879 | 2105026.8471 | 37.7593334823774 | -122.483205264351 | (37.7593334823774, -122.483205264351) | ||
| 11676 | 11676 | 86269 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1514 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988401.8308 | 2104975.3617 | 37.7591922304865 | -122.48319477105301 | (37.7591922304865, -122.483194771053) | ||
| 11063 | 11063 | 86318 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1659 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988389.7488 | 2104019.117 | 37.7565659379204 | -122.48316646418999 | (37.7565659379204, -122.48316646419) | ||
| 11342 | 11342 | 86268 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1554 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988410.0879 | 2104736.3916 | 37.7585365638092 | -122.483148698285 | (37.7585365638092, -122.483148698285) | ||
| 10185 | 10185 | 86271 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 10186 | 10186 | 86272 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 183909 | 183909 | 182144 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1671 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988395.3489 | 2103938.992 | 37.756346262161706 | -122.48314122447901 | (37.7563462621617, -122.483141224479) | |||
| 10504 | 10504 | 86267 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1562 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988412.0307 | 2104673.7348 | 37.7583646382457 | -122.483137386721 | (37.7583646382457, -122.483137386721) | ||
| 10918 | 10918 | 86319 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1687 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988396.6413 | 2103838.6204 | 37.756070744005605 | -122.483129398253 | (37.7560707440056, -122.483129398253) | ||
| 29551 | 29551 | 71175 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 10 | 5988319.432 | 2099688.0916 | 37.744670006074706 | -122.48309220548799 | (37.7446700060747, -122.483092205488) | ||
| 11263 | 11263 | 86266 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1650 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988431.5344 | 2104067.7951 | 37.75670202642571 | -122.483025524044 | (37.7567020264257, -122.483025524044) | ||
| 30612 | 30612 | 74162 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5988352.2909 | 2099691.0788 | 37.7446801201935 | -122.48297880610501 | (37.7446801201935, -122.482978806105) | ||
| 10583 | 10583 | 86264 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1694 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988441.0116 | 2103811.0505 | 37.755997626406206 | -122.482973932182 | (37.7559976264062, -122.482973932182) |
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");