trees
39,840 rows where qLegalStatus_id = 7 sorted by XCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57815 | 65566 | Permitted Site 7 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | 2 | 9 | 62 | 37 | ||||
| 49733 | 93214 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 51209 | 93212 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 56367 | 93211 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 109508 | 93208 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 135446 | 93213 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 148134 | 93209 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 191338 | 93210 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
| 56177 | 39988 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.7299843378677 | -122.372046361907 | (37.7299843378677, -122.372046361907) | 10 | 3 | 8 | 58 | 1 | ||
| 28566 | 50767 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | 10 | 3 | 8 | 58 | 1 | |||
| 44476 | 50764 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800 Innes Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | 10 | 3 | 8 | 58 | 1 | |||
| 182059 | 50765 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800 Innes Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | 10 | 3 | 8 | 58 | 1 | |||
| 186607 | 50766 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | 10 | 3 | 8 | 58 | 1 | |||
| 28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
| 152448 | 40005 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | 10 | 3 | 8 | 58 | 1 | ||
| 157007 | 39993 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 860 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | Permit Number 41251 | 6019175.31340513 | 2094526.32452806 | 37.7322440672923 | -122.376039506051 | (37.7322440672923, -122.376039506051) | 10 | 3 | 8 | 58 | 1 | ||
| 60249 | 39996 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 870 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41254 | 6019158.47829216 | 2094538.87688533 | 37.7322776068337 | -122.376098579608 | (37.7322776068337, -122.376098579608) | 10 | 3 | 8 | 58 | 1 | ||
| 157065 | 39998 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 880 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41256 | 6019141.64317919 | 2094551.4292426 | 37.7323111463453 | -122.376157653218 | (37.7323111463453, -122.376157653218) | 10 | 3 | 8 | 58 | 1 | ||
| 12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 14274 | 3580 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 44203 | 3575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 54162 | 3576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 62632 | 3577 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 66260 | 3682 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 90691 | 3567 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 105856 | 3574 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 109278 | 3570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 127393 | 3578 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 146341 | 3568 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 167396 | 3583 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 8 | 3x3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 178553 | 3571 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 22461 | 41041 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
| 47283 | 41040 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
| 82809 | 41043 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
| 124103 | 41042 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
| 170077 | 41039 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
| 69556 | 55267 | Permitted Site 7 | Tree(s) :: 17 | 951 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1972 12:00:00 AM | Permit Number 11192 | 6018959.0951935 | 2094622.67491213 | 37.7324967213894 | -122.376793711015 | (37.7324967213894, -122.376793711015) | 10 | 3 | 8 | 58 | 1 | |||
| 101290 | 69866 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52372 | 6018792.25966014 | 2094248.90737336 | 37.7314612388187 | -122.377344581888 | (37.7314612388187, -122.377344581888) | 10 | 3 | 8 | 58 | 1 | ||
| 75289 | 16471 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 81962 | 16476 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 70689 | 94959 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.378088153142 | (37.7364745658864, -122.378088153142) | 10 | 3 | 8 | 58 | 1 | ||||
| 80345 | 41525 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.7336937659006 | -122.37859297315 | (37.7336937659006, -122.37859297315) | 10 | 3 | 8 | 58 | 1 | |||
| 60263 | 41526 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | 10 | 3 | 8 | 58 | 1 | |||
| 83095 | 6442 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1997 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 84345 | 38450 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 119493 | 38452 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 176250 | 38449 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 176907 | 38451 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 33307 | 40025 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 201 Middle Point Rd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.8883759 | 2095348.52577329 | 37.7344500201686 | -122.379337522448 | (37.7344500201686, -122.379337522448) | 10 | 3 | 8 | 58 | 1 | ||
| 130308 | 40026 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 201 Middle Point Rd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.8883759 | 2095348.52577329 | 37.7344500201686 | -122.379337522448 | (37.7344500201686, -122.379337522448) | 10 | 3 | 8 | 58 | 1 | |||
| 56075 | 94645 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 30 Middle Point Rd | 34 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
| 133480 | 94646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Middle Point Rd | 35 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
| 36449 | 11208 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1001X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
| 69792 | 38453 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 142162 | 38456 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 142867 | 38454 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 167615 | 38455 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 991 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 40553 | 3475 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 60935 | 3489 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301X Cargo Way | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 75700 | 3470 | Permitted Site 7 | Quercus spp :: Oak 254 | 301X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 114367 | 3483 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 117511 | 3478 | Permitted Site 7 | Quercus spp :: Oak 254 | 301X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 171841 | 11237 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1100X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.379993586815 | (37.7307473625426, -122.379993586815) | 10 | 3 | 8 | 58 | 1 | ||
| 17986 | 93585 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 32197 | 93580 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 32209 | 93594 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 15 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 35919 | 93595 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 16 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 42517 | 93597 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 43379 | 93610 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 44736 | 93606 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 49914 | 93587 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 51128 | 93601 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 69911 | 93593 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 14 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 72305 | 93603 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 24 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 80026 | 93602 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 23 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 82600 | 93581 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 92240 | 93591 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 12 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 99136 | 93605 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 26 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 102260 | 93612 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 33 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 105077 | 93590 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 11 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 105397 | 93582 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 105469 | 93596 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 17 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 107823 | 93609 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 30 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 127741 | 93588 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 9 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 137802 | 93611 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 32 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 147791 | 93604 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 25 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 150534 | 93599 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 20 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 151733 | 93584 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 5 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 153817 | 93608 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 29 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 154711 | 93592 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 13 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 157028 | 93583 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 163590 | 93589 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 10 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 164392 | 93598 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 19 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 174810 | 93600 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 21 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 175451 | 93607 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 28 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 181940 | 93586 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 7 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
| 124660 | 3616 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017954.33608 | 2098256.07975 | 37.7424179434233 | -122.380519890289 | (37.7424179434233, -122.380519890289) | 10 | 3 | 8 | 58 | 1 | |||
| 181323 | 1992 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 123 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017953.1875354 | 2094759.0002915 | 37.7328155945402 | -122.380280880855 | (37.7328155945402, -122.380280880855) | 10 | 3 | 8 | 58 | 1 | |||
| 39217 | 1985 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017895.3004083 | 2094810.8316482 | 37.7329547191536 | -122.380484614626 | (37.7329547191536, -122.380484614626) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );