trees
27,746 rows where qCaretaker_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149147 | 10530 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2004 12:00:00 AM | 3 | 3X4 | 6018595.5303624 | 2094415.327074 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | 10 | 3 | 8 | 58 | 1 | ||
| 67113 | 11525 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018584.76615 | 2096814.86638 | 37.7384954262103 | -122.378240000085 | (37.7384954262103, -122.378240000085) | 10 | 3 | 8 | 58 | 1 | |||
| 155193 | 3544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 54 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6018582.49326 | 2097682.52078 | 37.740877707832 | -122.378308077855 | (37.740877707832, -122.378308077855) | 10 | 3 | 8 | 58 | 1 | |||
| 139069 | 191800 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2 Newhall St | 5 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.7394387323227 | -122.378278760853 | (37.7394387323227, -122.378278760853) | 10 | 3 | 8 | 58 | 1 | |
| 114848 | 10539 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018576.7086503 | 2094524.5653192 | 37.7322062650142 | -122.378108918967 | (37.7322062650142, -122.378108918967) | 10 | 3 | 8 | 58 | 1 | |||
| 44207 | 11524 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) | 10 | 3 | 8 | 58 | 1 | |||
| 83497 | 3543 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 53 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6018555.97345 | 2097704.22378 | 37.7409358382167 | -122.378401280909 | (37.7409358382167, -122.378401280909) | 10 | 3 | 8 | 58 | 1 | ||
| 51483 | 187609 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 100 Northridge Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
| 154670 | 187610 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 100 Northridge Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
| 172245 | 187611 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
| 33892 | 191798 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2 Newhall St | 3 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.98738 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | 10 | 3 | 8 | 58 | 1 | |
| 109844 | 10537 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 125 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018546.167565 | 2094480.7523869 | 37.7320842800278 | -122.37821146712 | (37.7320842800278, -122.37821146712) | 10 | 3 | 8 | 58 | 1 | ||
| 72427 | 11522 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018545.03968 | 2096763.44764 | 37.738352050906 | -122.378373787728 | (37.738352050906, -122.378373787728) | 10 | 3 | 8 | 58 | 1 | |||
| 19437 | 3542 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | 10 | 3 | 8 | 58 | 1 | ||
| 130128 | 11521 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018533.50828 | 2096747.47411 | 37.7383075551437 | -122.378412549408 | (37.7383075551437, -122.378412549408) | 10 | 3 | 8 | 58 | 1 | |||
| 158652 | 10542 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 152 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018532.0220048 | 2094598.6111286 | 37.7324071175203 | -122.378268551007 | (37.7324071175203, -122.378268551007) | 10 | 3 | 8 | 58 | 1 | |||
| 22721 | 199372 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2 Newhall St | 2 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.378455061265 | (37.7395514542225, -122.378455061265) | 10 | 3 | 8 | 58 | 1 | |
| 188340 | 3541 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 07:57:00 AM | 3 | 3X3 | 6018523.03476 | 2097728.36014 | 37.7410002962211 | -122.378516847395 | (37.7410002962211, -122.378516847395) | 10 | 3 | 8 | 58 | 1 | ||
| 185086 | 11523 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018517.10401 | 2096771.58701 | 37.7383728601739 | -122.378470941616 | (37.7383728601739, -122.378470941616) | 10 | 3 | 8 | 58 | 1 | |||
| 169234 | 10543 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 162 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018511.4162901 | 2094632.7637106 | 37.7324997581179 | -122.378342160759 | (37.7324997581179, -122.378342160759) | 10 | 3 | 8 | 58 | 1 | |||
| 32154 | 3540 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6018504.91252 | 2097742.5518 | 37.7410382647176 | -122.37858049329 | (37.7410382647176, -122.37858049329) | 10 | 3 | 8 | 58 | 1 | |||
| 88585 | 10540 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 145 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1995 12:00:00 AM | 12 | 3X4 | 6018503.7558349 | 2094548.6734852 | 37.732268440528 | -122.378362809128 | (37.732268440528, -122.378362809128) | 10 | 3 | 8 | 58 | 1 | ||
| 183424 | 10541 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2004 12:00:00 AM | 3 | 3X4 | 6018503.7558349 | 2094548.6734852 | 37.732268440528 | -122.378362809128 | (37.732268440528, -122.378362809128) | 10 | 3 | 8 | 58 | 1 | ||
| 659 | 11520 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | 10 | 3 | 8 | 58 | 1 | ||
| 155786 | 3539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 08:08:00 AM | 3 | 3X3 | 6018487.88793 | 2097755.11327 | 37.7410718175127 | -122.378640230766 | (37.7410718175127, -122.378640230766) | 10 | 3 | 8 | 58 | 1 | ||
| 185932 | 11519 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018482.73466 | 2096678.89934 | 37.7381164636019 | -122.378583341463 | (37.7381164636019, -122.378583341463) | 10 | 3 | 8 | 58 | 1 | |||
| 135912 | 3538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 10:28:00 AM | 3 | 3X3 | 6018470.22426 | 2097768.00954 | 37.7411062543397 | -122.37870220127 | (37.7411062543397, -122.37870220127) | 10 | 3 | 8 | 58 | 1 | ||
| 33732 | 11518 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018467.96004 | 2096661.77747 | 37.7380686358665 | -122.378633236729 | (37.7380686358665, -122.378633236729) | 10 | 3 | 8 | 58 | 1 | |||
| 53486 | 10545 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 165 Harbor Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018463.1504559 | 2094615.9741616 | 37.7324509968428 | -122.378507863775 | (37.7324509968428, -122.378507863775) | 10 | 3 | 8 | 58 | 1 | ||
| 163991 | 10544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 165 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/1992 12:00:00 AM | 12 | 3X4 | 6018463.1504559 | 2094615.9741616 | 37.7324509968428 | -122.378507863775 | (37.7324509968428, -122.378507863775) | 10 | 3 | 8 | 58 | 1 | ||
| 141930 | 11517 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018459.10272 | 2096646.15543 | 37.738025252555 | -122.378662776785 | (37.738025252555, -122.378662776785) | 10 | 3 | 8 | 58 | 1 | |||
| 95148 | 3537 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 10:33:00 AM | 3 | 3X3 | 6018452.88971 | 2097781.22053 | 37.7411415734369 | -122.378763055689 | (37.7411415734369, -122.378763055689) | 10 | 3 | 8 | 58 | 1 | ||
| 93741 | 10532 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018450.64792 | 2094649.30839 | 37.7325418369384 | -122.378553402125 | (37.7325418369384, -122.378553402125) | 10 | 3 | 8 | 58 | 1 | |||
| 51353 | 11516 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018445.80461 | 2096632.24283 | 37.7379863182046 | -122.378707789643 | (37.7379863182046, -122.378707789643) | 10 | 3 | 8 | 58 | 1 | |||
| 146747 | 11515 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018435.75987 | 2096618.26492 | 37.7379473838671 | -122.378741549297 | (37.7379473838671, -122.378741549297) | 10 | 3 | 8 | 58 | 1 | |||
| 29093 | 3536 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018434.89697 | 2097793.80147 | 37.7411751262232 | -122.378826142235 | (37.7411751262232, -122.378826142235) | 10 | 3 | 8 | 58 | 1 | ||
| 58168 | 10548 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 202 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018423.7953453 | 2094769.0987502 | 37.7328692775901 | -122.378654553799 | (37.7328692775901, -122.378654553799) | 10 | 3 | 8 | 58 | 1 | |||
| 136551 | 10546 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 187 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/1995 12:00:00 AM | 12 | 3X4 | 6018418.3027239 | 2094690.3062519 | 37.7326526259914 | -122.378668074213 | (37.7326526259914, -122.378668074213) | 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 | ||
| 150495 | 3535 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 08:14:00 AM | 3 | 3X3 | 6018417.72714 | 2097807.16999 | 37.7412108868837 | -122.378886438158 | (37.7412108868837, -122.378886438158) | 10 | 3 | 8 | 58 | 1 | ||
| 187761 | 11513 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018414.43418 | 2096589.52395 | 37.7378672911411 | -122.378813288221 | (37.7378672911411, -122.378813288221) | 10 | 3 | 8 | 58 | 1 | |||
| 117068 | 11514 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 101X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018414.23901 | 2096612.73301 | 37.7379310078681 | -122.378815574261 | (37.7379310078681, -122.378815574261) | 10 | 3 | 8 | 58 | 1 | ||
| 11900 | 3534 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.12937 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | 10 | 3 | 8 | 58 | 1 | ||
| 125265 | 11512 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018400.60741 | 2096569.54507 | 37.7378116707805 | -122.378859707612 | (37.7378116707805, -122.378859707612) | 10 | 3 | 8 | 58 | 1 | |||
| 142676 | 188643 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 2 | Median : Yard | Tree | DPW 1 | 17 | 6018388.81738 | 2097879.37789 | 37.7414075614118 | -122.378991412446 | (37.7414075614118, -122.378991412446) | 10 | 3 | 8 | 58 | 1 | ||||
| 194201 | 11511 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 6018385.91854 | 2096547.1526 | 37.7377493756286 | -122.378908940096 | (37.7377493756286, -122.378908940096) | 10 | 3 | 8 | 58 | 1 | |||
| 156049 | 3533 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 43 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:14:00 AM | 3 | 3X3 | 6018385.25343 | 2097830.33229 | 37.7412726954727 | -122.379000330107 | (37.7412726954727, -122.379000330107) | 10 | 3 | 8 | 58 | 1 | ||
| 105027 | 10549 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 203 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1995 12:00:00 AM | 12 | 3X4 | 6018384.1058213 | 2094738.5988017 | 37.7327833426307 | -122.3787896549 | (37.7327833426307, -122.3787896549) | 10 | 3 | 8 | 58 | 1 | ||
| 186975 | 10552 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 Harbor Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1995 12:00:00 AM | 6 | 3X4 | 6018373.674298 | 2094816.1785077 | 37.7329957862202 | -122.378831105158 | (37.7329957862202, -122.378831105158) | 10 | 3 | 8 | 58 | 1 | ||
| 146365 | 3532 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018368.40332 | 2097843.5336 | 37.7413080145474 | -122.379059509092 | (37.7413080145474, -122.379059509092) | 10 | 3 | 8 | 58 | 1 | ||
| 179311 | 3531 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018350.91064 | 2097856.90864 | 37.741343775188 | -122.379120922001 | (37.741343775188, -122.379120922001) | 10 | 3 | 8 | 58 | 1 | ||
| 159802 | 10550 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 217 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018348.7736836 | 2094772.4250311 | 37.7328742748645 | -122.378914156582 | (37.7328742748645, -122.378914156582) | 10 | 3 | 8 | 58 | 1 | ||
| 96733 | 10553 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 226 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018348.1580948 | 2094834.9465854 | 37.7330459128793 | -122.378920625217 | (37.7330459128793, -122.378920625217) | 10 | 3 | 8 | 58 | 1 | |||
| 168104 | 11001 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018345.6932697 | 2094533.4513275 | 37.7322179299469 | -122.378908216579 | (37.7322179299469, -122.378908216579) | 10 | 3 | 8 | 58 | 1 | |||
| 24969 | 258214 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6018341.5004 | 2094530.72341 | 37.7322102084437 | -122.378922523056 | (37.7322102084437, -122.378922523056) | 10 | 3 | 8 | 58 | 1 | ||||
| 33496 | 6444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100X Evans Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 33992 | 6437 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 75964 | 6445 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1100X Evans Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/1999 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 87816 | 6441 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 112999 | 6446 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1997 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 113007 | 6438 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1998 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 129789 | 6435 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 159877 | 6443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 184314 | 6433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100X Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 187020 | 6432 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 187115 | 6436 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 44155 | 3530 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 40 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018336.58816 | 2097867.32601 | 37.7413715894385 | -122.379171168028 | (37.7413715894385, -122.379171168028) | 10 | 3 | 8 | 58 | 1 | ||
| 143464 | 10554 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 234 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018322.6418917 | 2094853.7146631 | 37.7330960394699 | -122.379010145396 | (37.7330960394699, -122.379010145396) | 10 | 3 | 8 | 58 | 1 | |||
| 23680 | 10997 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018318.9881754 | 2094475.1533635 | 37.732056382705 | -122.378996495822 | (37.732056382705, -122.378996495822) | 10 | 3 | 8 | 58 | 1 | |||
| 48525 | 188644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | 10 | 3 | 8 | 58 | 1 | ||||
| 89493 | 3529 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 39 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018316.85209 | 2097881.54987 | 37.7414095570002 | -122.379240396934 | (37.7414095570002, -122.379240396934) | 10 | 3 | 8 | 58 | 1 | ||
| 94950 | 11004 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 40 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018314.1623349 | 2094585.1363671 | 37.7323581084588 | -122.379020815535 | (37.7323581084588, -122.379020815535) | 10 | 3 | 8 | 58 | 1 | |||
| 58804 | 6420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | 10 | 3 | 8 | 58 | 1 | ||
| 107420 | 3528 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2017 04:23:00 PM | 3 | 3X3 | 6018298.55272 | 2097894.94115 | 37.7414453176516 | -122.379304600428 | (37.7414453176516, -122.379304600428) | 10 | 3 | 8 | 58 | 1 | ||
| 135727 | 11005 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018298.3968675 | 2094610.9788869 | 37.7324281976732 | -122.379077115172 | (37.7324281976732, -122.379077115172) | 10 | 3 | 8 | 58 | 1 | |||
| 170602 | 11002 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 25 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018294.3685242 | 2094521.575214 | 37.7321824905391 | -122.379084835175 | (37.7321824905391, -122.379084835175) | 10 | 3 | 8 | 58 | 1 | |||
| 76974 | 10555 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 235 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018292.0710099 | 2094814.1318704 | 37.7329856672092 | -122.379113090009 | (37.7329856672092, -122.379113090009) | 10 | 3 | 8 | 58 | 1 | |||
| 104724 | 11007 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 60 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018282.6314 | 2094636.8214067 | 37.7324982868599 | -122.379133414916 | (37.7324982868599, -122.379133414916) | 10 | 3 | 8 | 58 | 1 | |||
| 61851 | 10557 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 250 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/1998 12:00:00 AM | 6 | 3X4 | 6018271.6094853 | 2094891.2508185 | 37.7331962924458 | -122.379189186118 | (37.7331962924458, -122.379189186118) | 10 | 3 | 8 | 58 | 1 | ||
| 36780 | 3526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018266.26649 | 2097919.38603 | 37.741510657882 | -122.379417933909 | (37.741510657882, -122.379417933909) | 10 | 3 | 8 | 58 | 1 | ||
| 49610 | 6423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6018250.03314 | 2096623.41897 | 37.7379512950012 | -122.379384062749 | (37.7379512950012, -122.379384062749) | 10 | 3 | 8 | 58 | 1 | |||
| 190847 | 3525 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018249.90262 | 2097930.34785 | 37.7415398543705 | -122.379475276478 | (37.7415398543705, -122.379475276478) | 10 | 3 | 8 | 58 | 1 | ||
| 175772 | 11006 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 55 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018247.9816681 | 2094597.6118588 | 37.7323887144105 | -122.37925048612 | (37.7323887144105, -122.37925048612) | 10 | 3 | 8 | 58 | 1 | |||
| 112496 | 6424 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 12:46:00 PM | 3 | 3x3 | 6018234.67827 | 2096633.8011 | 37.7379789554566 | -122.379437873653 | (37.7379789554566, -122.379437873653) | 10 | 3 | 8 | 58 | 1 | ||
| 24015 | 3524 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 201X Cargo Way | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:27:00 AM | 3 | 3X3 | 6018232.23392 | 2097945.31305 | 37.7415799713464 | -122.379537408844 | (37.7415799713464, -122.379537408844) | 10 | 3 | 8 | 58 | 1 | ||
| 37468 | 10559 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 266 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 18 | 3X4 | 6018220.577079 | 2094928.7869738 | 37.7332965451478 | -122.379368227321 | (37.7332965451478, -122.379368227321) | 10 | 3 | 8 | 58 | 1 | ||
| 134873 | 6425 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1100X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2003 12:00:00 AM | 12 | 3x3 | 6018217.31109 | 2096647.32337 | 37.7380151271058 | -122.379498860299 | (37.7380151271058, -122.379498860299) | 10 | 3 | 8 | 58 | 1 | ||
| 25283 | 3523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.49501 | 37.7416152904271 | -122.379593238756 | (37.7416152904271, -122.379593238756) | 10 | 3 | 8 | 58 | 1 | ||
| 120606 | 11009 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 80 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018206.0401963 | 2094670.6666495 | 37.7325869956158 | -122.379400561989 | (37.7325869956158, -122.379400561989) | 10 | 3 | 8 | 58 | 1 | |||
| 71100 | 3522 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018199.47638 | 2097970.41074 | 37.7416470778412 | -122.379652417727 | (37.7416470778412, -122.379652417727) | 10 | 3 | 8 | 58 | 1 | ||
| 77595 | 11010 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 85 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018199.1590574 | 2094619.5131788 | 37.7324461587057 | -122.379420799908 | (37.7324461587057, -122.379420799908) | 10 | 3 | 8 | 58 | 1 | |||
| 102956 | 85559 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977749 | 2092810.892369 | 37.727479421244 | -122.379333871981 | (37.727479421244, -122.379333871981) | 10 | 3 | 8 | 58 | 1 | ||
| 160107 | 85560 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977749 | 2092810.892369 | 37.727479421244 | -122.379333871981 | (37.727479421244, -122.379333871981) | 10 | 3 | 8 | 58 | 1 | ||
| 88054 | 29774 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1100X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 12:44:00 PM | 3 | 3x3 | 6018183.3236 | 2096672.8034 | 37.7380832156692 | -122.379618142779 | (37.7380832156692, -122.379618142779) | 10 | 3 | 8 | 58 | 1 | ||
| 154283 | 3521 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | 10 | 3 | 8 | 58 | 1 | |||
| 57992 | 11012 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 95 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018177.8841382 | 2094612.4287261 | 37.7324255328509 | -122.379493861146 | (37.7324255328509, -122.379493861146) | 10 | 3 | 8 | 58 | 1 | |||
| 83991 | 11013 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 95 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018177.8841382 | 2094612.4287261 | 37.7324255328509 | -122.379493861146 | (37.7324255328509, -122.379493861146) | 10 | 3 | 8 | 58 | 1 | |||
| 22069 | 11203 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1001X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
| 22332 | 11205 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
| 30226 | 11204 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );