trees
390 rows where qSpecies_id = 126 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3638 | 72610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.394048777632 | (37.7523970151345, -122.394048777632) | 10 | 3 | 8 | 28856 | 1 | |||
| 5902 | 98813 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6011920.40954 | 2099763.49202 | 37.7462221629395 | -122.401489439087 | (37.7462221629395, -122.401489439087) | 10 | 3 | 8 | 58 | 1 | |||
| 6982 | 72625 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014103.8148 | 2101960.56144 | 37.7523764359486 | -122.394093219441 | (37.7523764359486, -122.394093219441) | 10 | 3 | 8 | 28856 | 1 | |||
| 9749 | 73730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6014041.4845 | 2095157.58141 | 37.7336934116182 | -122.393832621075 | (37.7336934116182, -122.393832621075) | 10 | 3 | 8 | 58 | 1 | |||
| 10986 | 199613 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1650 Davidson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6014432.23191 | 2099824.22542 | 37.7465287570926 | -122.392808046859 | (37.7465287570926, -122.392808046859) | 10 | 3 | 8 | 58 | 1 | |||
| 13934 | 199608 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6016247.68812 | 2100671.01808 | 37.7489545425207 | -122.386589376117 | (37.7489545425207, -122.386589376117) | 10 | 3 | 8 | 58 | 1 | |||
| 27493 | 98814 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | 10 | 3 | 8 | 58 | 1 | |||
| 33914 | 202077 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | 10 | 3 | 8 | 58 | 1 | ||||
| 44320 | 199612 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1570 Michigan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6016520.08797 | 2100945.2789 | 37.7497226822544 | -122.385666519716 | (37.7497226822544, -122.385666519716) | 10 | 3 | 8 | 58 | 1 | ||||
| 46515 | 202076 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | 10 | 3 | 8 | 58 | 1 | ||||
| 57688 | 199617 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1670 Armstrong Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6013996.30242 | 2092813.56299 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | 10 | 3 | 8 | 58 | 1 | ||||
| 64145 | 199616 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1999 Revere Ave | 7 | Side Yard : Yard | Tree | Private 2 | 3 | 6013002.21254 | 2095907.198 | 37.7356938932469 | -122.397478268519 | (37.7356938932469, -122.397478268519) | 10 | 3 | 8 | 58 | 1 | ||||
| 71483 | 256066 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.389986064473 | (37.7225535544976, -122.389986064473) | 10 | 3 | 8 | 58 | 1 | ||||
| 72509 | 199520 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016073.01766 | 2101191.4647 | 37.7503739092406 | -122.387229690715 | (37.7503739092406, -122.387229690715) | 10 | 3 | 8 | 28856 | 1 | |||
| 73061 | 200489 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1086 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6013557.4449 | 2089988.7054 | 37.7194738134712 | -122.395144165456 | (37.7194738134712, -122.395144165456) | 10 | 3 | 8 | 58 | 1 | |||
| 73821 | 65394 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1989 12:00:00 AM | 53 | Permit Number 28237 | 6011952.10102 | 2099776.9681 | 37.7462609336071 | -122.401380800085 | (37.7462609336071, -122.401380800085) | 10 | 3 | 8 | 58 | 1 | ||
| 77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
| 82286 | 199611 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6016252.0382 | 2100646.27412 | 37.748886841561 | -122.386572608245 | (37.748886841561, -122.386572608245) | 10 | 3 | 8 | 58 | 1 | |||
| 86416 | 199615 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 56 | Median : Yard | Tree | DPW 1 | 20 | 6014226.56708 | 2095397.27479 | 37.7343618444247 | -122.393209497917 | (37.7343618444247, -122.393209497917) | 10 | 3 | 8 | 58 | 1 | ||||
| 86485 | 108262 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6012679.64923 | 2090646.14976 | 37.7212301687063 | -122.398224504378 | (37.7212301687063, -122.398224504378) | 10 | 3 | 8 | 58 | 1 | ||||
| 89610 | 199620 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | 10 | 3 | 8 | 58 | 1 | ||||
| 91673 | 181300 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 3 | Front Yard : Yard | Tree | Private 2 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.7127036658128 | -122.396679845022 | (37.7127036658128, -122.396679845022) | 10 | 3 | 8 | 58 | 1 | |||
| 92728 | 181301 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013065.73831 | 2087544.18077 | 37.7127342778318 | -122.396672550617 | (37.7127342778318, -122.396672550617) | 10 | 3 | 8 | 58 | 1 | |||
| 93876 | 181302 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013064.24149 | 2087553.26 | 37.7127591242993 | -122.396678360222 | (37.7127591242993, -122.396678360222) | 10 | 3 | 8 | 58 | 1 | |||
| 97857 | 199618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 4 | Side Yard : Yard | Tree | Private 2 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | 10 | 3 | 8 | 58 | 1 | ||||
| 106347 | 199609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 7ft | 6016246.85574 | 2100664.26356 | 37.7489359499297 | -122.386591783589 | (37.7489359499297, -122.386591783589) | 10 | 3 | 8 | 58 | 1 | |||
| 110384 | 113843 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1709 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6014550.22753 | 2094753.99244 | 37.7326134976031 | -122.392045518911 | (37.7326134976031, -122.392045518911) | 10 | 3 | 8 | 58 | 1 | |||
| 114215 | 202075 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6012687.55592 | 2090674.96794 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | 10 | 3 | 8 | 58 | 1 | ||||
| 122630 | 199621 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2330 Lane St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.393920294208 | (37.7276170037228, -122.393920294208) | 10 | 3 | 8 | 58 | 1 | ||||
| 131503 | 202074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | 6012682.24985 | 2090663.29707 | 37.7212773966172 | -122.398216717151 | (37.7212773966172, -122.398216717151) | 10 | 3 | 8 | 58 | 1 | ||||
| 137217 | 201522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 863 Innes Ave | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6019436.46936 | 2094253.96379 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | 10 | 3 | 8 | 58 | 1 | |||
| 138430 | 199622 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014049.74697 | 2095137.71082 | 37.7336393102124 | -122.393802664676 | (37.7336393102124, -122.393802664676) | 10 | 3 | 8 | 58 | 1 | ||||
| 140704 | 29538 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015154.8066584 | 2091194.1931941 | 37.7228725479476 | -122.389706778167 | (37.7228725479476, -122.389706778167) | 10 | 3 | 8 | 58 | 1 | |||
| 142127 | 199565 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6014128.38291 | 2101966.7218 | 37.7523947164539 | -122.394008689474 | (37.7523947164539, -122.394008689474) | 10 | 3 | 8 | 28856 | 1 | ||||
| 144206 | 98817 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6011799.60927 | 2099715.83427 | 37.7460845639436 | -122.401903804432 | (37.7460845639436, -122.401903804432) | 10 | 3 | 8 | 58 | 1 | |||
| 157827 | 202079 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962063 | -122.398009040306 | (37.721779962063, -122.398009040306) | 10 | 3 | 8 | 58 | 1 | ||||
| 160694 | 199610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 7ft | 6016248.6287 | 2100650.91711 | 37.7488994014987 | -122.386584722116 | (37.7488994014987, -122.386584722116) | 10 | 3 | 8 | 58 | 1 | |||
| 163671 | 46635 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1571 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 3 | Permit Number 44756 | 6014716.9997 | 2093587.5042 | 37.7294198145801 | -122.391387425418 | (37.7294198145801, -122.391387425418) | 10 | 3 | 8 | 58 | 1 | |
| 180454 | 181303 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 6 | Front Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6013062.58437 | 2087561.0422 | 37.712780400456 | -122.396684633014 | (37.712780400456, -122.396684633014) | 10 | 3 | 8 | 58 | 1 | |||
| 186956 | 199619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 5 | Side Yard : Yard | Tree | Private 2 | 22 | 6013984.3244 | 2092869.9258 | 37.7274087980523 | -122.393870163286 | (37.7274087980523, -122.393870163286) | 10 | 3 | 8 | 58 | 1 | ||||
| 193936 | 200175 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.393994895467 | (37.7188192082582, -122.393994895467) | 10 | 3 | 8 | 58 | 1 | |||
| 48352 | 30689 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | 7 | 9 | 11 | 28852 | 10 | |
| 17741 | 74618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | 11 | 6 | 2 | 54 | 11 | |||
| 38078 | 38815 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.7847379015342 | -122.461232820546 | (37.7847379015342, -122.461232820546) | 11 | 6 | 2 | 54 | 11 | |
| 25867 | 217494 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1834 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993466.4471 | 2102963.36193 | 37.7539612311319 | -122.465532871667 | (37.7539612311319, -122.465532871667) | 1 | 8 | 4 | 56 | 12 | |||
| 43895 | 217495 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1834 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993465.96971 | 2102985.66158 | 37.7540224326934 | -122.465536142479 | (37.7540224326934, -122.465536142479) | 1 | 8 | 4 | 56 | 12 | |||
| 76379 | 217491 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1213 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991098.23401 | 2105172.09937 | 37.7598889667237 | -122.473883760333 | (37.7598889667237, -122.473883760333) | 1 | 8 | 4 | 56 | 12 | |||
| 113310 | 217490 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1219 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5991058.25824 | 2105170.14194 | 37.759881276613 | -122.474021872835 | (37.759881276613, -122.474021872835) | 1 | 8 | 4 | 56 | 12 | |||
| 130546 | 217492 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991111.74461 | 2105172.65449 | 37.7598912734774 | -122.473837074718 | (37.7598912734774, -122.473837074718) | 1 | 8 | 4 | 56 | 12 | |||
| 140547 | 217488 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1444 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5991174.83832 | 2105560.10023 | 37.7609587507553 | -122.473647129814 | (37.7609587507553, -122.473647129814) | 1 | 8 | 4 | 56 | 12 | |||
| 143474 | 217489 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1454 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 5ft | 5991178.64998 | 2105485.00303 | 37.7607527745534 | -122.473628468877 | (37.7607527745534, -122.473628468877) | 1 | 8 | 4 | 56 | 12 | |||
| 174970 | 217493 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 15th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | 1 | 8 | 4 | 56 | 12 | ||||
| 24332 | 45455 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.7808170441833 | -122.453879118533 | (37.7808170441833, -122.453879118533) | 11 | 6 | 2 | 54 | 16 | |||
| 91495 | 141022 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 170 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998548.3551 | 2112697.1941 | 37.7809796623886 | -122.448659524594 | (37.7809796623886, -122.448659524594) | 15 | 6 | 2 | 54 | 16 | |||
| 128514 | 138257 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600 GEARY BLVD | 2 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5999359.7213 | 2113228.3471 | 37.7824844323354 | -122.445890830511 | (37.7824844323354, -122.445890830511) | 15 | 5 | 1 | 54 | 16 | |||
| 140504 | 141108 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 241 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998156.9703 | 2112901.0932 | 37.7815171285351 | -122.450028212116 | (37.7815171285351, -122.450028212116) | 15 | 6 | 2 | 54 | 16 | |||
| 169978 | 141021 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 160 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998570.6909 | 2112701.5936 | 37.7809930194286 | -122.448582571297 | (37.7809930194286, -122.448582571297) | 15 | 6 | 2 | 54 | 16 | |||
| 30414 | 137512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3801 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002485.01335 | 2121661.73834 | 37.8058183005296 | -122.435682245137 | (37.8058183005296, -122.435682245137) | 13 | 9 | 1 | 57 | 17 | |||
| 39249 | 137508 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 41 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001758.83711 | 2121302.73589 | 37.8047913017375 | -122.43816954959 | (37.8047913017375, -122.43816954959) | 13 | 9 | 1 | 57 | 17 | |||
| 73840 | 137515 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1695 North Point St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002752.50077 | 2120921.11086 | 37.8037999223881 | -122.434703571417 | (37.8037999223881, -122.434703571417) | 13 | 9 | 1 | 57 | 17 | |||
| 100739 | 137513 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3801 Webster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002487.07577 | 2121653.72776 | 37.8057964227428 | -122.435674534362 | (37.8057964227428, -122.435674534362) | 13 | 9 | 1 | 57 | 17 | |||
| 109756 | 137514 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3633 Webster St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6002566.08313 | 2121090.50651 | 37.8042544532535 | -122.435360804076 | (37.8042544532535, -122.435360804076) | 13 | 9 | 1 | 57 | 17 | |||
| 118908 | 137511 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5999352.14411 | 2119120.73554 | 37.7986629462994 | -122.446341064008 | (37.7986629462994, -122.446341064008) | 13 | 9 | 1 | 57 | 17 | |||
| 154627 | 137507 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1920 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 6ft | 6001011.39316 | 2121024.38101 | 37.8039844758743 | -122.440736171548 | (37.8039844758743, -122.440736171548) | 13 | 9 | 1 | 57 | 17 | |||
| 155221 | 137510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001467.72221 | 2119937.03312 | 37.8010248834562 | -122.439079041178 | (37.8010248834562, -122.439079041178) | 13 | 9 | 1 | 57 | 17 | |||
| 157080 | 137509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.8010231216701 | -122.439100597914 | (37.8010231216701, -122.439100597914) | 13 | 9 | 1 | 57 | 17 | |||
| 3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
| 13716 | 243963 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3450 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | 2 | 4 | 7 | 28859 | 19 | |||
| 23566 | 243983 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 23 Juri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 1ft | 6005990.8298 | 2101226.6861 | 37.749907121539 | -122.422097155577 | (37.749907121539, -122.422097155577) | 2 | 4 | 5 | 28859 | 19 | |||
| 45058 | 243960 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1485 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009591.25577 | 2100642.20365 | 37.7485046755637 | -122.409605408672 | (37.7485046755637, -122.409605408672) | 2 | 4 | 7 | 28859 | 19 | |||
| 51671 | 243965 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 60 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 73 | Width 5ft | 6005189.67155 | 2107490.26222 | 37.7670602101766 | -122.425313267905 | (37.7670602101766, -122.425313267905) | 8 | 4 | 5 | 28853 | 19 | |||
| 55430 | 243989 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6009946.1107 | 2104089.26664 | 37.7579894213916 | -122.408621455918 | (37.7579894213916, -122.408621455918) | 2 | 4 | 7 | 28859 | 19 | |||
| 68842 | 243984 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6009760.35156 | 2105514.40218 | 37.7618921157423 | -122.409364464996 | (37.7618921157423, -122.409364464996) | 8 | 4 | 8 | 28859 | 19 | |||
| 73318 | 243985 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 6 | : | Tree | Private 2 | 11 | Width 2ft | 6009720.47366 | 2105510.67179 | 37.7618796385691 | -122.409502124237 | (37.7618796385691, -122.409502124237) | 8 | 4 | 8 | 28859 | 19 | |||
| 98780 | 243987 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3098 25th St | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6009038.63911 | 2101607.11758 | 37.7511231326358 | -122.411584519713 | (37.7511231326358, -122.411584519713) | 2 | 4 | 7 | 28859 | 19 | |||
| 115507 | 243992 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 43 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6005443.40742 | 2108630.14777 | 37.7702043947487 | -122.424516723989 | (37.7702043947487, -122.424516723989) | 8 | 2 | 5 | 28853 | 19 | |||
| 116606 | 243961 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3725 26th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6005554.52967 | 2100776.99719 | 37.7486477612814 | -122.423573936807 | (37.7486477612814, -122.423573936807) | 2 | 4 | 5 | 28859 | 19 | |||
| 131808 | 243962 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3450 26th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006732.96766 | 2100887.37814 | 37.7490172891268 | -122.419506732173 | (37.7490172891268, -122.419506732173) | 2 | 4 | 7 | 28859 | 19 | |||
| 144992 | 253609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 318 Utah St | 2 | Front Yard : Yard | Tree | Private 2 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
| 169184 | 243988 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2766 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010155.45167 | 2102831.44612 | 37.754547449722 | -122.407808770075 | (37.754547449722, -122.407808770075) | 2 | 4 | 7 | 28859 | 19 | |||
| 172745 | 243964 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 979 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6011092.59342 | 2103787.62329 | 37.7572253196086 | -122.40463517678 | (37.7572253196086, -122.40463517678) | 10 | 4 | 8 | 28859 | 19 | |||
| 25390 | 246783 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 175 Brewster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010050.00115 | 2098693.85293 | 37.7431806261 | -122.407881696082 | (37.7431806261, -122.407881696082) | 10 | 7 | 7 | 28859 | 2 | ||||
| 33081 | 243978 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.426586604496 | (37.7359443031923, -122.426586604496) | 2 | 7 | 5 | 28861 | 2 | ||||
| 35549 | 243970 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006476.24786 | 2097234.87805 | 37.7389738835382 | -122.420135291714 | (37.7389738835382, -122.420135291714) | 2 | 7 | 7 | 28859 | 2 | |||
| 49371 | 244000 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 308 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008619.26951 | 2097248.33163 | 37.7391313386509 | -122.412726634432 | (37.7391313386509, -122.412726634432) | 10 | 7 | 7 | 28859 | 2 | |||
| 60644 | 243977 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 21 | 6004578.54944 | 2096162.87225 | 37.7359232905307 | -122.426620346145 | (37.7359232905307, -122.426620346145) | 2 | 7 | 5 | 28861 | 2 | ||||
| 80861 | 243975 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6007595.15715 | 2099522.63398 | 37.7453185340155 | -122.416428611787 | (37.7453185340155, -122.416428611787) | 2 | 7 | 7 | 28859 | 2 | ||||
| 91156 | 243980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 6 | 6004603.12758 | 2096184.79771 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | 2 | 7 | 5 | 28861 | 2 | ||||
| 98598 | 243976 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 18 | 6004556.64322 | 2096143.57753 | 37.7358690730924 | -122.426694711107 | (37.7358690730924, -122.426694711107) | 2 | 7 | 5 | 28861 | 2 | ||||
| 106455 | 243990 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008996.81508 | 2099767.79019 | 37.7460704023351 | -122.411599210152 | (37.7460704023351, -122.411599210152) | 2 | 7 | 7 | 28859 | 2 | |||
| 109382 | 246640 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | 2 | 7 | 7 | 28859 | 2 | ||||
| 110609 | 246641 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009029.72026 | 2099218.69445 | 37.744564552317 | -122.411446641953 | (37.744564552317, -122.411446641953) | 2 | 7 | 7 | 28859 | 2 | ||||
| 111351 | 243972 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 5ft | 6006470.84619 | 2097224.25216 | 37.7389444028574 | -122.42015321432 | (37.7389444028574, -122.42015321432) | 2 | 7 | 7 | 28859 | 2 | |||
| 124548 | 243974 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6007544.45686 | 2099548.29836 | 37.7453861513651 | -122.416605743182 | (37.7453861513651, -122.416605743182) | 2 | 7 | 7 | 28859 | 2 | ||||
| 124731 | 243969 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006478.44335 | 2097240.82056 | 37.7389903240494 | -122.420128122327 | (37.7389903240494, -122.420128122327) | 2 | 7 | 7 | 28859 | 2 | |||
| 129571 | 243991 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 285 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010375.28221 | 2100026.37606 | 37.7468576499657 | -122.406850849112 | (37.7468576499657, -122.406850849112) | 2 | 7 | 7 | 28859 | 2 | |||
| 131547 | 243973 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 6006467.40316 | 2097218.12858 | 37.7389273948737 | -122.420164684273 | (37.7389273948737, -122.420164684273) | 2 | 7 | 7 | 28859 | 2 | |||
| 144256 | 243981 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 11 | 6004609.84648 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | 2 | 7 | 5 | 28861 | 2 | ||||
| 151620 | 246743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 140 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6008904.95931 | 2099075.94101 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | 2 | 7 | 7 | 28859 | 2 | ||||
| 156896 | 243982 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 200 Kingston St | 16 | Front Yard : Yard | Tree | Private 2 | 3 | 6006211.87378 | 2098086.29455 | 37.741296782931 | -122.421109815985 | (37.741296782931, -122.421109815985) | 2 | 7 | 7 | 28859 | 2 |
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) );