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 | ||||||||
| 1977 | 1977 | 35358 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 861 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2017 12:00:00 AM | 3 | Permit Number 779956 | 6011891.4551800005 | 2104381.4501400003 | 37.758900452609794 | -122.401914128638 | (37.7589004526098, -122.401914128638) | |
| 2598 | 2598 | 110677 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | 6009154.39159 | 2119176.95818 | 37.7993722757787 | -122.412426018055 | (37.7993722757787, -122.412426018055) | ||
| 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 | ||||||||
| 17982 | 17982 | 40992 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | ||
| 19134 | 19134 | 42608 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | ||
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 19682 | 19682 | 46465 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | |||
| 23453 | 23453 | 44513 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 150 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 12 | Permit Number 43807 | 6005815.01817 | 2093004.2329099998 | 37.72732019055479 | -122.422121046963 | (37.7273201905548, -122.422121046963) | |
| 24742 | 24742 | 54473 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.352419999 | 2095372.33986 | 37.73418801985999 | -122.39975324750799 | (37.73418801986, -122.399753247508) | ||
| 25066 | 25066 | 45114 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1432 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43977 | 5988656.3497 | 2100380.3456 | 37.7465903529409 | -122.481977924939 | (37.7465903529409, -122.481977924939) | |
| 25208 | 25208 | 66447 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.1903099995 | 2119198.2009799997 | 37.7994303674837 | -122.41244205838001 | (37.7994303674837, -122.41244205838) | |
| 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) | |
| 26909 | 26909 | 193581 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016627.824130001 | 2102624.40575 | 37.754339175729704 | -122.38541095757 | (37.7543391757297, -122.38541095757) | ||||
| 27152 | 27152 | 72787 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 6000842.138719999 | 2087917.52073 | 37.7130714894434 | -122.43894785796199 | (37.7130714894434, -122.438947857962) | ||
| 29014 | 29014 | 43250 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 266 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43038 | 6009538.8668599995 | 2093129.97083 | 37.7278747727781 | -122.40925652566601 | (37.7278747727781, -122.409256525666) | |
| 29537 | 29537 | 202192 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1928 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013154.16149 | 2093432.6773299999 | 37.728907828517706 | -122.396779493476 | (37.7289078285177, -122.396779493476) | ||||
| 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) | ||
| 30056 | 30056 | 68330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3 | Permit Number 32145 | 5991076.10581 | 2110608.88252 | 37.774815627769705 | -122.474357034376 | (37.7748156277697, -122.474357034376) | |
| 30502 | 30502 | 30752 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | |
| 30527 | 30527 | 33381 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.871562201 | 2093773.0831922002 | 37.72867362771839 | -122.46806524141199 | (37.7286736277184, -122.468065241412) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 31268 | 31268 | 51730 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3950 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 48012 | 5995856.51987 | 2115213.07332 | 37.787733304083 | -122.458153993141 | (37.787733304083, -122.458153993141) | |||
| 32468 | 32468 | 193582 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6016596.341630001 | 2102622.43103 | 37.7543320117256 | -122.385519695483 | (37.7543320117256, -122.385519695483) | ||||
| 32479 | 32479 | 46784 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 20 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 12 | Permit Number 44875 | 6002869.92629 | 2093520.6249 | 37.728571535144404 | -122.432339079298 | (37.7285715351444, -122.432339079298) | |
| 32540 | 32540 | 210191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Melrose Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 5997966.64829 | 2095534.3479400002 | 37.7338214930658 | -122.44943494048799 | (37.7338214930658, -122.449434940488) | ||||
| 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) | ||
| 33375 | 33375 | 40695 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 239 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41675 | 6004959.82025 | 2094081.1149900001 | 37.7302287977163 | -122.425154059106 | (37.7302287977163, -122.425154059106) | |
| 36735 | 36735 | 39593 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 4 | Permit Number 41001 | 6012273.08907 | 2104003.23751 | 37.7578832555154 | -122.400567684363 | (37.7578832555154, -122.400567684363) | ||
| 37143 | 37143 | 202191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013172.4275 | 2093425.71658 | 37.7288897323776 | -122.39671585835698 | (37.7288897323776, -122.396715858357) | ||||
| 37390 | 37390 | 39700 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.45665278849701 | (37.7319575477065, -122.456652788497) | ||
| 37532 | 37532 | 247980 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009795.98268 | 2099453.55621 | 37.745252380808296 | -122.408813614968 | (37.7452523808083, -122.408813614968) | ||||
| 37688 | 37688 | 72518 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1996 12:00:00 AM | 14 | 5999282.60736 | 2089782.0179599999 | 37.718102119793 | -122.44447201828599 | (37.718102119793, -122.444472018286) | ||
| 38344 | 38344 | 33199 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | ||
| 38920 | 38920 | 31779 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 926 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35253 | 5990034.0009 | 2097707.4772 | 37.73933137655229 | -122.477018926471 | (37.7393313765523, -122.477018926471) | |
| 39361 | 39361 | 45486 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2924 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 9 | Permit Number 44265 | 5990007.82234 | 2095770.7534900003 | 37.734012111575495 | -122.476967961016 | (37.7340121115755, -122.476967961016) | |
| 39906 | 39906 | 41404 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | |
| 40494 | 40494 | 42892 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2338 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 0 | Permit Number 42810 | 5988796.038108099 | 2098341.45660017 | 37.741000222372605 | -122.48134561704599 | (37.7410002223726, -122.481345617046) | |
| 40619 | 40619 | 193584 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016537.00465 | 2102619.7128 | 37.7543212648174 | -122.385724710323 | (37.7543212648174, -122.385724710323) | ||||
| 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) | |
| 42170 | 42170 | 78623 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 440 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 2 | 6008334.454919999 | 2113493.19738 | 37.7837200144185 | -122.414860811987 | (37.7837200144185, -122.414860811987) | ||
| 42782 | 42782 | 232102 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3974 22nd St | 2 | : 4 | Tree 1 | Private 1 | 4 | 6002009.98359 | 2102946.50265 | 37.7544039961563 | -122.435986138674 | (37.7544039961563, -122.435986138674) | ||||
| 42929 | 42929 | 39524 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40968 | 6012453.7413 | 2107068.2011 | 37.7663090393741 | -122.400158161944 | (37.7663090393741, -122.400158161944) | |
| 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) | ||
| 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) | |
| 43472 | 43472 | 41918 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 548 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42279 | 5995332.21219 | 2111809.65905 | 37.7783583003595 | -122.45972137274201 | (37.7783583003595, -122.459721372742) | |
| 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) | |
| 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) | ||
| 45210 | 45210 | 39519 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40968 | 6012430.9158 | 2107067.2501 | 37.7663051554079 | -122.40023704474301 | (37.7663051554079, -122.400237044743) | |
| 45871 | 45871 | 81930 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 7 | 6009272.01277 | 2113623.31708 | 37.7841299280977 | -122.411626400234 | (37.7841299280977, -122.411626400234) | ||
| 46014 | 46014 | 31578 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1754 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 10 | Permit Number 35117 | 5989080.8272 | 2103403.4503 | 37.7549156741725 | -122.480731424582 | (37.7549156741725, -122.480731424582) | |
| 46781 | 46781 | 44728 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1144 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 0 | Permit Number 43847 | 5989925.4048235 | 2101102.91118097 | 37.748648053776606 | -122.477642521633 | (37.7486480537766, -122.477642521633) | |
| 47652 | 47652 | 202182 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013216.00577 | 2093392.0868099998 | 37.7287998172575 | -122.39656284771401 | (37.7287998172575, -122.396562847714) | ||||
| 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) | |
| 49369 | 49369 | 193620 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 602 Arthur Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6015868.84489 | 2099868.33266 | 37.7467295550179 | -122.387843428526 | (37.7467295550179, -122.387843428526) | ||||
| 49895 | 49895 | 39520 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40968 | 6012360.5372 | 2107063.4458 | 37.766290785060605 | -122.400480205309 | (37.7662907850606, -122.400480205309) | |
| 50170 | 50170 | 42509 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42623 | 5999007.81241244 | 2093762.41150779 | 37.7290156761066 | -122.44570795274099 | (37.7290156761066, -122.445707952741) | ||
| 50499 | 50499 | 39699 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 360 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.45665278849701 | (37.7319575477065, -122.456652788497) | ||
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 51600 | 51600 | 61350 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3315 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1984 12:00:00 AM | 7 | Permit Number 21255 | 5998367.84579 | 2116169.77731 | 37.790504139296395 | -122.44953428677401 | (37.7905041392964, -122.449534286774) | ||
| 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) | |
| 53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
| 53786 | 53786 | 33351 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | ||
| 53912 | 53912 | 41419 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 8 | Permit Number 42026 | 6008750.56099 | 2117953.73306 | 37.795990931877796 | -122.41373684920299 | (37.7959909318778, -122.413736849203) | ||
| 54432 | 54432 | 51708 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 164 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2005 12:00:00 AM | 10 | Permit Number 47984 | 6005827.00268 | 2092955.6081299998 | 37.727187353502 | -122.422076163594 | (37.727187353502, -122.422076163594) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 58862 | 58862 | 37345 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39853 | 5998100.18965 | 2086460.63765 | 37.7089148310191 | -122.448320064445 | (37.7089148310191, -122.448320064445) | |
| 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) | |
| 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) | ||
| 60912 | 60912 | 42493 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.9530099998 | 37.726434250767205 | -122.45223052530301 | (37.7264342507672, -122.452230525303) | ||
| 62498 | 62498 | 44721 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1996 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2001 12:00:00 AM | Permit Number 43840 | 5989758.20628326 | 2101785.10530384 | 37.7505114749608 | -122.47827055966499 | (37.7505114749608, -122.478270559665) | |||
| 63497 | 63497 | 78590 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 440 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 2 | 6008293.183999999 | 2113486.29357 | 37.783698739150296 | -122.415003105409 | (37.7836987391503, -122.415003105409) | ||
| 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) | ||
| 64213 | 64213 | 202181 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013222.94706 | 2093387.62112 | 37.7287879416857 | -122.396538538139 | (37.7287879416857, -122.396538538139) | ||||
| 64253 | 64253 | 34245 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 778 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 8 | Permit Number 38055 | 6011531.92576 | 2104772.40188 | 37.7599538473986 | -122.403185056849 | (37.7599538473986, -122.403185056849) | |
| 64719 | 64719 | 41416 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 6 | Permit Number 42026 | 6008807.34018 | 2117960.78638 | 37.7960134868966 | -122.413540880625 | (37.7960134868966, -122.413540880625) | ||
| 64843 | 64843 | 68171 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 960 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 5 | Permit Number 31942 | 5995973.45789 | 2112246.45528 | 37.7795944815391 | -122.457534690099 | (37.7795944815391, -122.457534690099) | |
| 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) | ||
| 65459 | 65459 | 38563 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1444 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40529 | 6016067.4266 | 2095101.8608 | 37.7336527931474 | -122.386824395296 | (37.7336527931474, -122.386824395296) | |
| 65625 | 65625 | 78240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348306999 | (37.7255059765042, -122.43764348307) | ||
| 65875 | 65875 | 41417 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42026 | 6008785.84855 | 2117957.11864 | 37.796002209398296 | -122.41361498656401 | (37.7960022093983, -122.413614986564) | ||
| 65882 | 65882 | 56049 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 345 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 14 | Permit Number 12137 | 6014083.6423 | 2105399.63652 | 37.7618182724049 | -122.39440375714099 | (37.7618182724049, -122.394403757141) | ||
| 65943 | 65943 | 66074 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 391 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 17 | Permit Number 29117 | 6013527.73484 | 2105290.93775 | 37.761488891222 | -122.396318814866 | (37.761488891222, -122.396318814866) | |
| 67573 | 67573 | 210176 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000817.03746 | 2095186.4221400002 | 37.7330288117357 | -122.43955538059299 | (37.7330288117357, -122.439555380593) | ||||
| 69181 | 69181 | 193579 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016687.20636 | 2102628.57061 | 37.7543538967387 | -122.385205886941 | (37.7543538967387, -122.385205886941) | ||||
| 69544 | 69544 | 51731 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3950 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | 10 | Permit Number 48012 | 5995844.82991 | 2115212.51592 | 37.787731101907 | -122.458194397553 | (37.787731101907, -122.458194397553) | ||
| 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) | ||
| 70455 | 70455 | 193621 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 602 Arthur Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015879.35493 | 2099868.12062 | 37.746729555018895 | -122.38780707073799 | (37.7467295550189, -122.387807070738) | ||||
| 71889 | 71889 | 81931 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 7 | 6009287.21527 | 2113626.45246 | 37.78413938986429 | -122.411574026434 | (37.7841393898643, -122.411574026434) | ||
| 72182 | 72182 | 78902 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1443 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 9 | 5989581.2299 | 2105525.1155 | 37.7607702705418 | -122.47915610314301 | (37.7607702705418, -122.479156103143) | ||
| 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) | ||
| 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) |
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");