trees
11,761 rows where qSpecies_id = 17 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 | ||||
| 33524 | 65565 | DPW Maintained 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | 2 | 9 | 62 | 37 | ||||
| 174692 | 65563 | DPW Maintained 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.369041103471 | (37.8103107984086, -122.369041103471) | 2 | 9 | 62 | 37 | ||||
| 72238 | 65564 | DPW Maintained 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.369882282876 | (37.8103949467147, -122.369882282876) | 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 | ||
| 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 | |||
| 2201 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
| 41288 | 107545 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||
| 59601 | 107546 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||
| 98264 | 107548 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |
| 176016 | 107544 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 5 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
| 193379 | 107543 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||
| 135414 | 107540 | DPW Maintained 1 | Tree(s) :: 17 | 198X JENNINGS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | ||
| 114583 | 16460 | DPW Maintained 1 | Tree(s) :: 17 | 2X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774049 | 6018746.8015012 | 2097101.6577332 | 37.7392918278803 | -122.377699652009 | (37.7392918278803, -122.377699652009) | 10 | 3 | 8 | 58 | 1 | |
| 9426 | 107555 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 14319 | 107554 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |||
| 32524 | 107556 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 36574 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 38316 | 107558 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 40220 | 107562 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 46702 | 107564 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 56372 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 60676 | 107559 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 96373 | 107561 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 98721 | 107560 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 119862 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 168696 | 107563 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 180086 | 107557 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 179752 | 10547 | DPW Maintained 1 | Tree(s) :: 17 | 187 Harbor Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1995 12:00:00 AM | 6 | 3X4 | 6018418.3027239 | 2094690.3062519 | 37.7326526259914 | -122.378668074213 | (37.7326526259914, -122.378668074213) | 10 | 3 | 8 | 58 | 1 | ||
| 20461 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 30460 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 34585 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 48640 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 59683 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 67820 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 126993 | 104281 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 3 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 132116 | 104289 | Significant Tree 6 | Tree(s) :: 17 | 10X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 133125 | 104286 | Significant Tree 6 | Tree(s) :: 17 | 200X West Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 156652 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 174752 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 182512 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 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 | ||||
| 182689 | 108589 | Significant Tree 6 | Tree(s) :: 17 | 1139x HUDSON AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6017760 | 2094672 | 37.7325660477977 | -122.380942739781 | (37.7325660477977, -122.380942739781) | 10 | 3 | 8 | 58 | 1 | |||||
| 192829 | 64479 | Permitted Site 7 | Tree(s) :: 17 | 1135 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1988 12:00:00 AM | Permit Number 25352 | 6017346.79859016 | 2093380.57453278 | 37.7289972322989 | -122.382281478103 | (37.7289972322989, -122.382281478103) | 10 | 3 | 8 | 58 | 1 | |||
| 192509 | 61466 | Permitted Site 7 | Tree(s) :: 17 | 305 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1984 12:00:00 AM | Permit Number 21409 | 6017329.37296527 | 2101668.01387498 | 37.7517519104882 | -122.382918243945 | (37.7517519104882, -122.382918243945) | 10 | 3 | 8 | 58 | 1 | |||
| 116586 | 24034 | Permitted Site 7 | Tree(s) :: 17 | 57 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6017316.3969308 | 2095539.3705438 | 37.7349231809729 | -122.382536728248 | (37.7349231809729, -122.382536728248) | 10 | 3 | 8 | 58 | 1 | ||
| 136860 | 56117 | Permitted Site 7 | Tree(s) :: 17 | 119 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12219 | 6017286.13768903 | 2103076.65629864 | 37.7556173610899 | -122.383165795245 | (37.7556173610899, -122.383165795245) | 10 | 3 | 8 | 28856 | 29 | |||
| 35530 | 56118 | Permitted Site 7 | Tree(s) :: 17 | 123 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12220 | 6017278.61280007 | 2103076.21860338 | 37.7556157434444 | -122.383191788468 | (37.7556157434444, -122.383191788468) | 10 | 3 | 8 | 28856 | 29 | |||
| 132742 | 56119 | Permitted Site 7 | Tree(s) :: 17 | 135 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12221 | 6017256.03813589 | 2103074.90551775 | 37.7556108904741 | -122.383269768121 | (37.7556108904741, -122.383269768121) | 10 | 3 | 8 | 28856 | 29 | |||
| 159892 | 56120 | Permitted Site 7 | Tree(s) :: 17 | 139 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12222 | 6017248.51324962 | 2103074.46782264 | 37.7556092728063 | -122.38329576133 | (37.7556092728063, -122.38329576133) | 10 | 3 | 8 | 28856 | 29 | |||
| 172545 | 56122 | Permitted Site 7 | Tree(s) :: 17 | 143 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12226 | 6017240.98836334 | 2103074.03012753 | 37.7556076551327 | -122.383321754538 | (37.7556076551327, -122.383321754538) | 10 | 3 | 8 | 28856 | 29 | |||
| 161341 | 56121 | Permitted Site 7 | Tree(s) :: 17 | 142 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12223 | 6017237.96881731 | 2103125.94238371 | 37.7557500284785 | -122.383335810598 | (37.7557500284785, -122.383335810598) | 10 | 3 | 8 | 28856 | 29 | |||
| 131916 | 67791 | Permitted Site 7 | Tree(s) :: 17 | 432 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | Permit Number 31433 | 6017234.54710129 | 2102185.11209724 | 37.7531665152538 | -122.38328215814 | (37.7531665152538, -122.38328215814) | 10 | 3 | 8 | 28856 | 29 | |||
| 32887 | 56123 | Permitted Site 7 | Tree(s) :: 17 | 144 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12225 | 6017234.20637149 | 2103125.72353601 | 37.7557492196374 | -122.383348807235 | (37.7557492196374, -122.383348807235) | 10 | 3 | 8 | 28856 | 29 | |||
| 42833 | 56124 | Permitted Site 7 | Tree(s) :: 17 | 147 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12227 | 6017233.46347707 | 2103073.59243243 | 37.7556060374534 | -122.383347747745 | (37.7556060374534, -122.383347747745) | 10 | 3 | 8 | 28856 | 29 | |||
| 89261 | 56125 | Permitted Site 7 | Tree(s) :: 17 | 151 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12228 | 6017225.93858543 | 2103073.15473701 | 37.7556044197673 | -122.383373740969 | (37.7556044197673, -122.383373740969) | 10 | 3 | 8 | 28856 | 29 | |||
| 35865 | 56126 | Permitted Site 7 | Tree(s) :: 17 | 154 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12229 | 6017215.39415849 | 2103124.62929839 | 37.7557451754142 | -122.383413790363 | (37.7557451754142, -122.383413790363) | 10 | 3 | 8 | 28856 | 29 | |||
| 59278 | 62367 | Permitted Site 7 | Tree(s) :: 17 | 440 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | Permit Number 22513 | 6017213.1674947 | 2102183.98386888 | 37.7531622358467 | -122.383356015295 | (37.7531622358467, -122.383356015295) | 10 | 3 | 8 | 28856 | 29 | |||
| 31936 | 56128 | Permitted Site 7 | Tree(s) :: 17 | 161 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12231 | 6017207.12637243 | 2103072.0604994 | 37.7556003755302 | -122.383438723969 | (37.7556003755302, -122.383438723969) | 10 | 3 | 8 | 28856 | 29 | |||
| 165248 | 56127 | Permitted Site 7 | Tree(s) :: 17 | 160 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12230 | 6017204.1068264 | 2103123.97275558 | 37.7557427488621 | -122.383452780252 | (37.7557427488621, -122.383452780252) | 10 | 3 | 8 | 28856 | 29 | |||
| 149897 | 56129 | Permitted Site 7 | Tree(s) :: 17 | 163 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12232 | 6017203.36392125 | 2103071.84165138 | 37.7555995666766 | -122.383451720598 | (37.7555995666766, -122.383451720598) | 10 | 3 | 8 | 28856 | 29 | |||
| 115680 | 56130 | Permitted Site 7 | Tree(s) :: 17 | 166 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1973 12:00:00 AM | Permit Number 12233 | 6017192.8194943 | 2103123.31621276 | 37.7557403222972 | -122.383491770137 | (37.7557403222972, -122.383491770137) | 10 | 3 | 8 | 28856 | 29 |
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) );