trees
1,914 rows where qSpecies_id = 45 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3262 | 143122 | DPW Maintained 1 | :: 45 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | 13 | 9 | 1 | 57 | 17 | |||
| 3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
| 3549 | 141425 | DPW Maintained 1 | :: 45 | 301 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005907.6073 | 2110863.9151 | 37.7763639855674 | -122.423069853164 | (37.7763639855674, -122.423069853164) | 7 | 9 | 11 | 28852 | 10 | |||
| 3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
| 3862 | 260676 | DPW Maintained 1 | :: 45 | 108 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2019 12:00:00 AM | 3 | 3x3 | 5992434.1895 | 2114741.52104 | 37.7862413120358 | -122.469960148163 | (37.7862413120358, -122.469960148163) | 11 | 6 | 2 | 54 | 11 | ||
| 4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
| 4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
| 4746 | 67428 | DPW Maintained 1 | :: 45 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.7749321810162 | -122.475173477199 | (37.7749321810162, -122.475173477199) | 11 | 6 | 2 | 54 | 26 | |
| 4838 | 142080 | DPW Maintained 1 | :: 45 | 560 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000142.3776 | 2110889.4402 | 37.7761070510385 | -122.44301516716 | (37.7761070510385, -122.44301516716) | 15 | 5 | 11 | 29492 | 16 | |||
| 4931 | 185584 | DPW Maintained 1 | :: 45 | 2066 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986983.4623 | 2101205.4528 | 37.7487584406856 | -122.487823126868 | (37.7487584406856, -122.487823126868) | 1 | 8 | 3 | 29491 | 35 | |||
| 4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 5154 | 182781 | DPW Maintained 1 | :: 45 | 1742 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985353.0616 | 2103349.1064 | 37.7545490898351 | -122.493618895477 | (37.7545490898351, -122.493618895477) | 1 | 8 | 3 | 56 | 35 | |||
| 5156 | 182427 | DPW Maintained 1 | :: 45 | 1526 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985304.2975 | 2104805.6353 | 37.7585454628823 | -122.493894864934 | (37.7585454628823, -122.493894864934) | 1 | 8 | 3 | 56 | 35 | |||
| 5360 | 181929 | DPW Maintained 1 | :: 45 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | 1 | 8 | 3 | 29491 | 35 | |||
| 5762 | 182417 | DPW Maintained 1 | :: 45 | 1544 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984999.4264 | 2104687.6498 | 37.758203665255 | -122.494940531373 | (37.758203665255, -122.494940531373) | 1 | 8 | 3 | 56 | 35 | |||
| 5962 | 190650 | DPW Maintained 1 | :: 45 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.7609327945277 | -122.399177878376 | (37.7609327945277, -122.399177878376) | 10 | 3 | 8 | 28856 | 29 | |||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 6291 | 182272 | DPW Maintained 1 | :: 45 | 1494 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985296.227 | 2105059.6558 | 37.7592424604916 | -122.493941496366 | (37.7592424604916, -122.493941496366) | 1 | 8 | 3 | 56 | 35 | |||
| 6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
| 6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 6450 | 184722 | DPW Maintained 1 | :: 45 | 1643 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984666.6891 | 2104002.5093 | 37.7563029761962 | -122.496040718779 | (37.7563029761962, -122.496040718779) | 1 | 8 | 3 | 56 | 35 | |||
| 6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 6678 | 183829 | DPW Maintained 1 | :: 45 | 2214 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987634.5167 | 2100198.0441 | 37.7460303199634 | -122.485497894293 | (37.7460303199634, -122.485497894293) | 1 | 8 | 3 | 29491 | 35 | |||
| 6870 | 182679 | DPW Maintained 1 | :: 45 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.491113101083 | (37.7553883964845, -122.491113101083) | 1 | 8 | 3 | 56 | 35 | |||
| 6909 | 184218 | DPW Maintained 1 | :: 45 | 3441 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984096.8823 | 2104933.319 | 37.758825328706 | -122.49808001485 | (37.758825328706, -122.49808001485) | 1 | 8 | 3 | 56 | 35 | |||
| 7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
| 7142 | 183990 | DPW Maintained 1 | :: 45 | 1678 35th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985337.0123 | 2103802.0601 | 37.7557918369667 | -122.493707772777 | (37.7557918369667, -122.493707772777) | 1 | 8 | 3 | 56 | 35 | |||
| 7154 | 184667 | DPW Maintained 1 | :: 45 | 1675 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984673.0914 | 2103809.4296 | 37.7557732078979 | -122.496004334161 | (37.7557732078979, -122.496004334161) | 1 | 8 | 3 | 56 | 35 | |||
| 7226 | 139441 | DPW Maintained 1 | :: 45 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | 7 | 9 | 11 | 28852 | 10 | |||
| 7264 | 182773 | DPW Maintained 1 | :: 45 | 1 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985975.4571 | 2103368.6441 | 37.754639125693 | -122.491467955558 | (37.754639125693, -122.491467955558) | 1 | 8 | 3 | 56 | 35 | |||
| 7270 | 115892 | DPW Maintained 1 | :: 45 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.60834 | 37.75961937033 | -122.481684343854 | (37.75961937033, -122.481684343854) | 1 | 8 | 3 | 56 | 35 | |||
| 7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
| 7500 | 253261 | DPW Maintained 1 | :: 45 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2019 12:00:00 AM | 3 | 3x3 | 5990256 | 2113097 | 37.7815997636542 | -122.477375802178 | (37.7815997636542, -122.477375802178) | 11 | 6 | 2 | 55 | 26 | ||
| 7525 | 183813 | DPW Maintained 1 | :: 45 | 2101 Rivera St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986596.0486 | 2100254.1602 | 37.7461238416302 | -122.489092856091 | (37.7461238416302, -122.489092856091) | 1 | 8 | 3 | 29491 | 35 | |||
| 7704 | 140222 | DPW Maintained 1 | :: 45 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003683.3616 | 2110416.1551 | 37.7750087812949 | -122.430732178175 | (37.7750087812949, -122.430732178175) | 7 | 9 | 11 | 29492 | 10 | |||
| 7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
| 7740 | 142745 | DPW Maintained 1 | :: 45 | 700x COLUMBUS AVE | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | 3 | 1 | 10 | 308 | 4 | |||
| 7759 | 181568 | DPW Maintained 1 | :: 45 | 1349 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984597.8609 | 2105995.9427 | 37.7617723563961 | -122.496425834494 | (37.7617723563961, -122.496425834494) | 1 | 8 | 3 | 56 | 35 | |||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 7819 | 184095 | DPW Maintained 1 | :: 45 | 1611 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985901.3945 | 2104240.0581 | 37.757027460882 | -122.491788227731 | (37.757027460882, -122.491788227731) | 1 | 8 | 3 | 56 | 35 | |||
| 7832 | 183984 | DPW Maintained 1 | :: 45 | 2420 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986737.6029 | 2103717.4696 | 37.755641413652 | -122.488857926532 | (37.755641413652, -122.488857926532) | 1 | 8 | 3 | 56 | 35 | |||
| 7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
| 7884 | 182867 | DPW Maintained 1 | :: 45 | 1841 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987504.2554 | 2102741.89 | 37.7530074484719 | -122.486135022058 | (37.7530074484719, -122.486135022058) | 1 | 8 | 3 | 56 | 35 | |||
| 8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 8481 | 70091 | DPW Maintained 1 | :: 45 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | 11 | 6 | 2 | 55 | 26 | ||
| 8635 | 182608 | DPW Maintained 1 | :: 45 | 1839 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985333.4224 | 2102688.337 | 37.7527336497539 | -122.493638125681 | (37.7527336497539, -122.493638125681) | 1 | 8 | 3 | 56 | 35 | |||
| 8688 | 183776 | DPW Maintained 1 | :: 45 | 2042 Santiago St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986449.4639 | 2099625.7878 | 37.7443899427786 | -122.489553521138 | (37.7443899427786, -122.489553521138) | 1 | 8 | 3 | 29491 | 35 | |||
| 8891 | 182186 | DPW Maintained 1 | :: 45 | 1638 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988430.2421 | 2104156.5357 | 37.75694560898 | -122.483036497181 | (37.75694560898, -122.483036497181) | 1 | 8 | 3 | 56 | 35 | |||
| 8915 | 253260 | DPW Maintained 1 | :: 45 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993234 | 2110465 | 37.7745453462497 | -122.466882031228 | (37.7745453462497, -122.466882031228) | 11 | 6 | 2 | 54 | 11 | ||||
| 8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
| 9196 | 182652 | DPW Maintained 1 | :: 45 | 1871 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987819.8145 | 2102562.9873 | 37.7525346157683 | -122.485030647048 | (37.7525346157683, -122.485030647048) | 1 | 8 | 3 | 56 | 35 | |||
| 9389 | 66602 | DPW Maintained 1 | :: 45 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.01912 | 37.7901127525459 | -122.416141207354 | (37.7901127525459, -122.416141207354) | 13 | 1 | 10 | 28858 | 21 | |
| 9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
| 9699 | 139024 | DPW Maintained 1 | :: 45 | 2511 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000470.0552 | 2114083.3913 | 37.7848955007169 | -122.442110965396 | (37.7848955007169, -122.442110965396) | 15 | 6 | 11 | 29490 | 13 | |||
| 9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
| 10097 | 182694 | DPW Maintained 1 | :: 45 | 1715 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985923.1814 | 2103540.9984 | 37.7551093083613 | -122.491661423134 | (37.7551093083613, -122.491661423134) | 1 | 8 | 3 | 56 | 35 | |||
| 10197 | 251293 | DPW Maintained 1 | :: 45 | 3789 Market St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6000208 | 2102740 | 37.753734455764 | -122.442203020617 | (37.753734455764, -122.442203020617) | 2 | 4 | 5 | 63 | 38 | ||||
| 10269 | 182332 | DPW Maintained 1 | :: 45 | 1494 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985606.7756 | 2105058.9207 | 37.7592586073358 | -122.492867430666 | (37.7592586073358, -122.492867430666) | 1 | 8 | 3 | 56 | 35 | |||
| 10776 | 219180 | DPW Maintained 1 | :: 45 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | 1 | 5 | 4 | 56 | 12 | |||
| 10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 10819 | 182695 | DPW Maintained 1 | :: 45 | 1710 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985039.9277 | 2103526.5304 | 37.7550179237557 | -122.49471485915 | (37.7550179237557, -122.49471485915) | 1 | 8 | 3 | 56 | 35 | |||
| 11022 | 25490 | DPW Maintained 1 | :: 45 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.97801 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | 15 | 5 | 11 | 29492 | 9 | ||
| 11222 | 182601 | DPW Maintained 1 | :: 45 | 1963 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985980.7032 | 2101872.2576 | 37.750530763347 | -122.491339684637 | (37.750530763347, -122.491339684637) | 1 | 8 | 3 | 29491 | 35 | |||
| 11414 | 173708 | DPW Maintained 1 | :: 45 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001214 | 2098705 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | 2 | 7 | 5 | 63 | 7 | ||||
| 12235 | 184717 | DPW Maintained 1 | :: 45 | 1630 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984088.6295 | 2104052.5482 | 37.7564064943727 | -122.498043512944 | (37.7564064943727, -122.498043512944) | 1 | 8 | 3 | 56 | 35 | |||
| 12259 | 259644 | DPW Maintained 1 | :: 45 | 242 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009897.37379 | 2088143.4673 | 37.7142029478201 | -122.40766570902 | (37.7142029478201, -122.40766570902) | 9 | 7 | 8 | 309 | 39 | ||
| 12298 | 182617 | DPW Maintained 1 | :: 45 | 1870 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986004.9641 | 2102510.2071 | 37.7522838165719 | -122.491302737104 | (37.7522838165719, -122.491302737104) | 1 | 8 | 3 | 56 | 35 | |||
| 12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
| 12463 | 184537 | DPW Maintained 1 | :: 45 | 1920 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981149.921 | 2101972.2688 | 37.7505219025706 | -122.508052026926 | (37.7505219025706, -122.508052026926) | 1 | 8 | 3 | 29491 | 35 | |||
| 12771 | 184293 | DPW Maintained 1 | :: 45 | 1547 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983406.1489 | 2104611.5311 | 37.7579012669465 | -122.500445060495 | (37.7579012669465, -122.500445060495) | 1 | 8 | 3 | 56 | 35 | |||
| 12777 | 137758 | DPW Maintained 1 | :: 45 | 101 Saint Joseph's Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000707.9938 | 2112291.934 | 37.7799901751967 | -122.441159201538 | (37.7799901751967, -122.441159201538) | 15 | 5 | 1 | 29490 | 16 | |||
| 12815 | 261606 | DPW Maintained 1 | :: 45 | 108 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993739.19456 | 2089854.88419 | 37.7179843347129 | -122.463638343115 | (37.7179843347129, -122.463638343115) | 9 | 8 | 6 | 64 | 24 | |||||
| 12843 | 181862 | DPW Maintained 1 | :: 45 | 2334 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987972.6737 | 2099405.6778 | 37.7438743880052 | -122.484270504939 | (37.7438743880052, -122.484270504939) | 1 | 8 | 3 | 29491 | 35 | |||
| 12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
| 13184 | 185817 | DPW Maintained 1 | :: 45 | 2537 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987057.2145 | 2101634.1584 | 37.7499398526357 | -122.487599584974 | (37.7499398526357, -122.487599584974) | 1 | 8 | 3 | 29491 | 35 | |||
| 13222 | 181595 | DPW Maintained 1 | :: 45 | 1683 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984673.7654 | 2103756.5264 | 37.7556279898559 | -122.495998100633 | (37.7556279898559, -122.495998100633) | 1 | 8 | 3 | 56 | 35 | |||
| 13385 | 244231 | DPW Maintained 1 | :: 45 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.7720223304628 | -122.431614542708 | (37.7720223304628, -122.431614542708) | 15 | 9 | 11 | 29492 | 10 | |||
| 13524 | 182760 | DPW Maintained 1 | :: 45 | 1759 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985932.2165 | 2103268.4413 | 37.7543614693016 | -122.491610115485 | (37.7543614693016, -122.491610115485) | 1 | 8 | 3 | 56 | 35 | |||
| 13540 | 259645 | DPW Maintained 1 | :: 45 | 243 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009883.66375 | 2088105.89025 | 37.7140990014395 | -122.407710448479 | (37.7140990014395, -122.407710448479) | 9 | 7 | 8 | 309 | 39 | ||
| 13679 | 181829 | DPW Maintained 1 | :: 45 | 2305 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 4x6 | 5985752.5421 | 2099501.8742 | 37.7440089976812 | -122.491954176178 | (37.7440089976812, -122.491954176178) | 1 | 8 | 3 | 29491 | 35 | |||
| 13772 | 184591 | DPW Maintained 1 | :: 45 | 1751 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5983451.02 | 2103228.4905 | 37.7541064586728 | -122.500187636281 | (37.7541064586728, -122.500187636281) | 1 | 8 | 3 | 56 | 35 | |||
| 14295 | 185818 | DPW Maintained 1 | :: 45 | 2050 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989456.1302 | 2101394.5128 | 37.7494214709702 | -122.479286579382 | (37.7494214709702, -122.479286579382) | 1 | 8 | 3 | 29491 | 35 | |||
| 14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14473 | 246016 | DPW Maintained 1 | :: 45 | 1605 Haight St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 5998345.69 | 2108581.6399 | 37.7696678206354 | -122.449064074288 | (37.7696678206354, -122.449064074288) | 15 | 5 | 11 | 29492 | 9 | |||
| 14488 | 182431 | DPW Maintained 1 | :: 45 | 1550 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985622.7002 | 2104651.6438 | 37.7581412688876 | -122.492782358773 | (37.7581412688876, -122.492782358773) | 1 | 8 | 3 | 56 | 35 | |||
| 14593 | 184704 | DPW Maintained 1 | :: 45 | 1615 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984659.276 | 2104181.7734 | 37.756794751431 | -122.496079580355 | (37.756794751431, -122.496079580355) | 1 | 8 | 3 | 56 | 35 | |||
| 14703 | 183463 | DPW Maintained 1 | :: 45 | 2530 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988329.4378 | 2098069.925 | 37.7402275284168 | -122.482939034698 | (37.7402275284168, -122.482939034698) | 1 | 8 | 3 | 29491 | 35 | |||
| 14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14882 | 185772 | DPW Maintained 1 | :: 45 | 1907 20th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989998.872 | 2102362.4304 | 37.7521106251699 | -122.477480519353 | (37.7521106251699, -122.477480519353) | 1 | 8 | 3 | 29491 | 35 | |||
| 14972 | 183006 | DPW Maintained 1 | :: 45 | 2438 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989859.0631 | 2098748.8104 | 37.7421804576164 | -122.477699875038 | (37.7421804576164, -122.477699875038) | 1 | 8 | 3 | 29491 | 35 | |||
| 15236 | 185780 | DPW Maintained 1 | :: 45 | 1905 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986589.1657 | 2102275.5585 | 37.7516736541674 | -122.489265251741 | (37.7516736541674, -122.489265251741) | 1 | 8 | 3 | 29491 | 35 | |||
| 15261 | 183802 | DPW Maintained 1 | :: 45 | 1721 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987778.7543 | 2100296.1939 | 37.746308215746 | -122.485006345677 | (37.746308215746, -122.485006345677) | 1 | 8 | 3 | 29491 | 35 | |||
| 15400 | 112605 | DPW Maintained 1 | :: 45 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | 15 | 5 | 11 | 29492 | 16 |
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) );