trees
1,746 rows where qSpecies_id = 10 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4014 | 201331 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 95 Bitting Ave | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6012535.62971 | 2092785.01018 | 37.7270950209928 | -122.398872378676 | (37.7270950209928, -122.398872378676) | 10 | 3 | 8 | 58 | 1 | |||
| 4057 | 201274 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 210 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6013027.04362 | 2092751.29466 | 37.7270298147504 | -122.397171192319 | (37.7270298147504, -122.397171192319) | 10 | 3 | 8 | 58 | 1 | |||
| 4311 | 39593 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | 4 | Permit Number 41001 | 6012273.08907 | 2104003.23751 | 37.7578832555154 | -122.400567684363 | (37.7578832555154, -122.400567684363) | 10 | 3 | 8 | 28856 | 29 | ||
| 4340 | 202223 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013174.84825 | 2093025.0903 | 37.7277898291129 | -122.396679416033 | (37.7277898291129, -122.396679416033) | 10 | 3 | 8 | 58 | 1 | |||
| 5208 | 193661 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1744 Oakdale Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014300.46707 | 2096063.18282 | 37.7361943965519 | -122.393000575541 | (37.7361943965519, -122.393000575541) | 10 | 3 | 8 | 58 | 1 | |||
| 6490 | 177577 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 522 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008754 | 2093563 | 37.7290197747964 | -122.412000427453 | (37.7290197747964, -122.412000427453) | 9 | 3 | 7 | 309 | 28 | |||
| 6912 | 193566 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Illinois St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6016159.58282 | 2103474.73981 | 37.7566480969374 | -122.387089575435 | (37.7566480969374, -122.387089575435) | 10 | 3 | 8 | 28856 | 29 | |||
| 7032 | 202185 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Armstrong Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013201.16953 | 2093404.02127 | 37.7288317611548 | -122.396614974207 | (37.7288317611548, -122.396614974207) | 10 | 3 | 8 | 58 | 1 | ||||
| 7386 | 200783 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 McKinnon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 10 | 3 | 8 | 58 | 1 | |||
| 7831 | 43263 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 12 | 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 | ||
| 8028 | 193730 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 210 Channel | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014864.24714 | 2109891.31504 | 37.7741947972765 | -122.392018049996 | (37.7741947972765, -122.392018049996) | 14 | 3 | 9 | 310 | 20 | |||
| 8119 | 249075 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 89 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6013012 | 2090581 | 37.7210697875011 | -122.397071088995 | (37.7210697875011, -122.397071088995) | 10 | 3 | 8 | 58 | 1 | |||
| 8733 | 193669 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 255 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016408.23667 | 2108979.54137 | 37.7717768665387 | -122.386613473459 | (37.7717768665387, -122.386613473459) | 3 | 9 | 310 | 20 | ||||
| 8875 | 193652 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2141 Oakdale Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6012072.86393 | 2097652.92355 | 37.7404354977101 | -122.400814014067 | (37.7404354977101, -122.400814014067) | 10 | 3 | 8 | 58 | 1 | |||
| 9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
| 10448 | 202192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1928 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013154.16149 | 2093432.67733 | 37.7289078285177 | -122.396779493476 | (37.7289078285177, -122.396779493476) | 10 | 3 | 8 | 58 | 1 | ||||
| 10925 | 249073 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 78 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6012976.71638 | 2090666.07234 | 37.721301414799 | -122.397199017345 | (37.721301414799, -122.397199017345) | 10 | 3 | 8 | 58 | 1 | |||
| 12261 | 177534 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 502 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010094.64304 | 2092221.19547 | 37.7254105881115 | -122.407271149051 | (37.7254105881115, -122.407271149051) | 10 | 3 | 7 | 309 | 28 | |||
| 13054 | 201281 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 38 Lydia Ave | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012822.1573 | 2092867.77977 | 37.7273382507444 | -122.397887653412 | (37.7273382507444, -122.397887653412) | 10 | 3 | 8 | 58 | 1 | |||
| 13173 | 25969 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2121 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012170.05975 | 2097512.80398 | 37.7400561799102 | -122.400468107084 | (37.7400561799102, -122.400468107084) | 10 | 3 | 8 | 58 | 1 | ||
| 13175 | 30752 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | 10 | 3 | 8 | 58 | 1 |
| 13681 | 27548 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 8 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
| 13719 | 264662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1070 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014517.40872 | 2089968.05117 | 37.7194704392608 | -122.391824453064 | (37.7194704392608, -122.391824453064) | 10 | 3 | 8 | 58 | 1 | |||
| 15074 | 61794 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2112 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 11 | Permit Number 21817 | 6012105.79225 | 2102838.47853 | 37.7546757515047 | -122.401064430306 | (37.7546757515047, -122.401064430306) | 10 | 3 | 8 | 28856 | 29 | |
| 15471 | 27568 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 15475 | 148112 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 509 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4x5 | 6010229.36415 | 2091734.22439 | 37.7240810061078 | -122.406771124199 | (37.7240810061078, -122.406771124199) | 10 | 3 | 7 | 309 | 28 | |||
| 16397 | 200789 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1614 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015325 | 2096036 | 37.7361766159661 | -122.389456416811 | (37.7361766159661, -122.389456416811) | 10 | 3 | 8 | 58 | 1 | |||
| 16479 | 193722 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1500 Owen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013875.94265 | 2107923.76341 | 37.7687374206141 | -122.395298938712 | (37.7687374206141, -122.395298938712) | 14 | 3 | 9 | 310 | 20 | |||
| 17891 | 201310 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 9 Lydia Ave | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012935.48709 | 2092735.05755 | 37.7269801335046 | -122.397486565679 | (37.7269801335046, -122.397486565679) | 10 | 3 | 8 | 58 | 1 | |||
| 18135 | 193744 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 106 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016631.20601 | 2095628.77258 | 37.7351307863641 | -122.384911922862 | (37.7351307863641, -122.384911922862) | 10 | 3 | 8 | 58 | 1 | |||
| 18586 | 1979 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.3743209 | 2094812.8777717 | 37.7329560922326 | -122.380750713036 | (37.7329560922326, -122.380750713036) | 10 | 3 | 8 | 58 | 1 | ||
| 20188 | 25908 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1744 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1997 12:00:00 AM | 6 | 3X3 | 6014300.07795 | 2096067.04044 | 37.7362049671689 | -122.393002190722 | (37.7362049671689, -122.393002190722) | 10 | 3 | 8 | 58 | 1 | ||
| 20247 | 41013 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 1 | 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 | |||
| 20726 | 193574 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Illinois St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016138.78787 | 2103882.6002 | 37.7577668436722 | -122.387189940687 | (37.7577668436722, -122.387189940687) | 10 | 3 | 8 | 28856 | 29 | |||
| 21054 | 202253 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013211.00283 | 2093308.76677 | 37.7285707590106 | -122.396574305077 | (37.7285707590106, -122.396574305077) | 10 | 3 | 8 | 58 | 1 | |||
| 21519 | 43264 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 10 | 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 | ||
| 21638 | 177578 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 242 Hale St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6009395.15494 | 2094572.30852 | 37.731827072866 | -122.409855114442 | (37.731827072866, -122.409855114442) | 10 | 3 | 7 | 309 | 28 | |||
| 21736 | 202247 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013203.9034 | 2093250.17887 | 37.7284094934863 | -122.396594743075 | (37.7284094934863, -122.396594743075) | 10 | 3 | 8 | 58 | 1 | |||
| 22060 | 201295 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 77 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012646.29133 | 2092949.94041 | 37.7275540511672 | -122.39850138854 | (37.7275540511672, -122.39850138854) | 10 | 3 | 8 | 58 | 1 | |||
| 22220 | 40990 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 4 | 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 | |||
| 22247 | 193723 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 Owen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013916.41487 | 2107877.23111 | 37.7686119040458 | -122.395155687479 | (37.7686119040458, -122.395155687479) | 14 | 3 | 9 | 310 | 20 | |||
| 22260 | 24175 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 95X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 6 | 4x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
| 22303 | 201289 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 72 Lydia Ave | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012662.53869 | 2092985.79759 | 37.7276534127642 | -122.398447735869 | (37.7276534127642, -122.398447735869) | 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 | |||
| 22564 | 191757 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Owen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014146.70674 | 2107631.58061 | 37.76795020627 | -122.394341918847 | (37.76795020627, -122.394341918847) | 14 | 3 | 9 | 310 | 20 | |
| 22701 | 191771 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1700 Owen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014456.78592 | 2107294.74285 | 37.7670425555978 | -122.393245808049 | (37.7670425555978, -122.393245808049) | 14 | 3 | 9 | 310 | 20 | |
| 22801 | 193603 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2001 25th St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6012529.65643 | 2101837.23343 | 37.7519501860606 | -122.399528292892 | (37.7519501860606, -122.399528292892) | 10 | 3 | 8 | 28856 | 29 | |||
| 22880 | 40985 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 12 | 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 | |||
| 23091 | 27563 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 23634 | 193662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1748 Oakdale Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014283.43423 | 2096079.37448 | 37.7362379093615 | -122.39306059808 | (37.7362379093615, -122.39306059808) | 10 | 3 | 8 | 58 | 1 | |||
| 23758 | 193643 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2000 Oakdale Ave | 7 | : | Tree | Private 2 | 14 | Width 3ft | 6012803.91355 | 2097182.00336 | 37.7391831989548 | -122.398253282685 | (37.7391831989548, -122.398253282685) | 10 | 3 | 8 | 58 | 1 | |||
| 23974 | 25963 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2165X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012113.82333 | 2097630.4428 | 37.7403760548667 | -122.400670812787 | (37.7403760548667, -122.400670812787) | 10 | 3 | 8 | 58 | 1 | ||
| 24101 | 35896 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 225 Industrial St | 3 | 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 | ||
| 24142 | 25980 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1951 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 18 | 3x3 | 6013173.42584 | 2096838.91364 | 37.738261722099 | -122.396951618345 | (37.738261722099, -122.396951618345) | 10 | 3 | 8 | 58 | 1 | ||
| 25026 | 202218 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013169.31452 | 2092974.31986 | 37.7276501158438 | -122.396694988704 | (37.7276501158438, -122.396694988704) | 10 | 3 | 8 | 58 | 1 | |||
| 25413 | 24111 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 180X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/1997 12:00:00 AM | 6 | 3X3 | 6016348.1117358 | 2095906.4833443 | 37.7358776620103 | -122.38591004253 | (37.7358776620103, -122.38591004253) | 10 | 3 | 8 | 58 | 1 | ||
| 25486 | 24126 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 140X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1997 12:00:00 AM | 9 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
| 25598 | 27634 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 245X Industrial St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010692.9519893 | 2096884.4242044 | 37.7382482984797 | -122.405531120584 | (37.7382482984797, -122.405531120584) | 10 | 3 | 8 | 58 | 1 | |||
| 26101 | 193706 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Owen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013673.45389 | 2108376.61913 | 37.7699695979404 | -122.396031076772 | (37.7699695979404, -122.396031076772) | 14 | 3 | 9 | 310 | 20 | |||
| 26495 | 42983 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 27013 | 10861 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X HUDSON AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 27275 | 43268 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 4 | 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 | ||
| 27916 | 1947 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 12 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.7338931798791 | -122.381526972425 | (37.7338931798791, -122.381526972425) | 10 | 3 | 8 | 58 | 1 | ||
| 28180 | 202242 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013197.35794 | 2093205.03586 | 37.7282851757099 | -122.396614207973 | (37.7282851757099, -122.396614207973) | 10 | 3 | 8 | 58 | 1 | |||
| 28237 | 201279 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 30 Lydia Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012855.91167 | 2092842.97051 | 37.7272720093701 | -122.397769224371 | (37.7272720093701, -122.397769224371) | 10 | 3 | 8 | 58 | 1 | |||
| 28340 | 25975 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2065 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2015 12:54:00 PM | 3 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | 10 | 3 | 8 | 58 | 1 | ||
| 28571 | 191760 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Owen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014227.64463 | 2107550.44075 | 37.7677319129348 | -122.394056280688 | (37.7677319129348, -122.394056280688) | 14 | 3 | 9 | 310 | 20 | |
| 28943 | 193697 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1455 Owen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6013756.35149 | 2108246.00277 | 37.769615566344 | -122.395735180048 | (37.769615566344, -122.395735180048) | 14 | 3 | 9 | 310 | 20 | |||
| 29387 | 202221 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013173.04643 | 2093005.64291 | 37.7277363302611 | -122.396684282259 | (37.7277363302611, -122.396684282259) | 10 | 3 | 8 | 58 | 1 | |||
| 29795 | 193559 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016173.80589 | 2103231.19254 | 37.7559801551674 | -122.387023400616 | (37.7559801551674, -122.387023400616) | 10 | 3 | 8 | 28856 | 29 | |||
| 29850 | 43267 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 5 | 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 | ||
| 29917 | 106954 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 29 Lydia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012839.09683 | 2092807.12473 | 37.727172647775 | -122.397824840259 | (37.727172647775, -122.397824840259) | 10 | 3 | 8 | 58 | 1 | |||
| 30169 | 27537 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.08872 | 2102884.43561 | 37.7550260005701 | -122.387126196736 | (37.7550260005701, -122.387126196736) | 10 | 3 | 8 | 28856 | 29 | ||
| 30669 | 40998 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 13 | 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 | |||
| 30875 | 24170 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 95X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2004 12:00:00 AM | 8 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
| 30929 | 202226 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013177.60207 | 2093049.8453 | 37.7278579545638 | -122.396671630611 | (37.7278579545638, -122.396671630611) | 10 | 3 | 8 | 58 | 1 | |||
| 31099 | 27559 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 31141 | 10854 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1299X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1998 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 31589 | 193685 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1555 Owen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013968.42105 | 2107894.95575 | 37.7686634639702 | -122.394977042581 | (37.7686634639702, -122.394977042581) | 14 | 3 | 9 | 310 | 20 | |||
| 31994 | 202252 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013209.67836 | 2093298.98157 | 37.7285438171377 | -122.396578198225 | (37.7285438171377, -122.396578198225) | 10 | 3 | 8 | 58 | 1 | |||
| 32010 | 41022 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 3 | 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 | |||
| 32103 | 27561 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 32756 | 193683 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 256 Terry A Francois Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6016363.57029 | 2108841.94978 | 37.7713965972171 | -122.386758382111 | (37.7713965972171, -122.386758382111) | 14 | 3 | 9 | 310 | 20 | |||
| 32813 | 27552 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 32975 | 56049 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 345 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 14 | Permit Number 12137 | 6014083.6423 | 2105399.63652 | 37.7618182724049 | -122.394403757141 | (37.7618182724049, -122.394403757141) | 10 | 3 | 8 | 28856 | 29 | ||
| 33044 | 25544 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 245X Industrial St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6010692.9519893 | 2096884.4242044 | 37.7382482984797 | -122.405531120584 | (37.7382482984797, -122.405531120584) | 10 | 3 | 8 | 58 | 1 | |||
| 33083 | 193705 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Owen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013669.23719 | 2108401.63413 | 37.770038048944 | -122.396047415657 | (37.770038048944, -122.396047415657) | 14 | 3 | 9 | 310 | 20 | |||
| 33183 | 39330 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 0 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.384018475054 | (37.7603812969624, -122.384018475054) | 10 | 3 | 8 | 310 | 29 | |||
| 33331 | 193756 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 618 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6016336.61649 | 2097223.03863 | 37.7394920207503 | -122.386041534315 | (37.7394920207503, -122.386041534315) | 10 | 3 | 8 | 58 | 1 | |||
| 34110 | 193702 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1455 Owen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013729.28449 | 2108364.68239 | 37.7699399284016 | -122.395837121787 | (37.7699399284016, -122.395837121787) | 14 | 3 | 9 | 310 | 20 | |||
| 34385 | 93523 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||||
| 34824 | 25925 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1997 12:00:00 AM | 12 | 3x3 | 6013379.37918 | 2096773.80644 | 37.7380944133833 | -122.396234966455 | (37.7380944133833, -122.396234966455) | 10 | 3 | 8 | 58 | 1 | ||
| 35122 | 202186 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Armstrong Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013197.89366 | 2093408.01538 | 37.7288425458475 | -122.396626579067 | (37.7288425458475, -122.396626579067) | 10 | 3 | 8 | 58 | 1 | ||||
| 35192 | 202126 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2801 Newhall St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6012542.38244 | 2092989.65418 | 37.7276573077388 | -122.39886339085 | (37.7276573077388, -122.39886339085) | 10 | 3 | 8 | 58 | 1 | |||
| 35229 | 177538 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 502 Wayland St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009941.38457 | 2092176.41263 | 37.7252790451735 | -122.407797795647 | (37.7252790451735, -122.407797795647) | 10 | 3 | 7 | 309 | 28 | |||
| 35345 | 193610 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2070 Jerrold Ave | 3 | : | Tree | Private 2 | 14 | Width 2ft | 6012844.28884 | 2098884.12609 | 37.7438591178124 | -122.398233071296 | (37.7438591178124, -122.398233071296) | 10 | 3 | 8 | 58 | 1 | |||
| 36230 | 26120 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1469 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6015722.0682 | 2094937.3446 | 37.7331819371912 | -122.388006934363 | (37.7331819371912, -122.388006934363) | 10 | 3 | 8 | 58 | 1 | ||
| 37005 | 25924 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6013360.04633 | 2096769.62618 | 37.7380818594982 | -122.396301517325 | (37.7380818594982, -122.396301517325) | 10 | 3 | 8 | 58 | 1 | ||
| 37012 | 54473 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.35242 | 2095372.33986 | 37.73418801986 | -122.399753247508 | (37.73418801986, -122.399753247508) | 10 | 3 | 8 | 58 | 1 | ||
| 37242 | 39591 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41001 | 6012325.10844747 | 2103966.01708403 | 37.7577839574034 | -122.400385164113 | (37.7577839574034, -122.400385164113) | 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) );