Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4972 | 4972 | 3572 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:42:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
5040 | 5040 | 3573 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:44:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
51545 | 51545 | 3580 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
66646 | 66646 | 3581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
79713 | 79713 | 3575 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
84280 | 84280 | 3576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
84902 | 84902 | 3682 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
85875 | 85875 | 3577 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
95791 | 95791 | 3567 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
101112 | 101112 | 3570 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
103648 | 103648 | 3574 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
103993 | 103993 | 3578 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
113278 | 113278 | 3568 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
117261 | 117261 | 3583 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 8 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
138764 | 138764 | 3571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
4989 | 4989 | 83048 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.37739803950001 | (37.7406452501696, -122.3773980395) | |||
43784 | 43784 | 83046 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.37751250161399 | (37.740707968002, -122.377512501614) | |||
4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
4998 | 4998 | 83042 | Private 5 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | |||
4985 | 4985 | 83041 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.74089078129229 | -122.377824564564 | (37.7408907812923, -122.377824564564) | |||
5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
153213 | 153213 | 83039 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 12 | 6018611.72965 | 2097767.00037 | 37.741111283369705 | -122.378212851336 | (37.7411112833697, -122.378212851336) | |||
5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
5038 | 5038 | 83035 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:50:00 AM | 3 | 6018541.89406 | 2097818.9676900003 | 37.741250126083706 | -122.37845792741501 | (37.7412501260837, -122.378457927415) | |||
4980 | 4980 | 83034 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:59:00 PM | 3 | 6018525.50747 | 2097831.43609 | 37.7412834585567 | -122.37851545254298 | (37.7412834585567, -122.378515452543) | |||
22342 | 22342 | 3584 | Permitted Site 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/11/1998 12:00:00 AM | 3 | 3X3 | 6018506.82441 | 2097843.80813 | 37.7413163998229 | -122.378580911506 | (37.7413163998229, -122.378580911506) | ||
4987 | 4987 | 27477 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:59:00 AM | 3 | 3X3 | 6018492.70308 | 2097854.80306 | 37.7413458112573 | -122.378630501891 | (37.7413458112573, -122.378630501891) | ||
4969 | 4969 | 3585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:02:00 PM | 3 | 3x3 | 6018473.32905 | 2097868.47388 | 37.7413822805579 | -122.37869844028299 | (37.7413822805579, -122.378698440283) | ||
5052 | 5052 | 3586 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:01:00 AM | 3 | 3X3 | 6018456.23147 | 2097881.24253 | 37.74141639814229 | -122.378758444849 | (37.7414163981423, -122.378758444849) | ||
159024 | 159024 | 3587 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.3984199995 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | ||
5014 | 5014 | 3588 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:07:00 AM | 3 | 3X3 | 6018423.14615 | 2097904.9005 | 37.7414795341434 | -122.37887448618 | (37.7414795341434, -122.37887448618) | ||
56191 | 56191 | 3589 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018406.34137 | 2097917.94858 | 37.741514435040294 | -122.37893349789302 | (37.7415144350403, -122.378933497893) | ||
22322 | 22322 | 3590 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018389.26392 | 2097931.71648 | 37.7415512973552 | -122.378993502451 | (37.7415512973552, -122.378993502451) | ||
22353 | 22353 | 3591 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018372.01456 | 2097944.0595 | 37.741584237724396 | -122.37905400254499 | (37.7415842377244, -122.379054002545) | ||
5065 | 5065 | 3592 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018357.04475 | 2097955.64275 | 37.741615217581796 | -122.379106567936 | (37.7416152175818, -122.379106567936) | ||
23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
5049 | 5049 | 3594 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3x3 | 6018322.1359 | 2097981.33701 | 37.741683843926396 | -122.379229056502 | (37.7416838439264, -122.379229056502) | |||
4962 | 4962 | 3595 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 03:05:00 PM | 3 | 3X3 | 6018306.03367 | 2097993.65704 | 37.741716784307606 | -122.379285588775 | (37.7417167843076, -122.379285588775) | ||
4978 | 4978 | 3596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:07:00 PM | 3 | 3X3 | 6018288.66955 | 2098007.43076 | 37.7417536466133 | -122.379346585295 | (37.7417536466133, -122.379346585295) | ||
4931 | 4931 | 3597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018273.82586 | 2098018.1543799997 | 37.7417822729228 | -122.37939865514299 | (37.7417822729228, -122.379398655143) | ||
5063 | 5063 | 3598 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:10:00 PM | 3 | 3X3 | 6018255.028469999 | 2098031.9569200003 | 37.7418191352571 | -122.37946460960501 | (37.7418191352571, -122.379464609605) | ||
1076 | 1076 | 3599 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:11:00 PM | 3 | 3X3 | 6018236.38581 | 2098046.3275599997 | 37.7418575659771 | -122.37953006857799 | (37.7418575659771, -122.379530068578) | ||
4945 | 4945 | 3600 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:14:00 PM | 3 | 3X3 | 6018222.967130001 | 2098056.59418 | 37.7418850159701 | -122.379577179554 | (37.7418850159701, -122.379577179554) | ||
5023 | 5023 | 3601 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:11:00 AM | 3 | 3X3 | 6018206.00756 | 2098069.0742900004 | 37.7419183484432 | -122.379636687689 | (37.7419183484432, -122.379636687689) | ||
22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
13941 | 13941 | 3603 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018171.24251 | 2098094.76588 | 37.741986974834106 | -122.379758679838 | (37.7419869748341, -122.379758679838) | |||
16197 | 16197 | 3604 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018155.728019999 | 2098107.78819 | 37.742021875700296 | -122.37981322911999 | (37.7420218757003, -122.37981322912) | |||
22352 | 22352 | 3605 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018137.75637 | 2098119.86028 | 37.7420540318827 | -122.37987620861601 | (37.7420540318827, -122.379876208616) | |||
15214 | 15214 | 3606 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.742083834489605 | -122.379930757907 | (37.7420838344896, -122.379930757907) | |||
22330 | 22330 | 3607 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.742115598557895 | -122.37998679465001 | (37.7421155985579, -122.37998679465) | |||
22338 | 22338 | 3608 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | ||
22337 | 22337 | 3609 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 9 | 3X3 | 6018070.77279 | 2098169.47823 | 37.7421865775631 | -122.380111266222 | (37.7421865775631, -122.380111266222) | |||
22333 | 22333 | 3610 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018056.230380001 | 2098180.90993 | 37.742217164400294 | -122.380162344118 | (37.7422171644003, -122.380162344118) | |||
22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
22328 | 22328 | 3612 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018020.628269999 | 2098207.76094 | 37.7422889275932 | -122.380287312129 | (37.7422889275932, -122.380287312129) | |||
16754 | 16754 | 3613 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.742321475865296 | -122.380345828295 | (37.7423214758653, -122.380345828295) | |||
5066 | 5066 | 3614 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.742354807434396 | -122.380409304248 | (37.7423548074344, -122.380409304248) | |||
13427 | 13427 | 3615 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | ||
15552 | 15552 | 3616 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017954.336080001 | 2098256.07975 | 37.7424179434233 | -122.38051989028901 | (37.7424179434233, -122.380519890289) | |||
1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
5070 | 5070 | 3618 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | |||
16830 | 16830 | 3619 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017883.8496199995 | 2098309.7670299998 | 37.742561468052294 | -122.380767345063 | (37.7425614680523, -122.380767345063) | |||
5035 | 5035 | 3620 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:20:00 PM | 3 | 3X3 | 6017867.03936 | 2098322.52996 | 37.7425955847281 | -122.380826357655 | (37.7425955847281, -122.380826357655) | ||
1079 | 1079 | 3621 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:22:00 PM | 3 | 3X3 | 6017849.66978 | 2098333.64293 | 37.7426251400454 | -122.380887189608 | (37.7426251400454, -122.380887189608) | ||
22346 | 22346 | 3622 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017832.2114699995 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | |||
22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
4994 | 4994 | 3624 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:25:00 PM | 3 | 3X3 | 6017797.96297 | 2098371.7943700003 | 37.742727042232396 | -122.38106863050601 | (37.7427270422324, -122.381068630506) | ||
22324 | 22324 | 3625 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017781.374919999 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | |||
22349 | 22349 | 3626 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017765.800369999 | 2098395.89545 | 37.7427914435713 | -122.38118151611201 | (37.7427914435713, -122.381181516112) | |||
22336 | 22336 | 3627 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | ||
22335 | 22335 | 3628 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.38130471064899 | (37.7428615520079, -122.381304710649) | |||
22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
4973 | 4973 | 3631 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:27:00 PM | 3 | 3X3 | 6017682.09522 | 2098458.88711 | 37.7429597849556 | -122.381475327351 | (37.7429597849556, -122.381475327351) | ||
22340 | 22340 | 3632 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017663.5913 | 2098472.7680200003 | 37.7429968775117 | -122.38154027458799 | (37.7429968775117, -122.381540274588) | |||
14783 | 14783 | 3633 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.743027039860394 | -122.381591304811 | (37.7430270398604, -122.381591304811) | |||
22310 | 22310 | 3634 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.743058833606604 | -122.38164903679899 | (37.7430588336066, -122.381649036799) | |||
13855 | 13855 | 3635 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3x3 | 6017615.70257 | 2098508.02238 | 37.7430910347139 | -122.38170831381201 | (37.7430910347139, -122.381708313812) | ||
22315 | 22315 | 3636 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.38176656108601 | (37.7431297568333, -122.381766561086) | |||
22332 | 22332 | 3637 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017581.37685 | 2098535.7297 | 37.7431652179942 | -122.381828930869 | (37.7431652179942, -122.381828930869) | |||
22327 | 22327 | 3638 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | |||
22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
14056 | 14056 | 3640 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017536.43295 | 2098576.56598 | 37.7432748642351 | -122.381987176477 | (37.7432748642351, -122.381987176477) | |||
4948 | 4948 | 3641 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:31:00 PM | 3 | 3X3 | 6017517.08856 | 2098593.13553 | 37.7433192925522 | -122.38205521738999 | (37.7433192925522, -122.38205521739) | ||
22339 | 22339 | 3642 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017503.4842 | 2098606.02713 | 37.7433539389383 | -122.382103154832 | (37.7433539389383, -122.382103154832) | |||
22311 | 22311 | 3643 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | |||
5067 | 5067 | 3644 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 80 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:15:00 AM | 3 | 3X3 | 6017471.8409400005 | 2098633.68097 | 37.7434281231236 | -122.382214493629 | (37.7434281231236, -122.382214493629) | ||
22350 | 22350 | 3645 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.38226603915399 | (37.7434680683118, -122.382266039154) | ||
4950 | 4950 | 3646 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:16:00 AM | 3 | 3X3 | 6017441.11571 | 2098662.50366 | 37.7435055673357 | -122.38232273959999 | (37.7435055673357, -122.3823227396) | ||
22347 | 22347 | 3647 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.38237892474599 | (37.7435463281955, -122.382378924746) | ||
5058 | 5058 | 3648 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | ||
16783 | 16783 | 3649 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 85 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017394.85513 | 2098704.5539599997 | 37.7436184736271 | -122.382485623916 | (37.7436184736271, -122.382485623916) | ||
5002 | 5002 | 3650 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:18:00 AM | 3 | 3X3 | 6017379.34335 | 2098718.96834 | 37.743657195713396 | -122.382540263146 | (37.7436571957134, -122.382540263146) | ||
22331 | 22331 | 3651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6017363.3819699995 | 2098733.24342 | 37.7436955104472 | -122.38259644736601 | (37.7436955104472, -122.382596447366) | ||
81407 | 81407 | 4017 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 700X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) |
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");