trees
1,746 rows where qSpecies_id = 10 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45562 | 42478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092450.71201 | 37.7253046451535 | -122.4522271205 | (37.7253046451535, -122.4522271205) | 9 | 7 | 4 | 28861 | 40 | ||
| 46046 | 95664 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 298 Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767424 | 6006728 | 2093095 | 37.7276208697995 | -122.41897129935 | (37.7276208697995, -122.41897129935) | 9 | 7 | 7 | 309 | 5 | |
| 46299 | 88611 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 10 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | 15 | 5 | 11 | 56 | 12 | ||
| 46444 | 33254 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2518 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | Permit Number 37432 | 5987089.34275763 | 2098119.32468859 | 37.7402909313254 | -122.487230356038 | (37.7402909313254, -122.487230356038) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | |||
| 47887 | 251342 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527 | 2093770 | 37.7286643609316 | -122.468112971633 | (37.7286643609316, -122.468112971633) | 9 | 8 | 4 | 59 | 40 | ||
| 48116 | 43271 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50498 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
| 48307 | 35895 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 225 Industrial St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | 10 | 3 | 8 | 58 | 1 | ||
| 49321 | 104879 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 234 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381 | 37.7849457229925 | -122.488145785283 | (37.7849457229925, -122.488145785283) | 11 | 6 | 1 | 55 | 33 | |||
| 49550 | 93529 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 50012 | 96691 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 50403 | 41405 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 50553 | 35272 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 251 Glenview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38755 | 5999077.63738514 | 2100785.4161936 | 37.7483031596888 | -122.44597148362 | (37.7483031596888, -122.44597148362) | 2 | 5 | 5 | 63 | 38 | ||
| 50765 | 41003 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 50768 | 46692 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44821 | 5990845.37275011 | 2105216.85962142 | 37.7599972171805 | -122.474761542285 | (37.7599972171805, -122.474761542285) | 1 | 8 | 4 | 56 | 12 | ||
| 50943 | 258449 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 51632 | 31156 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 291 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42627 | 5998170.06868325 | 2093774.97571129 | 37.7290023079752 | -122.448604988547 | (37.7290023079752, -122.448604988547) | 9 | 7 | 4 | 28861 | 40 | ||
| 52407 | 46691 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44820 | 5991711.18613678 | 2105195.27676174 | 37.7599880896107 | -122.471765566972 | (37.7599880896107, -122.471765566972) | 1 | 8 | 4 | 56 | 12 | ||
| 53606 | 40984 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
| 54332 | 40999 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 54479 | 42489 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092938.99301 | 37.7266456600516 | -122.452243583321 | (37.7266456600516, -122.452243583321) | 9 | 7 | 4 | 28861 | 40 | ||
| 54824 | 96690 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 54883 | 45147 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
| 55006 | 37915 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1310 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45463 | 6013387.28238112 | 2106643.29255824 | 37.7651943429343 | -122.396899403082 | (37.7651943429343, -122.396899403082) | 14 | 3 | 8 | 28856 | 20 | ||
| 55572 | 45145 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
| 56289 | 41397 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 56348 | 40503 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 160 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41573 | 5992838.9416153 | 2093905.66279134 | 37.7290548678482 | -122.467044439005 | (37.7290548678482, -122.467044439005) | 9 | 8 | 4 | 59 | 40 | ||
| 57653 | 45146 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
| 57889 | 42490 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092919.46201 | 37.7265921568632 | -122.452234673085 | (37.7265921568632, -122.452234673085) | 9 | 7 | 4 | 28861 | 40 | ||
| 57906 | 31613 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 367 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | Permit Number 35134 | 5987438.17691479 | 2113501.64932662 | 37.7825469127425 | -122.48715372973 | (37.7825469127425, -122.48715372973) | 11 | 6 | 2 | 55 | 26 | |||
| 58408 | 88609 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 10 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | 15 | 5 | 11 | 56 | 12 | ||
| 58457 | 39851 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
| 58827 | 40981 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1495 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | 10 | 3 | 8 | 28856 | 29 | |||
| 59094 | 42480 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092500.62501 | 37.7254416323021 | -122.452234471094 | (37.7254416323021, -122.452234471094) | 9 | 7 | 4 | 28861 | 40 | ||
| 59249 | 41008 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 59521 | 87862 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3944 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50815 | 6003369 | 2104810.4 | 37.7595989256918 | -122.431419361427 | (37.7595989256918, -122.431419361427) | 2 | 4 | 5 | 28862 | 3 | ||
| 59796 | 42432 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 158 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687 | (37.7283517896397, -122.44561415687) | 9 | 7 | 4 | 28861 | 40 | ||
| 61194 | 41408 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 61406 | 32501 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 42 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37006 | 6007173.83127039 | 2095597.26790323 | 37.7345166473806 | -122.417607327621 | (37.7345166473806, -122.417607327621) | 2 | 7 | 7 | 28859 | 2 | ||
| 61927 | 40469 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41554 | 5996794.30906624 | 2091457.62107189 | 37.7225606398038 | -122.453193843047 | (37.7225606398038, -122.453193843047) | 9 | 8 | 4 | 28861 | 24 | ||
| 62643 | 42025 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 171 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42348 | 5993627.24240997 | 2093940.95109531 | 37.7291972307793 | -122.464321804087 | (37.7291972307793, -122.464321804087) | 9 | 8 | 4 | 59 | 40 | ||
| 62729 | 44390 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
| 62792 | 45148 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
| 63309 | 96689 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 63649 | 39121 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 687x CAPP ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40805 | 6007356.9 | 2103329.2 | 37.755757100206 | -122.417522200164 | (37.755757100206, -122.417522200164) | 2 | 4 | 7 | 28859 | 19 | |||
| 63780 | 42406 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 500 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42570 | 5998771.97804914 | 2095002.7653646 | 37.7324079282936 | -122.446612451749 | (37.7324079282936, -122.446612451749) | 9 | 7 | 4 | 59 | 40 | ||
| 64845 | 42404 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 162 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42557 | 6000335.92086127 | 2094383.70532934 | 37.7307973438148 | -122.441161150695 | (37.7307973438148, -122.441161150695) | 9 | 7 | 4 | 63 | 40 | ||
| 64931 | 50508 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 502 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47143 | 6002555.80481261 | 2090259.94955548 | 37.7196006351228 | -122.433192127483 | (37.7196006351228, -122.433192127483) | 9 | 7 | 6 | 28861 | 5 | ||
| 65815 | 40983 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
| 66140 | 41005 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 66450 | 42328 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 640 Edna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42539 | 5998596.9019044 | 2094811.5025333 | 37.7318727635975 | -122.447203968283 | (37.7318727635975, -122.447203968283) | 9 | 7 | 4 | 59 | 40 | ||
| 66501 | 36928 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 901 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51504 | 6000612.32634681 | 2101962.60570598 | 37.7516229539892 | -122.440749012812 | (37.7516229539892, -122.440749012812) | 2 | 4 | 5 | 28862 | 22 | ||
| 66564 | 44385 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 185 Baltimore Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.7082528294853 | -122.433679745726 | (37.7082528294853, -122.433679745726) | 6 | 28861 | |||||
| 66597 | 50278 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 430 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46981 | 6005373.95050749 | 2095210.43455878 | 37.7333530449658 | -122.423802623394 | (37.7333530449658, -122.423802623394) | 2 | 7 | 7 | 28861 | 2 | ||
| 67054 | 42271 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1500 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | 1 | 8 | 3 | 56 | 35 | ||
| 67482 | 41023 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
| 67631 | 50052 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 695 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46783 | 6002430.83351351 | 2104175.19952785 | 37.7578016026102 | -122.434618585244 | (37.7578016026102, -122.434618585244) | 2 | 4 | 5 | 28862 | 3 | ||
| 67958 | 40986 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
| 68048 | 33801 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1411 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/1996 12:00:00 AM | Permit Number 37822 | 5989260.68046067 | 2105731.95209097 | 37.761319566555 | -122.480279867052 | (37.761319566555, -122.480279867052) | 1 | 8 | 3 | 56 | 35 | |||
| 68228 | 113666 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1435 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013045 | 2106578 | 37.7649960058226 | -122.398078702625 | (37.7649960058226, -122.398078702625) | 14 | 3 | 8 | 28856 | 29 | ||||
| 70455 | 42325 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 515 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42538 | 5998745.13338347 | 2094431.74877042 | 37.730838517872 | -122.446664189846 | (37.730838517872, -122.446664189846) | 9 | 7 | 4 | 59 | 40 | ||
| 70839 | 39123 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 685 CAPP ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40805 | 6007350.4 | 2103329.1 | 37.7557564598869 | -122.417544672216 | (37.7557564598869, -122.417544672216) | 2 | 4 | 7 | 28859 | 19 | |||
| 71437 | 42486 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997099.03001 | 2092780.57301 | 37.7262106140837 | -122.452235908179 | (37.7262106140837, -122.452235908179) | 9 | 7 | 4 | 28861 | 40 | ||
| 73184 | 40988 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
| 73342 | 42178 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 540 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42463 | 6010231.08590939 | 2108722.60367253 | 37.7707274675393 | -122.407962622683 | (37.7707274675393, -122.407962622683) | 8 | 2 | 9 | 28853 | 34 | |||
| 73418 | 40978 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1495 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | 10 | 3 | 8 | 28856 | 29 | |||
| 73608 | 34109 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1398 Plymouth Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 75168 | 46840 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 323 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44911 | 6004343.05626617 | 2090535.8229652 | 37.7204593479865 | -122.427033881485 | (37.7204593479865, -122.427033881485) | 9 | 7 | 6 | 28861 | 5 | ||
| 75379 | 44408 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Naples St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.7117159762558 | -122.437852856075 | (37.7117159762558, -122.437852856075) | 9 | 7 | 6 | 28861 | 5 | ||
| 75540 | 42420 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 516 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42887 | 5998662.31867711 | 2095004.42234287 | 37.7324062134589 | -122.446991687536 | (37.7324062134589, -122.446991687536) | 9 | 7 | 4 | 59 | 40 | ||
| 77095 | 41392 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 78286 | 42312 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 301 Edna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.7291070907004 | -122.446654155848 | (37.7291070907004, -122.446654155848) | 9 | 7 | 4 | 28861 | 40 | ||
| 78747 | 42431 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 158 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687 | (37.7283517896397, -122.44561415687) | 9 | 7 | 4 | 28861 | 40 | ||
| 79086 | 43261 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
| 79382 | 42270 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1500 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | 1 | 8 | 3 | 56 | 35 | ||
| 79398 | 42466 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 124 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47067 | 5998634.60353 | 2093230.01481651 | 37.7275325241875 | -122.446959862935 | (37.7275325241875, -122.446959862935) | 9 | 7 | 4 | 28861 | 40 | ||
| 79548 | 39805 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 80204 | 41001 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 81089 | 258450 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 82048 | 45361 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 494 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44186 | 5993280.54401179 | 2090440.20724826 | 37.7195650519649 | -122.465266177702 | (37.7195650519649, -122.465266177702) | 9 | 8 | 6 | 64 | 24 | ||
| 82207 | 43376 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 433 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43124 | 6001838.70393006 | 2103323.4801791 | 37.7554293540875 | -122.436605448479 | (37.7554293540875, -122.436605448479) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 83655 | 30864 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 265 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34702 | 6003455.83546905 | 2100949.65724805 | 37.7490031605747 | -122.430843516485 | (37.7490031605747, -122.430843516485) | 2 | 4 | 5 | 28862 | 22 | |||
| 84094 | 40498 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 44 Aptos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.7312920097199 | -122.466191234844 | (37.7312920097199, -122.466191234844) | 9 | 8 | 4 | 59 | 40 | ||
| 84184 | 41399 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 84542 | 42492 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997101.20001 | 2092826.14601 | 37.7263358710664 | -122.45223169354 | (37.7263358710664, -122.45223169354) | 9 | 7 | 4 | 28861 | 40 | ||
| 85564 | 40976 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1495 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | 10 | 3 | 8 | 28856 | 29 | |||
| 85751 | 96688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
| 86167 | 93521 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 88534 | 33076 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1462 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.407424585507 | (37.8002986697641, -122.407424585507) | 3 | 1 | 10 | 308 | 23 | ||
| 88590 | 42507 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 134 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42621 | 5999185.65268626 | 2093811.75019854 | 37.7291613007921 | -122.445096693184 | (37.7291613007921, -122.445096693184) | 9 | 7 | 4 | 28861 | 40 | ||
| 88727 | 99754 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 590 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001368 | 2100878 | 37.7486878919362 | -122.438058117383 | (37.7486878919362, -122.438058117383) | 2 | 4 | 5 | 28862 | 22 | ||||
| 91461 | 93531 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 91919 | 33078 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1462 Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.407424585507 | (37.8002986697641, -122.407424585507) | 3 | 1 | 10 | 308 | 23 | ||
| 92001 | 42314 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 200X STAPLES AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998726 | 2093843 | 37.7292208591283 | -122.446687991949 | (37.7292208591283, -122.446687991949) | 9 | 7 | 4 | 28861 | 40 | ||
| 92205 | 41393 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 93206 | 42451 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 534 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42594 | 5997888.12500218 | 2095286.48921964 | 37.7331364399295 | -122.449688562745 | (37.7331364399295, -122.449688562745) | 9 | 7 | 4 | 59 | 40 | ||
| 93284 | 34663 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2821 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38336 | 6003485.60145091 | 2118006.68224973 | 37.7958392495178 | -122.431958401499 | (37.7958392495178, -122.431958401499) | 13 | 9 | 1 | 57 | 17 | ||
| 93300 | 115199 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 363 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 777367 | 6002146.7 | 2103751.7 | 37.7566226407212 | -122.43557093896 | (37.7566226407212, -122.43557093896) | 2 | 4 | 5 | 28862 | 3 | |||
| 93303 | 31581 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1894 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35120 | 5988803.26989649 | 2102446.27193627 | 37.7522713821241 | -122.481621183041 | (37.7522713821241, -122.481621183041) | 1 | 8 | 3 | 56 | 35 |
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) );