trees
3,247 rows where qSpecies_id = 22 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180271 | 31874 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35313 | 6015646.39129 | 2113195.50947 | 37.7833107698248 | -122.389543258739 | (37.7833107698248, -122.389543258739) | 6 | 2 | 9 | 28856 | 6 | ||
| 18317 | 115576 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6015313.29826 | 2096960.63807 | 37.7387148347127 | -122.389561431329 | (37.7387148347127, -122.389561431329) | 10 | 3 | 8 | 58 | 1 | |||
| 55326 | 190516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6015623.81724 | 2113280.84132 | 37.7835438201345 | -122.389627318361 | (37.7835438201345, -122.389627318361) | 6 | 2 | 9 | 28856 | 6 | |||
| 50660 | 108590 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900x Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6015291.6077 | 2096931.09034 | 37.7386324999809 | -122.38963436456 | (37.7386324999809, -122.38963436456) | 10 | 3 | 8 | 58 | 1 | |||
| 92243 | 190517 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6015620.20689 | 2113286.09542 | 37.7835580465152 | -122.389640175967 | (37.7835580465152, -122.389640175967) | 6 | 2 | 9 | 28856 | 6 | |||
| 138331 | 190609 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015498.37431 | 2107537.59988 | 37.767767198735 | -122.389660047398 | (37.767767198735, -122.389660047398) | 14 | 3 | 9 | 310 | 20 | |||
| 122315 | 44200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2018 12:00:00 AM | 3 | Permit Number 43651 | 6015644.9623 | 2115187.5878 | 37.7887804851876 | -122.389687383164 | (37.7887804851876, -122.389687383164) | 6 | 2 | 9 | 28855 | 6 | ||
| 2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 72070 | 39876 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | ||
| 95647 | 44199 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2018 12:00:00 AM | 3 | Permit Number 43651 | 6015629.81658 | 2115174.24288 | 37.7887430032356 | -122.389738853189 | (37.7887430032356, -122.389738853189) | 6 | 2 | 9 | 28855 | 6 | ||
| 94370 | 199668 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1903 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015186.9182 | 2093384.6973 | 37.728889017268 | -122.389748698946 | (37.728889017268, -122.389748698946) | 10 | 3 | 8 | 58 | 1 | |||
| 32288 | 190505 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 648 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015586.39221 | 2113251.98255 | 37.7834625052232 | -122.389754779275 | (37.7834625052232, -122.389754779275) | 6 | 2 | 9 | 28856 | 6 | |||
| 63527 | 190608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015462.45363 | 2107535.18496 | 37.7677585760219 | -122.389784125064 | (37.7677585760219, -122.389784125064) | 14 | 3 | 9 | 310 | 20 | |||
| 103647 | 44198 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015613.21564 | 2115159.68111 | 37.7887020993715 | -122.389795273027 | (37.7887020993715, -122.389795273027) | 6 | 2 | 9 | 28855 | 6 | ||
| 184190 | 44197 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015604.12637 | 2115150.5006 | 37.7886763877505 | -122.389826079337 | (37.7886763877505, -122.389826079337) | 6 | 2 | 9 | 28855 | 6 | ||
| 53994 | 192462 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 833 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015373.65288 | 2103902.76148 | 37.7577798011236 | -122.38983752498 | (37.7577798011236, -122.38983752498) | 10 | 3 | 8 | 28856 | 29 | |||
| 174857 | 53142 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1498@ KEITH Underwood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
| 132960 | 44196 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015590.27485 | 2115136.01269 | 37.7886358391193 | -122.389872991572 | (37.7886358391193, -122.389872991572) | 6 | 2 | 9 | 28855 | 6 | ||
| 113517 | 190485 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015539.69218 | 2113369.9861 | 37.7837839265342 | -122.38992459017 | (37.7837839265342, -122.38992459017) | 6 | 2 | 9 | 28856 | 6 | |||
| 138882 | 190607 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015421.42625 | 2107533.65832 | 37.7677521089958 | -122.389925928363 | (37.7677521089958, -122.389925928363) | 14 | 3 | 9 | 310 | 20 | |||
| 125332 | 190486 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015531.29876 | 2113374.48851 | 37.7837958236503 | -122.389953943122 | (37.7837958236503, -122.389953943122) | 6 | 2 | 9 | 28856 | 6 | |||
| 153260 | 190487 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015525.84147 | 2113384.34733 | 37.7838225910846 | -122.389973512379 | (37.7838225910846, -122.389973512379) | 6 | 2 | 9 | 28856 | 6 | |||
| 29266 | 192461 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 847 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015322.83777 | 2103901.69032 | 37.7577740418449 | -122.390013191359 | (37.7577740418449, -122.390013191359) | 10 | 3 | 8 | 28856 | 29 | |||
| 75979 | 190606 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015393.80416 | 2107532.25368 | 37.76774672026 | -122.390021372499 | (37.76774672026, -122.390021372499) | 14 | 3 | 9 | 310 | 20 | |||
| 92804 | 190591 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015405.78137 | 2108280.36173 | 37.7698015254385 | -122.390032211124 | (37.7698015254385, -122.390032211124) | 14 | 3 | 9 | 310 | 20 | |||
| 149010 | 46119 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | 6 | 2 | 9 | 28855 | 6 | |||
| 143843 | 190592 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015387.1631 | 2108279.22626 | 37.7697973750821 | -122.390096532449 | (37.7697973750821, -122.390096532449) | 14 | 3 | 9 | 310 | 20 | |||
| 123031 | 190605 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015358.34087 | 2107532.97001 | 37.7677467202638 | -122.390144086798 | (37.7677467202638, -122.390144086798) | 14 | 3 | 9 | 310 | 20 | |||
| 173043 | 190593 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015368.52983 | 2108277.33516 | 37.7697911490645 | -122.390160852856 | (37.7697911490645, -122.390160852856) | 14 | 3 | 9 | 310 | 20 | |||
| 106208 | 190415 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1799 Indiana St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6015204.21504 | 2100274.26045 | 37.7478073070623 | -122.390170025934 | (37.7478073070623, -122.390170025934) | 3 | 8 | 58 | 1 | ||||
| 33551 | 190594 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015350.67018 | 2108276.18439 | 37.7697869987055 | -122.390222549028 | (37.7697869987055, -122.390222549028) | 14 | 3 | 9 | 310 | 20 | |||
| 65581 | 190604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015329.13458 | 2107531.20473 | 37.7677402532417 | -122.390244985313 | (37.7677402532417, -122.390244985313) | 14 | 3 | 9 | 310 | 20 | |||
| 165771 | 190595 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015340.01826 | 2108274.88769 | 37.7697828474209 | -122.39025930344 | (37.7697828474209, -122.39025930344) | 14 | 3 | 9 | 310 | 20 | |||
| 108719 | 190488 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015434.43193 | 2113480.36737 | 37.7840811704488 | -122.390296468815 | (37.7840811704488, -122.390296468815) | 6 | 2 | 9 | 28856 | 6 | |||
| 155749 | 190596 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015327.51547 | 2108275.8962 | 37.7697849230597 | -122.390302621093 | (37.7697849230597, -122.390302621093) | 14 | 3 | 9 | 310 | 20 | |||
| 178345 | 190489 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015419.98604 | 2113488.70595 | 37.7841032649961 | -122.390347029604 | (37.7841032649961, -122.390347029604) | 6 | 2 | 9 | 28856 | 6 | |||
| 67855 | 190603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015296.80797 | 2107531.07269 | 37.7677380975679 | -122.390356790834 | (37.7677380975679, -122.390356790834) | 14 | 3 | 9 | 310 | 20 | |||
| 77907 | 190597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015311.55248 | 2108274.70714 | 37.7697807726996 | -122.390357754025 | (37.7697807726996, -122.390357754025) | 14 | 3 | 9 | 310 | 20 | |||
| 74785 | 190490 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015415.34325 | 2113497.18941 | 37.7841263011177 | -122.390363685055 | (37.7841263011177, -122.390363685055) | 6 | 2 | 9 | 28856 | 6 | |||
| 48248 | 190519 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299 Bryant St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6015412.94784 | 2114035.02216 | 37.785602934875 | -122.390409563945 | (37.785602934875, -122.390409563945) | 6 | 2 | 9 | 28855 | 6 | |||
| 57584 | 190602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015271.57365 | 2107530.7974 | 37.7677359418886 | -122.390444054766 | (37.7677359418886, -122.390444054766) | 14 | 3 | 9 | 310 | 20 | |||
| 116874 | 190518 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299 Bryant St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6015402.02385 | 2114023.64667 | 37.785571094386 | -122.390446562985 | (37.785571094386, -122.390446562985) | 6 | 2 | 9 | 28856 | 6 | |||
| 57611 | 190598 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015283.47377 | 2108274.89643 | 37.7697797348675 | -122.390454891574 | (37.7697797348675, -122.390454891574) | 14 | 3 | 9 | 310 | 20 | |||
| 32595 | 190599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015261.35764 | 2108269.67472 | 37.7697641703179 | -122.390531026393 | (37.7697641703179, -122.390531026393) | 14 | 3 | 9 | 310 | 20 | |||
| 144706 | 190601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015245.92181 | 2107529.35278 | 37.7677305522582 | -122.390532681139 | (37.7677305522582, -122.390532681139) | 14 | 3 | 9 | 310 | 20 | |||
| 3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
| 77075 | 190491 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015329.13045 | 2113592.35808 | 37.7843828300441 | -122.390668605586 | (37.7843828300441, -122.390668605586) | 6 | 2 | 9 | 28856 | 6 | |||
| 12103 | 192453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015095.71997 | 2102505.07691 | 37.7539266405026 | -122.390701069299 | (37.7539266405026, -122.390701069299) | 10 | 3 | 8 | 28856 | 29 | |||
| 68113 | 192455 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015093.59636 | 2102524.29003 | 37.7539792778315 | -122.390709755862 | (37.7539792778315, -122.390709755862) | 10 | 3 | 8 | 28856 | 29 | |||
| 121844 | 192456 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015093.79168 | 2102540.14695 | 37.7540228284037 | -122.390710188432 | (37.7540228284037, -122.390710188432) | 10 | 3 | 8 | 28856 | 29 | |||
| 185816 | 192474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6015149.97171 | 2105400.79096 | 37.7618806610754 | -122.390715797509 | (37.7618806610754, -122.390715797509) | 10 | 3 | 8 | 28856 | 29 | |||
| 108742 | 192454 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015091.94103 | 2102559.61264 | 37.7540761743788 | -122.390717948692 | (37.7540761743788, -122.390717948692) | 10 | 3 | 8 | 28856 | 29 | |||
| 119252 | 192473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6015149.47337 | 2105409.76647 | 37.7619052782381 | -122.390718148338 | (37.7619052782381, -122.390718148338) | 10 | 3 | 8 | 28856 | 29 | |||
| 163207 | 69703 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49180 | 6015090.38385 | 2102591.00196 | 37.7541622763905 | -122.390725527263 | (37.7541622763905, -122.390725527263) | 10 | 3 | 8 | 28856 | 29 | |
| 12208 | 190492 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015312.24709 | 2113599.76666 | 37.7844022356283 | -122.390727534552 | (37.7844022356283, -122.390727534552) | 6 | 2 | 9 | 28856 | 6 | |||
| 8238 | 195098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6015116.41348 | 2103939.58285 | 37.7578666360554 | -122.390729746003 | (37.7578666360554, -122.390729746003) | 10 | 3 | 8 | 28856 | 29 | |||
| 187838 | 91403 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49180 | 6015088.57959 | 2102608.00108 | 37.7542088522599 | -122.390732954759 | (37.7542088522599, -122.390732954759) | 10 | 3 | 8 | 28856 | 29 | |
| 48594 | 192472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015145.36132 | 2105441.65157 | 37.7619925996904 | -122.39073459873 | (37.7619925996904, -122.39073459873) | 10 | 3 | 8 | 28856 | 29 | |||
| 157282 | 91404 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49180 | 6015087.61328 | 2102623.7426 | 37.7542520215171 | -122.390737396521 | (37.7542520215171, -122.390737396521) | 10 | 3 | 8 | 28856 | 29 | |
| 131545 | 192457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1265 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015087.18064 | 2102641.6871 | 37.7543012692979 | -122.390740146648 | (37.7543012692979, -122.390740146648) | 10 | 3 | 8 | 28856 | 29 | |||
| 103500 | 192458 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1265 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015085.75738 | 2102659.02211 | 37.7543487885865 | -122.390746280033 | (37.7543487885865, -122.390746280033) | 10 | 3 | 8 | 28856 | 29 | |||
| 73011 | 190493 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015305.91458 | 2113614.18637 | 37.784441477541 | -122.390750451073 | (37.784441477541, -122.390750451073) | 6 | 2 | 9 | 28856 | 6 | |||
| 107634 | 192475 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1800 04th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015139.80289 | 2106985.00794 | 37.7662300127221 | -122.390861689138 | (37.7662300127221, -122.390861689138) | 14 | 3 | 9 | 310 | 29 | |||
| 18366 | 39267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.71354 | 37.7844122333873 | -122.390951435185 | (37.7844122333873, -122.390951435185) | 6 | 2 | 9 | 28856 | 6 |
| 8668 | 39268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015240.80145 | 2113614.13929 | 37.7844377354544 | -122.390975718675 | (37.7844377354544, -122.390975718675) | 6 | 2 | 9 | 28856 | 6 |
| 162684 | 190483 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015282.56856 | 2116157.59572 | 37.7914238022235 | -122.391009048433 | (37.7914238022235, -122.391009048433) | 6 | 2 | 9 | 28855 | 6 | |||
| 72002 | 190481 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015282.68617 | 2116181.17714 | 37.7914885578894 | -122.391010290399 | (37.7914885578894, -122.391010290399) | 6 | 2 | 9 | 28855 | 6 | |||
| 116493 | 190484 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015281.39646 | 2116135.10761 | 37.7913619900209 | -122.39101153146 | (37.7913619900209, -122.39101153146) | 6 | 2 | 9 | 28855 | 6 | |||
| 14813 | 190494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.391038840285 | (37.7846736447102, -122.391038840285) | 6 | 2 | 9 | 28856 | 6 | |||
| 89794 | 256008 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Main St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 181415 | 190479 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6015266.16724 | 2116198.30541 | 37.7915346715264 | -122.391068643817 | (37.7915346715264, -122.391068643817) | 6 | 2 | 9 | 28855 | 6 | |||
| 67829 | 190480 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015265.33201 | 2116174.73849 | 37.7914699158538 | -122.391069885787 | (37.7914699158538, -122.391069885787) | 6 | 2 | 9 | 28855 | 6 | |||
| 192985 | 190482 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015263.83745 | 2116154.04357 | 37.7914130094428 | -122.39107360987 | (37.7914130094428, -122.39107360987) | 6 | 2 | 9 | 28855 | 6 | |||
| 130183 | 190495 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015210.04745 | 2113708.94131 | 37.7846963337125 | -122.391088746357 | (37.7846963337125, -122.391088746357) | 6 | 2 | 9 | 28856 | 6 | |||
| 171362 | 190496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015207.26145 | 2113719.36295 | 37.7847247945658 | -122.391099113758 | (37.7847247945658, -122.391099113758) | 6 | 2 | 9 | 28856 | 6 | |||
| 105155 | 190504 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015179.46749 | 2113662.79105 | 37.7845679186069 | -122.391191316724 | (37.7845679186069, -122.391191316724) | 6 | 2 | 9 | 28856 | 6 | |||
| 17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
| 34172 | 116641 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
| 177060 | 116640 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
| 40641 | 190503 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015171.61041 | 2113671.63758 | 37.7845917731364 | -122.39121911838 | (37.7845917731364, -122.39121911838) | 6 | 2 | 9 | 28856 | 6 | |||
| 110216 | 190497 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015173.48225 | 2113768.99692 | 37.7848592036193 | -122.391219450233 | (37.7848592036193, -122.391219450233) | 6 | 2 | 9 | 28856 | 6 | |||
| 169506 | 190498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015168.4177 | 2113757.9053 | 37.7848284674924 | -122.391236196486 | (37.7848284674924, -122.391236196486) | 6 | 2 | 9 | 28856 | 6 | |||
| 128071 | 190502 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015161.53861 | 2113681.89794 | 37.7846193868054 | -122.391254681168 | (37.7846193868054, -122.391254681168) | 6 | 2 | 9 | 28856 | 6 | |||
| 53850 | 190500 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015162.33133 | 2113721.119 | 37.7847271229092 | -122.391254681181 | (37.7847271229092, -122.391254681181) | 6 | 2 | 9 | 28856 | 6 | |||
| 132365 | 190499 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015162.25299 | 2113733.75635 | 37.78476181785 | -122.391255835897 | (37.78476181785, -122.391255835897) | 6 | 2 | 9 | 28856 | 6 | |||
| 9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
| 160807 | 190501 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015159.193 | 2113714.53194 | 37.7847088621733 | -122.391265078242 | (37.7847088621733, -122.391265078242) | 6 | 2 | 9 | 28856 | 6 | |||
| 85050 | 198739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Main St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | 6015183.09065 | 2115200.65141 | 37.7887907329425 | -122.391286320207 | (37.7887907329425, -122.391286320207) | 6 | 2 | 9 | 28855 | 6 | ||||
| 9806 | 81718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576085 | (37.7581095159642, -122.39130576085) | 10 | 3 | 8 | 28856 | 29 | |||
| 15486 | 81720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014948.39032 | 2104075.36829 | 37.7582301501175 | -122.39132033706 | (37.7582301501175, -122.39132033706) | 10 | 3 | 8 | 28856 | 29 | |||
| 3402 | 81722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.391338017739 | (37.758352394954, -122.391338017739) | 10 | 3 | 8 | 28856 | 29 | |||
| 89721 | 192459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 651 Indiana St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6014938.71006 | 2105394.68115 | 37.7618521615646 | -122.391446047021 | (37.7618521615646, -122.391446047021) | 10 | 3 | 8 | 28856 | 29 | |||
| 187770 | 192468 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014906.49786 | 2103925.69197 | 37.7578168459985 | -122.391454756925 | (37.7578168459985, -122.391454756925) | 10 | 3 | 8 | 28856 | 29 | |||
| 122459 | 192460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 651 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6014934.12052 | 2105449.30544 | 37.7620018933059 | -122.391465739479 | (37.7620018933059, -122.391465739479) | 10 | 3 | 8 | 28856 | 29 | |||
| 178144 | 192469 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014870.03943 | 2103923.77532 | 37.7578095596756 | -122.39158071238 | (37.7578095596756, -122.39158071238) | 10 | 3 | 8 | 28856 | 29 | |||
| 123829 | 113852 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x REVERE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6014672 | 2094788 | 37.7327136355619 | -122.391626895226 | (37.7327136355619, -122.391626895226) | 10 | 3 | 8 | 58 | 1 | ||||
| 169745 | 192470 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014832.70201 | 2103922.31866 | 37.7578034874588 | -122.39170973991 | (37.7578034874588, -122.39170973991) | 10 | 3 | 8 | 28856 | 29 | |||
| 66447 | 113853 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6014630.01977 | 2094781.38525 | 37.7326931424693 | -122.391771570129 | (37.7326931424693, -122.391771570129) | 10 | 3 | 8 | 58 | 1 | |||
| 141738 | 113854 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6014619.79287 | 2094788.95809 | 37.7327133682248 | -122.391807456662 | (37.7327133682248, -122.391807456662) | 10 | 3 | 8 | 58 | 1 | |||
| 83438 | 192471 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 22nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6014799.35155 | 2103920.33928 | 37.7577962011557 | -122.391824942193 | (37.7577962011557, -122.391824942193) | 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) );